Financial Dashboard Expansion & Analytics

I already have a working financial dashboard and now need it pushed further so every key cost centre is visible at a glance. The first priority is to bolt on a department by depart expense view that separates Operational expenses and Staff costs, then ties each of those back to the budget figures. I want to be able to drill down from the consolidated P&L straight to the individual department line and instantly see how much of its allocation has been used. Next, I run more than 60 truck runs daily and I’m flying blind on their true profitability. I need a new tab (or set of visuals) that scores every single delivery, one row per delivery, showing revenue, variable cost, margin and variance against target. Filters by date range, truck, route and customer are essential so our dispatch team can self-serve the answers. Finally, the warehouse piece: I move roughly $1M in stock a night and want to understand Total cost per night for picking, staging and dispatch. Please surface that as both a headline KPI and a trend so I can spot spikes immediately. Deliverables • Enhanced dashboard file (Power BI, Tableau or similar—use the same platform I’m on now) with the three new sections fully wired to my existing data model. • Clean, well-documented DAX/SQL/ETL logic so future data loads stay automated. • A short loom or screenshare walk-through confirming that: – Department view reconciles to current totals. – Each delivery line in the truck tab matches source data and margins calculate correctly. – Warehouse tab displays the nightly total cost and updates when new days are loaded. I’ll provide sample data, table map and current dashboard once we start. Looking forward to seeing how you can make this information pop.

Project ID: 40597274