Salary Analytics Dashboard is an end-to-end HR analytics solution designed to visualize salary structures, employee compensation trends, departmental headcount, and payment preferences.
Total Salary, Basic Salary, Allowances, Deductions & Net Pay
Month-over-Month Growth Comparisons
Trend Analysis using Calendar Table
Preferred Payment Mode by Employment Type
Employee Count by Department
This dashboard empowers HR, Finance, and Leadership teams to make data-driven compensation decisions.
Which departments are driving cost increases
How employee payments vary over time
Whether allowances and deductions follow expected patterns
Whether certain payment modes dominate (NEFT, Cash, UPI, Bank Transfer)
Identifying high-earning or high-allowance employees
Salary trends month-over-month and year-over-year
This dashboard provides one consolidated view of all salary-related metrics, improving transparency and decision-making.
🧾 Key Outcomes
By the end of this project, users can:
✔️ Track salary spend instantly
Total salary payout
Basic vs Allowances vs Deductions
Net pay comparisons
✔️ Understand month-over-month salary growth
Previous month salary
% increase or decrease
Salary seasonality trends
✔️ Analyze departmental patterns
Salary by department
Employee count per department
Payment history broken down by functions
✔️ Identify top employees based on criteria
Top 5 by Basic Salary
Top 5 by Allowances
Top 5 by Deductions
Top 5 by Net Pay (using Field Parameters for dynamic switching)
✔️ Explore employee behavior
Preferred mode of payment
Payment mode by employment type (Full-Time, Contractual, Interns)
Salary payout history by month
🛠️ Project Components
- Data Loading & Model Setup
Salary dataset loaded into Power BI
Table renamed for clarity
Relationships created
"Overview" and "Employees" dashboard pages prepared
- Calendar Table Creation
A Calendar table was created for managing:
Month-Year filtering
Time intelligence functions
Trend analysis
Linked to the salary table using SalaryDate.
-
DAX Measures
-
Visual Formatting
Line charts with forecasting
Trend lines
Rounded card visuals
Custom color themes
Interaction editing to prevent incorrect filtering
- Dashboard Sections Salary Summary
Total Salary
Basic Salary
Allowances
Deductions
Net Pay
Salary Trends
Monthly basic salary trend
MoM comparison
Net salary trend with forecast
Payment Preferences
Preferred mode (NEFT, Cash, UPI, Bank Transfer)
Mode by employment type
Employee Metrics
Total employee count
Employees by department
Employees by employment type
Top 5 Employee Ranking
Dynamic ranking using Field Parameters:
Basic Salary
Allowances
Net Pay
Deductions
🖼️ Dashboard Pages
- Overview Page
Salary KPIs
Trend charts
Department salary distribution
Payment mode preferences
- Employees Page
Employee-level metrics
Top 5 earners
Department-wise employee count
Pay history