Nolia Sales Report
Case Introduction:
-
I am a Business Intelligence Developer at Nolia.
-
My task is to create a marketing and product dashboard showing the company's sales performance across different markets, top-selling products, and sales development.
Step 1: Case Analysis (2W1H)
-
Who needs to see the sales dashboard?
-
Sales manager​
-
-
What do they want to see?
-
Sales amount, sales quantity, sales growth rate​
-
Classified as measures
-
Grouped into fact tables
-
-
How they want to see it?
-
By time, by country, by product, by business line, in different currencies​
-
Classified as attributes
-
Grouped into dimension tables
-
Step 2: Build Star Schema
Conceptual Model
Logical Model
Step 3: Bus Matrix
-
Create a Business Matrix: to illustrate the relationship between facts and dimensions.
-
Identify Conformed Dimensions: to recognize dimensions with relationships to multiple fact tables.
Step 4: Build BI Dashboard
Use star schema and business matrix to guide report building:​
-
Data loading and cleansing in Power Query Editor
-
Table/Column transformations in Data View
-
Form relationship in Model View
-
Build visuialization in Report View
