What is data modeling in analytics projects?

< 1 min read

Data modeling is how we structure cleaned data into logical relationships so reporting tools can understand it.
In projects I usually design a star schema with fact and dimension tables.
For example, in a sales dashboard, Sales becomes the fact table and Customer, Product, Date become dimensions.
This helps users filter revenue by month, city, or product category easily.
I first identify business questions, then define required measures like revenue, quantity, and profit.
Then I create relationships using primary and foreign keys in Power BI or SQL.
I also remove unnecessary columns to keep the model fast.
Proper modeling improves report performance and avoids duplicate counting.
It ensures consistent numbers across all dashboards.

Power BI Essentials