Description
The dashboard tracks patient admissions, discharges, department-wise performance, doctor workload, bed occupancy, and other healthcare KPIs. It simplifies hospital data analysis and helps healthcare administrators make informed, data-driven decisions.
Tools Used
Microsoft Excel
Pivot Tables
Pivot Charts
Slicers
Conditional Formatting
Excel Formulas
1
25
The dashboard tracks employee count, department-wise distribution, attrition, gender ratio, and other HR KPIs. It simplifies workforce analysis and helps HR managers make data-driven decisions.
Tools Used
Microsoft Excel
Pivot Tables
Charts
Slicers
Conditional Formatting
1
31
Designed an interactive E-commerce Sales Dashboard in Microsoft Excel to analyze sales, revenue, profit, customer behavior, and product performance. Built using Pivot Tables, Pivot Charts, Slicers, and Excel formulas, the dashboard provides clear insights through dynamic visualizations, helping businesses track KPIs and make data-driven decisions.
0
15
Built using Microsoft Excel, this dashboard transforms raw sales data into an easy-to-understand visual report. It includes KPI cards, charts, slicers, and trend analysis to help businesses monitor performance, identify sales trends, and make informed decisions.
Tools Used
Microsoft Excel
Pivot Tables
Pivot Charts
Slicers
Conditional Formatting
Excel Formulas