Chapter 13 - Business Intelligence and Data Warehouses
What is Master Data Management?
A collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.
What is Business Intelligence (BI)?
A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making.
What is a portal?
A unified, single point of entry for information distribution.
What is a Dashboard?
A web-based system that presents key business performance indicators or information in a single, integrated view with clear and concise graphics.
What is Data Visualization?
Abstracting Data to provide information in a visual format that enhances the users ability to effectively comprehend the meaning of the data.
What are the three distinctive reporting styles of a modern BI system?
Advanced Reporting, Monitoring and Alerting, and Advanced Data Analytics.
What are the 3 main requirements for a DSS Database?
Database Schema, data extraction and filtering, and database size.
What are the 6 basic architectural components of BI?
ETL Tools, Data Store, Query and Reporting,Data Visualization, Data Monitoring and Alerting, and Data Analytics.
What is the main goal of BI?
Improved decision making.
What is Governance?
Methods for controlling and monitoring business health and promoting consistent decision making.
What are Key Performance Indicators (KPI)?
Quantifiable numeric or scale-based measurements that assess a company's effectiveness or success in reaching strategic and operational goals.