Skip to content
Project number
Project / 013
Year
2024
Category
Analytics
Status
Completed

Power BI Apocalypse Food Prep

Power BI dashboard for food-preparation planning with resource tracking.

Stack
Power BI · DAX
Tags
Dashboard

01 /Overview

Turn a planning dataset kept in Excel into something people can explore and act on.

02 /What I built

  • Data prepared in Excel and transformed with Power Query
  • Data model with relationships between tables
  • Slicers, filters and drill-downs for exploration
  • Consistent formatting, tooltips and navigation

03 /Outcome

An interactive Power BI dashboard built on data prepared in Excel.

04 /What I learned

Modelling the relationships between tables up front is what makes filters and drill-downs work naturally later.