1 / 7

CIS 429—Chapter 8 Accessing Organizational Information—Data Warehouse

CIS 429—Chapter 8 Accessing Organizational Information—Data Warehouse. Accessing Organizational Information. Applebee’s $3.2 billion annual sales 1500 restaurants in 49 states and 7 countries Sales data stored in a data warehouse Decisions made include

halima
Download Presentation

CIS 429—Chapter 8 Accessing Organizational Information—Data Warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CIS 429—Chapter 8Accessing Organizational Information—Data Warehouse

  2. Accessing Organizational Information • Applebee’s • $3.2 billion annual sales • 1500 restaurants in 49 states and 7 countries • Sales data stored in a data warehouse • Decisions made include • Labor budgets based on number of guests • Promotional sale item analysis • Costs of food and use of ingredients

  3. History of Data Warehousing • Operational systems of the 1990s • Accounting, order entry, customer service, sales • Such systems not appropriate for business analysis • Incomplete • Not integrated • Not ___________ • Poor quality • Not designed for ___________

  4. Data Warehouse Fundamentals • Introduction • Data warehouse • A logical collection of aggregated information that supports business analysis and decision-making • Data warehouses compiled using ETL • Extraction • _________________ • Loading • Data mart • A _________ of data warehouse information

  5. Data Warehouse Fundamentals (2) • Multidimensional Analysis and Data Mining • A data warehouse is a multidimensional database or a ________ • Querying a data warehouse can be faster than querying a relational database • Data mining • Extracting more complex information from a data warehouse • Data-mining tools find patterns and relationships in large volumes of information • Statistical tools • ___________ agents (http://en.wikipedia.org/wiki/Intelligent_agent)

  6. Data Warehouse Fundamentals (3) • Information Cleansing or Scrubbing • Low-quality information costs U.S. businesses _______ billion annually • Information cleansing and scrubbing finds and fixes low-quality information • Specialized software is designed to perform these operations

  7. Business Intelligence • BI is information used to support ______________ • New technologies lead to increased amounts of information • Enabling BI • Technology • Hardware and software more available • People • Quality people in key positions to perform analysis • __________ • Executives who encourage the wise use of technology

More Related