Introduction to Sales Dashboard in Power BI
In this article, we will see the Sales Dashboard which has been developed in Power BI. This dashboard is one pager but due to dynamically changing the metrics on selection, it will act like it has multiple pages providing performance summary of several KPIs.
Here, we have connected the sales data from Excel file which has several columns covering all the required datapoints of sales performance. Please see the below snapshot of Sales Data.
KPI calculated in the Sales Dashboard in Power BI
This Sales Dashboard has multiple KPIs e.g. Transactions, # Quantity Sold, $ Sales (Mn), Average Basket Value, Total Profit (Mn) and Profit %, etc.
Visualizations and Slicer in Sales Dashboard
On top portion of the dashboard, we have placed header of the dashboard ‘Sales Dashboard in Power BI’ with multiple slicers like Product, Sales Manager, Category and Date on the right side.
Below the slicers and header, we have several Tiles to show the sales KPI performance e.g. # Transactions, # Quantity Sold, $ Sales (Mn), Average Basket Value, Total Profit (Mn) and Profit %, etc.
Below the cards, we are showing the KPI performance by Date, Product Name, Sales Manager and Country using beautiful charts and visualizations.
By default, all the charts are showing the performance for # Transaction. User can see other KPI performance by clicking on any other Tiles. So the tiles are clickable and help user in changing the metrics in all the charts dynamically.
Live Sales Dashboard
Download Sales Dashboard files from the below link.
Thanks for visiting our website! Don’t forget to check our other contents which are completely free of cost.
