r/Powerbihelp

Author: u/roam_and_scream

First, bravo! Star schema's the hard part and you've got it - that's the foundation, everything below is layered on top of solid work.

What would i do differently:

1. your KPIs

Total Revenue, Operating Profit - just numbers sitting there. is $1.05bn good? no idea, and neither does the person looking at it. every KPI needs something next to it: +5% vs LY, or vs target, or last month. a number on its own can't be evaluated, it can only be read.

2. there is no priority on the page

right now every visual has the same visual weight, so the user has to do the analysis themselves.

what does someone get in the first 5 seconds vs the first 30? right now the answer to "first 5 seconds" is your page title, and "Operations Performance" tells them nothing. "Flight delays at LHR running 20% above average" tells them everything. make the main trend the biggest thing on the page and drop the visual weight on the tables and heatmaps - they're for the people who stick around, not the ones scanning.

3. colours.

it looks clean, maybe this choice has some reasons behind it, and I get why you did it. but if everything's blue, nothing is emphasised. grey out the context data and save the blue for the thing you actually want them to look at - worst route, biggest channel, whatever the point is. colour is the fastest tool you have for directing attention.

4. scatter plot

interesting to look at, but no idea what to do. add average lines through it and suddenly you've got four quadrants - high cost/low revenue is the problem pile, low cost/high revenue is what you're trying to replicate. same data, but now a manager can point at it and say "investigate those three."

drop your dashboard for next review

Lets discuss! u/_lovey28

First, purely analytical arithmetical (thats where you lose a stakeholder's trust)

Your dashboard uses "sales" to mean two different things without saying so. Total Pizza Sales is units, Total Sales by Category is units, but the donut is revenue. You can prove it without leaving the screenshot: Classic is 14,888 of 49,574 units, which is 30.0%, and no slice in the donut goes above 26.91%. So one chart is money and its neighbour is pizzas, under nearly identical titles.

Then, your two time labels follow different rules. "5-7pm" covers hours 17 and 18, two peaks, correct. But "12-1pm" is one hour, while your lunch peak is also two, 12 and 13. Same convention, so it should read 12-2pm.

Your Top 5 axis probably doesn't start at zero, worth opening the file to check, because the bars look like a landslide and the actual gap between first and fifth is 3.3% (2,453 vs 2,371). Force the minimum to zero and then rewrite the takeaway, because there isn't a best seller

Now insights.

Day of week barely matters; hour of day matters! Variation across weekdays is about 9%, across hours about 32%. Four hours (12, 13, 17, 18) carry 45% of all orders against 27% if the day were flat. Your left panel gives both equal billing, but that is not correct

And the one worth digging into: units and revenue don't rank your categories the same way. Classic is the volume leader at 30.0% of pizzas but only 26.91% of revenue, so your biggest seller is your cheapest. Add a revenue-per-pizza column.