DEV Community

Cover image for Building Excel Dashboard
Dennis Wachira
Dennis Wachira

Posted on

Building Excel Dashboard

 With the analysis complete, I designed an interactive dashboard to present the findings. It includes:
The dashboard includes:

KPI cards for:

  • Total Patients
  • Average Patient Age
  • Total Bill Amount
  • Highest Bill Amount

Visualisations showing:

  • Patients by Department
  • Gender Distribution
  • Payment Status Distribution
  • Diagnosis Analysis

One of my favourite parts was using slicers. These allow the entire dashboard to update instantly based on the selected filters, making it much easier to explore the data from different perspectives. Building this feature helped me appreciate how interactive reports improve the user experience and support faster decision-making. I added slicers for:

  • Hospital Department
  • Gender
  • Payment Status
  • Diagnosis

Beyond creating charts, I wanted the dashboard to have a clean and professional appearance.To achieve this, I:

  • Removed Excel gridlines to create a cleaner layout.
  • Hid the row and column headings so the dashboard looked more like a business report than a spreadsheet.
  • Used consistent fonts and spacing to improve readability.
  • Organized the KPIs and charts into a structured layout that is easy to understand at a glance.

These small design improvements made a significant difference in the overall presentation of the dashboard.
The Excel phase of my project is now complete.

Top comments (0)