Sales dashboard with Power BI
I will explain to you how to work with Power BI by having an overview of your reports and forgetting about obsolete techniques where each report is an independent element without any connection to the other reports. And we will do this through a sales dashboard created in Power BI.
This will allow you to have much richer information and answer many more business questions.
It is very common that when we analyze information, related and more detailed questions arise.
I give you several examples of situations that we will resolve:
I am analyzing the total sales for the month of August and would like to know the breakdown of these sales for each of the stores, but this data does not appear in the current report. For this I have two alternatives:
- I include more elements in this ratio, overload it and see everything smaller
- I get it, just hovering over the August column shows a floating advantage with that breakdown
Which alternative do you prefer? I have it very clear, the second.
And if you want to know how it’s made and what it looks like, you’ll see it in the video below.
But let’s start with another example first.
I see the global monthly sales of my business, I also have each of the stores and I can filter them with just one click. So far something that is very common to already have in your relationships. But you want to go a step further, you want to know what are the best-selling categories and products in that store, and once again you have several alternatives:
- Find another report that contains this information among the dozens (hundreds or thousands) of reports you have
- Click with the right mouse button on the shop in question and access a new report, already filtered only for that shop where you see a ranking of the best-selling categories and another of the best-selling products.
I still have it very clear, the second one is much better.
Well, you can see all this and much more in the video I show you below. But wait and keep reading, there is very interesting information that will help you get more from the video if you read it beforehand????
Sales dashboard and reporting pages that compose it
The main page of the sales dashboard allows you to carry out a global analysis of the sales situation for a given year. In it we have:
- Annual sales and sales goals
- Net and percentage deviations between turnover and objectives
- The monthly breakdown of sales and targets and their variances
- The cumulative evolution of sales and goals since the beginning of the year
From here we can delve deeper and detail the sales information on different pages:
- Analysis of a store’s sales by category and product
- Evolution of sales of a product in a specific store
- Comparative analysis of sales versus profit. One of the most visual analyzes that provides more information, if done well, don’t miss the video where we navigate and analyze it in detail
- Analysis and evolution of benefits by product
- and many others
But we won’t treat them as independent reports, but you’ll see that switching between them contextualizing the information we’re making decisions about is possible with a couple of mouse clicks.
Video in which I show you the Sales Dashboard with Power BI
This video goes beyond simply navigating and explaining your sales dashboard with Power BI. I will also explain what steps I took to create it and the reason for the result obtained.
I share with you the index of this video:
- 0:00 Start the video
- 0:38 What you should know before creating your report
- 0:50 What business questions should my report answer?
- 1:35 Dashboard example
- 7:00 Best colors for reporting
- 8:36 Standalone reports and report suites
- 8:50 Design a series of reports
- 9.22 Integrate reports and improve routes
- 9:42 Interaction (real case)
- 10.39 Should I stop using stand-alone reports?
- 11.04 Final conclusions
Conclusions on the sales dashboard with Power BI
If you want to have dashboards and control panels like the one I just presented I recommend you:
- You train in data visualization techniques and dashboard design
- Think report suites, not standalone reports.
- Have a defined step-by-step working method. And follow him without skipping any of his steps, because running is very bad.
All this is necessary, but not sufficient. Many times there are other underlying issues that prevent you from achieving the above.
There are other invisible pillars that will bring down your project.
Avoid the 3 most damaging mistakes made with Power BI with this free guide:
Leave a Reply