Adventure Works Dashboard

About this project

In this Project we used raw transactional coffee sales data to build an interactive dashboard to explore and analyze coffee shop sales☕ .

Final PowerBI Dashboard

Tab 1 : Executive Summary : Provides a quick summary of Revenue, Profit, Orders & Return Rate. We can also see Top 10 Products(based on # of Orders) as well as Revenue Trending over time.

Tab 2 : Map : Shows the Total Orders by Continent (larger the bubble size, more orders we had in the Country).

Tab 3 : Product Details : Provides Product Details of the Product selected in the Exec Summary Tab.The Gauge charts show if we met the Monthly Targets or not.

The line chart depicts the Profit Trending over tine. We also have the ability to adjust the Product Price & see the Adjusted Profit Trending over time.

The Area Chart updates based on the KPI selected from "Product Metric Selection".

Tab 4 : Customer Details : Provides a quick summary of Unique Customer Count as well as Revenue Per Customer. as well as trending over time.

We can also see Total Orders by Income Level & Occupation in the 2 Pie Charts.

Matrix view shows Top 100 Customers by Revenue & Orders. We can also see The "Top" Customer(Name + # of Orders + $ Revenue)