Sales Analysis Power BI Dashboard Example

This dashboard comprises three reports and a landing page that gives the user a summary of the key metrics. The background design was created using PowerPoint and has seamless navigation between different reports that provides users with a vibrant experience.

• Overview
  The user can obtain a comprehensive summary based on four crucial KPIs. Going deeper, custom tooltips have been designed for both donut charts. To gain more in-depth insights, users can leverage the drill-through feature, which is enabled for both the donut charts. Decomposition Tree visual is an effective way to analyze profit across numerous dimensions because it changes dynamically based on the prior dimensions selected.

• Store
  The user can monitor the number of Stores, Orders, Profitable City & Stores. This report includes detailed information about the store’s performance based on Sales, Profit, Profit Margin%, and Stock on Hold. With the help of filters like Store Location, users can narrow their analysis based on their preferences.

• Product
  This tab deep dives into Product Analysis, and users can track the number of SKUs by Sales and Profit. This report provides us with order trends for the product categories over time, and users can also determine which product category sells the most quantity. Along with Sales and Profit Margin%, users can also see Products on Hold, which helps in inventory management for every store or store location as per the filter selection.