Sales Overview Dashboard
As part of my portfolio, I created an interactive Sales Overview dashboard for Velo Haus, a bike store seeking deeper insight into its sales performance.
Interactivity
The dashboard includes a slicer pane that can be opened using a button. This keeps the main view clean while giving the user more control when needed.
Background Design in Figma
To ensure a clean and professional user experience, I designed a custom report background in Figma before building the dashboard in Power BI.
Business Challenge
Velo Haus needed a clear way to track sales performance, understand customer behavior, and identify which products drive the most revenue. Before this dashboard, insights were scattered across multiple sources, making it difficult for management to make data-driven decisions.
Data Used
The dashboard was built using transactional sales data from the store’s internal system.
Key fields included: date, product category, product name, customer age group, order quantity, revenue, cost, and profit.
Data was modeled into a FactSales table and a DimDate table for time-intelligence calculations.
Visualisations
- KPI Cards: Total Sales, Average Profit, AOV, Sales Growth %
- Line Chart: Revenue trend over multiple years
- Donut Chart: Sales share by product category
- Bar Charts: Sales by age group, yearly revenue, yearly profit
- Table: Most profitable products
Key Measures (DAX)
- Total Sales
- Average Order Value
- Average Profit
- Sales Growth Rate YoY
- Ranked product profitability
Insights
- The store achieved $85M total sales and strong 58% YoY growth.
- Adults and Young Adults drove most revenue, while Seniors contributed very little.
- Bikes were the dominant product category with $62M in sales.
- Revenue peaked in 2015, followed by a slight decline.
- High-margin products—like premium bikes and helmets—generated the most profit.
Vanessa Analytics 