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

  • Powerful Essays

    Storing Information: enhancing databases system to assist Tesco Mobile Phones have a bigger space for data storage. With the dominance of technology, Tesco Mobile has extra choices of storage from flash memory to network area storage. The ultimate solution is that Tesco Mobile may construct a single data warehouse where they can put all the necessary data about customers, suppliers, and financial companies. Every employee should have a personal ID to access the data not having the use of operational systems. To be able to succeed, Tesco Mobile has to fund or invest the highest speed network access to help database system work properly.…

    • 1202 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    F E Case Study

    • 458 Words
    • 2 Pages

    1. Mrs. Dean is 75-year-old woman admitted to the hospital for a small bowel obstruction. Her medical history includes hypertension. Mrs. Dean is NPO. She has a nasogastric (NG) tube to low continuous suction. She has an IV of 0.9% NS at 83 mL/hr. Current medications include furosemide 20 mg daily and hydromorphone 0.2 mg every 4 hours, as needed for pain. The morning electrolytes reveal serum potassium of 3.2 mEq/L. (Learning Objective 4)…

    • 458 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    MIS 563 COURSE PROJECT

    • 2795 Words
    • 12 Pages

    This finding has ABC University seeking a streamlined way to manage their data and for users to access the data that is clean. With this, the University has proposed the creation and implementation of a data warehouse to house all the data from each one of these operational databases into one central location where all students, staff and faculty can access the data using a self service tool such as a report or a data connection to Microsoft Excel to pull data into pivot tables.…

    • 2795 Words
    • 12 Pages
    Powerful Essays
  • 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

    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

    FAPE Case Study

    • 590 Words
    • 3 Pages

    While IDEA is a federal law, it places the responsibility of providing a free and appropriate public education to the local education agencies and the individual states. In accordance with the 10th amendment, establishing and overseeing a public education system is a power for individual states. While IDEA contains guidelines for what constitutes a free and appropriate education (FAPE) for students with disabilities, it does not dictate how FAPE should be determined. It is the responsibility of the IEP team and local school agencies to determine what FAPE is for each disabled child.…

    • 590 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Cfac Case Study

    • 237 Words
    • 1 Page

    The applicant is 38 year old married male with no children. Applicant currently resides with his significant as they both own their home together. The applicant is seeking admission to CSAC for the second time because according to the applicant, he says during his intake process, " I like it here, but the fees were too much weekly." The reason the applicant is being discharged from the Hartford Dispensary is due to his AWOL status as he left town due to a family emergency and did not notify the clinic in a timely manner for assistance with guest dosing. At this time, the patient's drug of choice is only heroin. His last used was 1-3 weeks ago, 3 bags by IV. The applicant was unable to identify any external factors as to why he is seeking treatment…

    • 237 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    Data Warehousing Failures

    • 5385 Words
    • 22 Pages

    At first, the planner for the data warehouse wanted to use a dimensional model for tabular information. But political pressure forced the system’s early use. Consequently, mainframe data was largely replicated and these tables did not work well with the managed query environment tools that were acquired. The number of tables and joins, and subsequent catalog growth, prevented Auto Guys from using data as it was intended in a concise and coherent business format.…

    • 5385 Words
    • 22 Pages
    Powerful 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
  • 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
  • Powerful Essays

    Database management software referred as performance management market where efficiency and effectiveness are really important. There are a lot of opportunities due to the need of IT system from the companies. Nearly every company in the industrialized world spent a significant amount of money every year on software purchases ranged from $99 to $10million.The software market estimated to be $4.8billion in 2003 compare with $2.4billion in 1999. However, the market was fragmented. Products were differentiated principally in two ways. On one hand, products differed widely in terms of underlying resources and platforms with they are associated. On the other hand, available products also differed in terms of the functionality they offered. There are few major competitors in this market and the industry need high intensive labor cost. It usually takes long time to develop new product in this industry. Effective advanced technology and product, which can solve the problem for the companies, are very important to success in the industry. Time is another important key to…

    • 1565 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    1. Go to teradatastudentnetwork.com and find the paper titled “Data Warehousing Supports Corporate Strategy at First American Corporation” (by Watson, Wixom, and Goodhue). Read the paper and answer the following questions:…

    • 402 Words
    • 2 Pages
    Satisfactory 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
  • 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
  • Satisfactory Essays

    Nationwide insurance company is one of the largest financial service company, with $23 billion in revenue and more than $160 billion in statutory assets. So in this large business nationwide insurance company experienced a various data issues, like data in-consistence, data reputation, dissimilar data processing, this will shows on business decisions and strategy on market. To resolving the issues Nationwide insurance started using Enterprise data warehouse technology from Teradata, it is a single data warehouse. It would provide best practices to make strategic and tactical business decisions. Data Warehouse is less expensive, stored in single place from different various systems also it will be helpful during critical analysis stage using clean and standardized data and provide solutions in short time instead of spending analysis, gathering the data, cleaning and stored in multiple places.…

    • 372 Words
    • 2 Pages
    Satisfactory Essays