tailieunhanh - Lecture Business driven technology: Chapter 8 - Paige Baltzan, Amy Phillips

Chapter 8: Accessing organizational information - data warehouse. In this chapter students will be able to: Describe the roles and purposes of data warehouses and data marts in an organization, compare the multidimensional nature of data warehouses (and data marts) with the two-dimensional nature of databases, identify the importance of ensuring the cleanliness of information throughout an organization,. | CHAPTER 8 Accessing Organizational Information—Data Warehouse LEARNING OUTCOMES Describe the roles and purposes of data warehouses and data marts in an organization Compare the multidimensional nature of data warehouses (and data marts) with the two-dimensional nature of databases LEARNING OUTCOMES Identify the importance of ensuring the cleanliness of information throughout an organization Explain the relationship between business intelligence and a data warehouse HISTORY OF DATA WAREHOUSING Data warehouses extend the transformation of data into information In the 1990’s executives became less concerned with the day-to-day business operations and more concerned with overall business functions The data warehouse provided the ability to support decision making without disrupting the day-to-day operations DATA WAREHOUSE FUNDAMENTALS Data warehouse – a logical collection of information – gathered from many different operational databases – that supports . | CHAPTER 8 Accessing Organizational Information—Data Warehouse LEARNING OUTCOMES Describe the roles and purposes of data warehouses and data marts in an organization Compare the multidimensional nature of data warehouses (and data marts) with the two-dimensional nature of databases LEARNING OUTCOMES Identify the importance of ensuring the cleanliness of information throughout an organization Explain the relationship between business intelligence and a data warehouse HISTORY OF DATA WAREHOUSING Data warehouses extend the transformation of data into information In the 1990’s executives became less concerned with the day-to-day business operations and more concerned with overall business functions The data warehouse provided the ability to support decision making without disrupting the day-to-day operations DATA WAREHOUSE FUNDAMENTALS Data warehouse – a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes DATA WAREHOUSE FUNDAMENTALS Extraction, transformation, and loading (ETL) – a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse Data mart – contains a subset of data warehouse information DATA WAREHOUSE FUNDAMENTALS Multidimensional Analysis and Data Mining Databases contain information in a series of two-dimensional tables In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows Dimension – a particular attribute of information Multidimensional Analysis and Data Mining Cube – common term for the representation of multidimensional information Multidimensional Analysis and .