End-to-end HR MIS reporting project using PostgreSQL and Excel. Covers dimensional modeling, SQL-based KPI validation, Excel Power Query & Power Pivot modeling, KPI reconciliation, and automated A4 MIS report generation with validation controls, closely reflecting real-world HR MIS workflows.
sql data-validation functions pivot-tables power-query dax formulas data-governance star-schema power-pivot microsoft-excel vba-automation hr-analytics dimensional-modeling hr-reporting cube-functions kpi-validation analytics-case-study
-
Updated
Mar 25, 2026