1-PROJECT OVERVIEW:
This project delivers a full HR analytics solution built using MySQL for data engineering & KPI logic, Power BI for executive dashboarding and Structured Dimensional Modeling (Star Schema). The objective is to help leadership evaluate: Compensation fairness.Promotion consistency. Organizational hierarchy efficiency. Workforce risk indicators. Performance alignment. This solution separates: Data logic (MySQL). Business modeling (Dimensional Model). Visualization & storytelling (Power BI).
2-PREPARING AND CLEANSING THE DATASET:
creating the database and the tables. Load the dataset into MYSQL by using python. Understanding and inspecting the dataset. Creating the staging tables. Data profiling. Data quality checks and Relationship checks. Check and handling mising values. Check and handling duplicates values. Data Standardization. Data Validation.
3-EXPLORATORY DATA ANALYSIS:
Column & Type Validation. Missing Values Analysis (Not Just Counting). Grain Validation (What does one row mean?). Distribution Analysis (Truth vs Expectation). Logical Outliers (Contextual, Not Statistical). Referential Consistency (Reality Alignment) by Ensure relationships make business sense. PATTERNS & BEHAVIOR (INSIGHT MODE). Validate Business Assumptions.
4-CREATING FACTS AND DIMENTIONAL TABLES:
5-KEY PERFORMANCE INDICATOR:
Headcount Analysis. Average Salary & Compensation Metrics. Promotions & Career Progression. Employee Satisfaction & Performance. Organizational Hierarchy KPIs. validate accuracy & business sense.
6-CREATE VIEWS BASED ON KPI FOR POWER BI :
Headcount Views. Salary & Compensation Views. Promotions & Career Progression Views. Performance & Satisfaction Views. Organizational Hierarchy Views. Turnover Risk and Promotion Velocity.
7- CREATING VISUALIZATION AND DASHBOARD IN POWER BI BASED ON THE VIEWS:
CONNECT POWER BI TO MYSQL. POWER QUERY(Rename Tables, Data Types, Rename Columns (Business Language), Handle NULLs , Validation Columns). DATA MODELING: DIM and FACT And CREATE relationships in model views. Create Dax measures. Create pages dashboard.
8-DOCUMENTATION:
9-INSIGHTS AND RECOMMENDATIONS:
10-TOOLS USED:
MySQL. Python (Data Loading). Power BI. DAX. Dimensional Modeling.
Author Younes Boumouh Data Analyst | HR Analytics | SQL | Power BI