( Case study )
Employee-salary-analytics
Power BI star-schema data model analyzing employee salaries across departments, designations, and time — includes data quality audit and clean-up recommendations.
Problem
Salary data was spread across departments and designations with no single view of payroll cost.
Approach
Built a star-schema model in Power BI with fact and dimension tables, then designed DAX measures for payroll trends.
Results
One dashboard now shows total payroll, bonus and commission by department and month.
Key Learnings
Clean data modelling matters more than visuals.
Gallery
