Created an Excel-based Employee Insights Dashboard to analyze employee salaries, departments, and attendance. The dashboard includes KPI summaries, charts, department analysis, and an employee details table for clear and easy reporting.
Analyzed and transformed messy trip data from a 12-cab Rapido fleet into a clean, structured, and interactive Excel dashboard. The project involved cleaning and organizing raw data, identifying useful information, and creating summaries and visualizations to make the data easier to understand and analyze.
Excel features used: Fill Series, Sorting, Go To Special, Merge & Unmerge, Pivot Tables, Pivot Charts, and Slicers.
The final dashboard provides an easy-to-understand view of the cab trip data and helps turn raw, unorganized data into meaningful insights.