An Interesting Use Of Power BI To Analyse Domino's Pizza Sales

, , No Comments
First, these are all fictitious data.




I took five different branches of Domino's Pizza in Nigeria and gave them random Managers. I also pulled out their location data as places like Gbagada and Ibadan confuses the map engine in Power BI.



Then I created daily sales target, pizza type sales target and actual sales data for about two weeks.




I launched Power BI Desktop



I brought in the datasets and created relationships between them.



Then I proceeded to making a sales dashboard showing me the sales performance by branch. It has drill-down capabilities, so one can decide to focus on the sales performance of any single branch.







Then I published the dashboard on my Power BI account so I can access it from anywhere and on the go from my phone/tablet/laptop. It also allows me to ask questions a business manager will be interested in knowing.



Can I see sales by manager?

Show me the top sales branch. 



And the fun doesn't stop there. I can access it from my smartphone too. And even set it to alert me when sales reach a specified amount.






And I can share it with the MD and CFO. Cool!


0 comments:

Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.

Thanks!