Preview

Fac Case Study

Satisfactory Essays
Open Document
Open Document
650 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Fac Case Study
FAC Case Assignment

1. Describe FAC as a company and the challenges it faced in 1990s.
Founded in 1883, the First American Corporation (FAC) is the financial services holding company headquartered in Nashville, Tennessee. In 1990s, FAC faced the financial hardship because of low profitability and its losses. In order to overcome this hardship, the FAC began to change its organization and operations to implement customer-oriented strategy which called Tailored Client Solutions(TCS). This strategy could be implemented with Data warehouse technology which called VISION. 2. Describe the FAC warehouse project.
In short, the FAC warehouse project can be described as a 4steps. First, Collect internal and external raw data from many data sources. Second, Examine this raw data validity and purify the data by data extraction and transformation to store data into Data warehouse. Third, Analyze these data which stored and shared by the data warehouse to get proper and valuable information by using applications and tools. Fourth, with these information, the company implement customer-oriented strategies which can meet customer needs and make profit. This project was implemented with the phased development approach with solid business goals to get the efficient and effective results. 3. Provide the technical details of the data warehouse system implemented at FAC
FAC’s data warehouse platform was the NCR 5150M. It run the Teradata Relational Data Base System with 5 SMP nodes. This platform provided 1.5TB of data storage to FAC. Data from many sources like VSAM, IMS which stored in this storage could be accessed by dependent data mart created in an Oracle relational DBMS and Cognos cubes. The analysts in the company can analyze the profitability with tools called PAR which can be run by ad-hoc SQL queries and predefined reports. These kinds of analyzed data could be the information to decision makers by using VIEW in DBMS or many other

You May Also Find These Documents Helpful

  • Good Essays

    Nt1330 Unit 1 Case Study

    • 776 Words
    • 4 Pages

    The company also uses the databases from other catalogues sales companies and from internet. So therefore they will require large amount of user space which can be provided by Datacenter.…

    • 776 Words
    • 4 Pages
    Good Essays
  • Good Essays

    As a for-profit entity, my company must record the amount of the donation as an expense at the fair value of the donated asset. In this case, my company must recognized a loss of eight thousand dollars, simply because the fair value of my donated asset is two thousand dollars. Furthermore, I must update my books by debiting “Contribution Expense” and “Loss on disposal of x asset” for $2,000 and $8,000 crediting the asset for $10,000. In this case, the fair value of my asset was lower than its book value forcing me to recognize a loss on my contribution.…

    • 886 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    The story “A Good Man is Hard to Find,” written by Flannery O’Conner is a suspenseful short story that tells the tale of a family vacation gone wrong. Essentially, the grandma in the story leads the family off track to visit a plantation home that she believed existed in the area they were in. Unfortunately, the home was located in another state and her false recollections landed the family in a deathly situation with a run-away convict. The grandma, the protagonist of the story, is a prideful, persuasive, and talkative old lady. The persona of the grandma is developed by the way the narrator described her, the things the grandma does and says, and the actions of others towards the grandma.…

    • 698 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    In general conflict resolution is mostly concentrated on the conflicts that have occurred in the public. In this report I have tried to explain the circumstances that lead to conflict in workplace. This report analyses the situation using organizational behaviour concepts and gives an alternatives to avoid this kind of situations in future and my learning’s.…

    • 1522 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    team assignment week 4

    • 826 Words
    • 4 Pages

    The geographically distant operations make data gathering, integration and analysis a difficult task for the company giving it a drawback against other competitors in the market. Un-availability of data to the headquarters over a centralized database caused delays in financial reporting of the company. The delay caused by the disintegration of data was damaging to company’s image from the point of view of investors and stock market value. There was no in-time information regarding:…

    • 826 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Good Essays

    MSCC Case Study Final

    • 1052 Words
    • 4 Pages

    This case study outlines what Midsouth Chamber of Commerce (MSCC) went through when they acquired a new system to handle their operations. The new chief financial officer Saga Niele (CFO) and Information Systems (IS) manager was hired to clean up the Information Systems disaster at the MSCC. MSCC went through two unsuccessful system conversion failures primarily caused by mismanagement of technology, technical staffing and contract management. First getting the UNITRAK system with an IBM Server and then trying to move to the DMA system with a HP server. The new Information Systems manager must choose to modify the current system or implement a new information system solution to meet the growing demands of employees and members.…

    • 1052 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Hard Rock

    • 296 Words
    • 2 Pages

    The new systems and data warehouse are accessible through companywide intranet, allowing employee to look up customer detail and other information with just one click.…

    • 296 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Company: Delta Airline

    • 1591 Words
    • 7 Pages

    The information system of the delta airline is governed at different levels and stages. For managing all the information and data the company is using some E-commerce platforms and these platforms are using different techniques to gather the information of the business process. And according to the requirements of the company these systems are providing managed and organized data for different purposes.…

    • 1591 Words
    • 7 Pages
    Good Essays
  • Good Essays

    Optimism: hopefulness and confidence about the future. The warm-hearted feeling you receive when you take a step back and glance for a moment at the resilient, robust nation built around you. The nation where everyone is free to express their uniqueness in gender, race, religion, and sexual orientation. The nation with stout defense and solid guard throughout all branches of military. It’s not a surprise we have the world’s largest economy, and the dollar is the world’s reserve currency. We are the only Super Power on planet Earth, and that is something to be proud of. Something that should give you optimism when you think of our homeland’s future. As home to more than 316 million Americans, we have the potential to do great things. Things superior to Earth itself. America is a beacon of hope, hope for immigrants looking to start over and start living their lives anew, hope for technology advances in ways that are mind-blowing and seem unfeasible. Hope for energy, and living clean and green. And hope for the education of our future generations- those who will be running this powerhouse into the indefinite future and continuing our uphill battle to excellence. With so much in store for the United States of America, I am so optimistic about our nation’s future.…

    • 881 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    The Voip Adoption

    • 1699 Words
    • 7 Pages

    development that occurs? In order for real time data warehousing to work many elements are required. These include the mainframe reservation system, satellite feeds from airplanes, central customer database and all other data sources such as their website, customer service applications, frequent flyer programs and reservation systems. Each of these works together and for every change that is made it is sent back to the data warehouse and displayed or is available to all customers within minutes (Brown, DeHayes, Hoffer, Martin, and Perkins, 2003).…

    • 1699 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    Data Warehousing

    • 1687 Words
    • 7 Pages

    Data warehouses have a basic design with some variations. Data sources, warehouse and users make up the architect of the basic data warehouse. In our system we will be adding data marts and a staging area.…

    • 1687 Words
    • 7 Pages
    Better Essays
  • Good Essays

    Case Study

    • 487 Words
    • 2 Pages

    a data warehouse or enterprise data warehouse (DW, DWH, or EDW) is adatabase used for reporting and data analysis. It is a central repository of data which is created by integrating data from one or more disparate sources. Data warehouses store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.…

    • 487 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    os research paper 2013

    • 6803 Words
    • 28 Pages

    into a multidimensional database schema in order to discover dimensions that are hidden in a relational database.…

    • 6803 Words
    • 28 Pages
    Powerful Essays