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 .

• Quản trị kinh doanh
• Business driven technology
• Lecture Business driven technology
• Organizational information
• Management information systems
• Data warehouse
• Accessing organizational information
• Technology plug in
• Business plug ins
• Business process
• Business process improvement
• Mobile technology
• Personal digital assistants
• Business basics
• Financial statement
• Business intelligence
• Data mining
• Global information systems
• Cultural business challenges
• Creating strong passwords
• Monitor your accounts
• Creating conditional formatting
• Using autofilter
• Goal Seek Command
• Decision making using excel
• Designing database applications
• Database management system
• Microsoft Access
• New blank database
• Simple query wizard
• Advanced queries
• Form wizard in access
• Report wizard
• Designing web pages
• World wide web
• Hypertext Markup Language
• Improving readability
• Navigating in dreamweaver
• Dreamweaver setup
• Gantt chart
• Creating gantt charts with excel
• Central processing unit
• Primary storage
• Enterprise architectures
• Disaster recovery
• Network basics
• Server network
• Information security
• Information security policies
• Information privacy policy
• Ethical computer use policy
• Supply chain management
• Supply chain drivers
• Customer relationship management
• Operational CRM
• Enterprise resource management
• Core ERP component
• Ebusiness model
• Accessing internet information