Power BI Sales Dashboard
INSIGHTS INTO Peak SALES WITH POWER BI
This Power BI Sales Dashboard is created as part of a data challenge. The challenge asks to create insights into “Plato’s” restaurant sales. They wanted to find out which pizzas are most and least popular and which hours/days/months are most popular for visitors.
To create insights into the data, I created a one-page dashboard (hence no filters) to give a quick overview of the year results of Plato’s.
The visual at the top right uses a stacked bar chart with two DAX measures: one for the amount up to the target and one for the amount above the target. This approach allows you to visualize whether a target is hit, even with dynamic targets.
The visual in the middle right is a matrix visual where I’ve used conditional formatting to get insights into the restaurant’s busiest and least busy timeslots. This is handy when a schedule with available employees is created.
Because of the design, you can quickly spot the most popular and least popular timeslots.
Power BI Sales Dashboard - Final touches
I also used a ribbon chart (middle, left) to show the difference in popular days by quarter. This way, it is easy to see that, for example, Q3 Thursday is the most popular day, while in the other quarters, it is Friday. Also, Tuesday is quite a popular day in quarter one but not in the others. Again, this can be handy when planning employee shifts.