Descriptive Analytics II: Business Intelligence and Data Warehousing - Business Intelligence and Datawarehousing
3 important questions on Descriptive Analytics II: Business Intelligence and Data Warehousing - Business Intelligence and Datawarehousing
What is the spectrum of BI-reports?
- static snapshots of business transactions on a fixed schedume
- ad hoc reporting where the decision maker is given the capability of creating his own specific report
- dynamic views of key business performance indicators
How does a data warehouse differ from a transactional database?
Transactional databases are product oriented and are tuned to handle transactions that update the database.
Data warehouses are subject oriented. Subject orientation provied a more comprehensive view of the organization. Data contains only information relevant for decision support.
Data warehouses are subject oriented. Subject orientation provied a more comprehensive view of the organization. Data contains only information relevant for decision support.
Differentiate among a DM, an ODS, and an EDW
DM - data mart: focuses on a particular subject or departmens, is a subset of a data warehouse, single subject area (e.g. marketing, ..)
ODS - operational data store: an ODS consolidates data from multiple source systems and provides a near-real-time, integrated view of volatile, current data
EDW - Enterprise Data Warehouse: is a large scale data warehouse, used across the enterprise for decision support
ODS - operational data store: an ODS consolidates data from multiple source systems and provides a near-real-time, integrated view of volatile, current data
EDW - Enterprise Data Warehouse: is a large scale data warehouse, used across the enterprise for decision support
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
