Kimball's four step process

Các khái niệm về Kho dữ liệu (Data Warehouse)

Aaren Stubberfield

Data Scientist

Step 1 - Select the organizational process

Ask questions about a process
Kimball bottom-up approach starts with a business process

An image of the number one on an orange background

Examples of organizational processes:

Invoice and billing
Product quality monitoring
Marketing

Step 2 - Declare the grain

Grain = level to store fact table
A level of data that cannot be split further

An image of the number two on a brown background

Examples of business processes:

Music service -> Song grain
Shipping service -> Line item grain

Step 3 - Identify the dimensions

Choose dimensions that apply to each row
How to describe the data?
Business users and analysts = valuable feedback

Image of the number three on a black background

Examples of common dimensions:

Time: year, quarter, and month
Location: address, state, and country
Users: names and email address

¹ Photo by Alison Pang on Unsplash

Step 4 - Identify the facts

Numerical facts for each fact table row
What are we answering?
Metrics should be true at selected grain

Image of a four on a green background

Examples of facts:

Music service: total number of plays, sales revenue of a song
Ride-sharing: travel distance, time needed

¹ Photo by Miguel Á. Padriñán

Summary

Steps:

Select the organizational process.
Declare the grain.
Identify the dimensions.
Identify the facts.

Let's practice!

Các khái niệm về Kho dữ liệu (Data Warehouse)

Preparing Video For Download...