Data Warehouse Introduction Part 2
(No Ratings Yet)
Loading ...Data Warehouse design and data modeling are the focus of this part of the lecture. Start with Part 1 if you haven’t seen it yet.
The examples of business intelligence system design continues with the following questions. The data warehouse will supply answers to business questions such as:
- How is the metric of employee attrition changing over the years across the company’s business units?
- Is there a correlation between the geographical location of a company unit and excellent employee appraisals?
- Is it financially viable to continue operations of the manufacturing unit in Taiwan?
Some notes from the lecture:
OLAP Query Characteristics
- Aggregation and summarization over large data sets
- Clustering
- Trend detection
- Multi-dimensional projections
A Typical Data Warehouse
Hypercube Core
- Manages the atomic data elements
- Global schematic structure for the entire warehouse
- Based on the multi-dimensional data model
Materialized Views
- Physical views for faster aggregate query answering
- De-normalization of the core
Tags: Business metrics, KPIs, data warehousing, online analytical processing, data models, data warehouse design, business intelligence
RSS
RSS feed for comments on this post
Share your comments