An interactive Financial Performance Dashboard built using Microsoft Power BI Desktop to analyze revenue, profitability, sales performance, discount impact, and business growth across different countries, segments, and product categories.
The dashboard provides an executive-level view of financial performance through interactive KPI cards, DAX-driven calculations, trend analysis, and advanced drill-down visualizations.
The objective of this project is to transform raw corporate financial transaction data into meaningful business insights using Power BI.
The dashboard helps stakeholders understand:
- Revenue performance
- Profitability trends
- Product contribution
- Country-wise performance
- Segment analysis
- Discount impact on margins
The project follows standard Business Intelligence practices including:
- Data cleaning using Power Query
- Star Schema data modeling
- Explicit DAX measure development
- Interactive dashboard design
- Business-focused data storytelling
- Monitor overall financial performance using key KPIs.
- Analyze revenue and profit trends over time.
- Identify top-performing countries and products.
- Evaluate profit margin efficiency.
- Understand the impact of discounts on profitability.
- Perform root-cause analysis using interactive drill-downs.
- Support strategic business decisions using data-driven insights.
| KPI | Description |
|---|---|
| 💰 Total Revenue | Overall generated revenue |
| 📈 Total Profit | Total business profit |
| 💵 Total Gross Sales | Total sales before deductions |
| 📦 Total Units Sold | Total products sold |
| 🎯 Profit Margin % | Profit efficiency percentage |
| 🏷️ Total Discounts | Discount impact analysis |
Visual:
- KPI Cards
Displays:
- Total Revenue
- Total Profit
- Gross Sales
- Units Sold
- Total Discounts
Purpose:
Provides a quick executive summary of overall financial performance.
Visual:
- Area Chart
Purpose:
- Analyze monthly revenue movement.
- Identify growth patterns.
- Understand seasonal business trends.
Visual:
- Column Chart
Purpose:
- Compare profitability across countries.
- Identify high-performing markets.
- Understand geographical revenue contribution.
Visual:
- Horizontal Bar Chart
Purpose:
- Analyze revenue contribution by product.
- Identify profitable and underperforming products.
Visual:
- Area Chart
Purpose:
- Track monthly profit margin changes.
- Identify periods of high and low profitability.
- Evaluate business efficiency.
Visual:
- Power BI Decomposition Tree
Purpose:
Perform interactive drill-down analysis to understand factors affecting profitability.
Analysis Path:
This helps answer:
- Why is profit increasing or decreasing?
- Which segment contributes most profit?
- Which products impact profitability?
The dashboard includes slicers for:
- 🌍 Country
- 📦 Product
- 🏢 Segment
- 🏷️ Discount Band
- 📅 Year
All visuals update dynamically based on user selections.
All calculations were created using explicit DAX measures instead of Power BI implicit aggregations.
Total Revenue =
SUM('Financial Data'[Sales])
Total Profit =
SUM('Financial Data'[Profit])
Total Gross Sales =
SUM('Financial Data'[Gross Sales])
Total Units Sold =
SUM('Financial Data'[Units Sold])
Profit Margin % =
DIVIDE(
[Total Profit],
[Total Revenue],
0
)