Power BI Project – Financial Performance Dashboard

📘 Project Overview

This Power BI project focuses on analyzing financial performance metrics across different geographies and products. The data model includes a fact table named financials, containing sales and cost-related information such as Units Sold, Sale Price, Discounts, Country, and Manufacturing Price. To derive actionable insights, I created a series of DAX measures that calculate core financial KPIs, segmented insights, and highlight trends with conditional formatting.

🔥 GitHub Repository

1. Key Financial Metrics and Insights from the Power BI Dashboard 


# Count of Total Transactions
Total Transactions = 
    VAR _Trans = COUNTROWS(financials)
    RETURN _Trans

# Total Transactions in Canada
Canada Transactions = 
    VAR _Term = "canada"
    VAR _CanaTran = CALCULATE([Total Transactions], financials[Country] = _Term)
    RETURN _CanaTran

# Cost of Goods Sold (COGS)
COGS = SUMX(financials, financials[Units Sold] * financials[Manufacturing Price])

# Gross Sales
Gross Sales = SUMX(financials, financials[Units Sold] * financials[Sale Price])

# Total Discount
Total Discount = SUM(financials[Discounts])

# Net Sales (after applying discounts)
Net Sales = [Gross Sales] - [Total Discount]

# Total Profit
Total Profit = [Net Sales] - [COGS]

# Conditional Formatting for Profit Visualization
Conditional Formating = 
    VAR VProfit = [Total Profit]
    RETURN SWITCH(TRUE(), VProfit > 0, "#8250C4", VProfit < 0, "#E7553D")

# Positive Profit Metric
Profit Positive = 
    VAR VProfit = [Total Profit]
    RETURN IF(VProfit > 0, VProfit, 0)

# Negative Profit Metric
Profit Negative = 
    VAR VProfit = [Total Profit]
    VAR Vresult = IF(VProfit < 0, VProfit, 0)
    RETURN Vresult
Measure Description
Total Transactions Total number of rows (transactions) recorded in the financials table.
Canada Transactions Filtered count of transactions specific to Canada.
COGS Calculated by multiplying units sold by the manufacturing price.
Gross Sales Revenue before discounts, based on units sold and sale price.
Total Discount Total value of all discounts applied.
Net Sales Revenue after deducting discounts.
Total Profit Difference between Net Sales and COGS.
Profit Positive Displays only the profit values above zero.
Profit Negative Displays only the profit values below zero (losses).
Conditional Formatting Applies color formatting: Purple for profit, Red for loss.

📊 Data Insights & Interpretation

These DAX measures form the foundation of a dynamic Power BI financial dashboard that provides comprehensive insights into sales, profitability, and country-specific performance.

  • ✅ Performance Monitoring: Measures like Total Profit, Gross Sales, and COGS help evaluate core business performance and margin efficiency.
  • ✅ Regional Analysis: Canada Transactions helps isolate and monitor country-specific KPIs for better decision-making in targeted markets.
  • 🎯 Actionable Formatting: Conditional formatting instantly distinguishes between profit and loss visuals using intuitive color schemes.
  • ⚠️ Profit Segmentation: Profit Positive and Profit Negative help drill down into profitable vs. underperforming areas.
  • 📌 Strategic Recommendations: Focus on regions with higher negative profits for cost optimization and re-evaluate pricing or discounting strategies.

Overall, this Power BI project demonstrates a solid command of DAX for crafting insightful, actionable metrics and visual storytelling to support data-driven financial decisions. 📈🧠

2. 📊 Financial Performance Dashboard – Profit Analysis Example (France)

This Power BI dashboard offers a comprehensive view of France’s sales performance and profitability analysis, combining transactional, categorical, and temporal data to evaluate financial health and uncover opportunities for improvement.

Financial Performance Dashboard France

🔢 Key Financial Metrics

Metric Value
💼 Total Transactions140
📦 Total Quantity Sold241K
💰 Gross Sales£26M
💳 Net Sales£24M
🛒 Cost of Goods Sold£23M
💵 Total Discount Given$2M
📍 Locations Operated In1
📈 Total Profit£2M

🧮 Profitability Overview

  • Top Performing Country: Germany leads with £3.26M in gross profit.
  • Lowest Performing Country: France trails with £1.82M in profit.

Insight: France’s profit indicates room for improvement compared to leading markets like Germany.

Action: Benchmark Germany’s strategies to improve France’s performance.

📆 Temporal Trends

  • Profit Trend by Month & Quarter: A sharp decline occurs in mid-year (May–August), with recovery starting in October.
  • Profit Trend by Weekday: Best-performing days are Wednesday and Saturday, while Sunday and Tuesday show lower performance.
  • Profit by Sales Year: 2014 contributes 94.8% of the total profit, indicating significant growth compared to 2013.

🧩 Segment Analysis

Segment Profit
✅ Small Business£4.8M (Best)
Enterprise£1.8M
Government£1.4M
❌ Channel Partners-£2.9M (Loss)
❌ Midmarket-£3.4M (Worst)

Observation: The Small Business segment is the most profitable, while Channel Partners and Midmarket are significantly underperforming.

Action: Review and restructure Midmarket and Channel Partner models to reduce losses.

🏷️ Discount Effectiveness

Discount Band Profit
✅ Low£3.0M (Best)
Medium£2.4M
None-£0.4M
❌ High-£3.1M (Worst)

Insight: High discounts negatively impact profit, suggesting that a more selective discounting approach should be adopted.

🔍 Key Insights & Recommendations

  • Review Segments: Focus on restructuring Midmarket and Channel Partners for better performance.
  • Refine Discount Strategy: Reduce reliance on high discounts and prioritize value-driven sales strategies.
  • Optimize Weekday Performance: Increase engagement on Sundays and Tuesdays through targeted campaigns.
  • Leverage Seasonal Trends: Focus on strengthening sales in October and mitigating risk in July.

Crafted in Power BI | Profitability Optimization | Segment Analysis