This Power BI Market Performance Dashboard analyzes B2B sales performance across revenue, profitability, targets, geography, products, customers, sales teams, channels, promotions, and business events.

The report combines Sales Amount, Gross Profit, Gross Profit Margin, Target Achievement, Quantity Sold, Return Rate, Average Discount, Promotion Coverage, geographic contribution, product profitability, and sales execution metrics in one interactive analysis.

Executive Performance Overview

The Executive Performance Overview page provides a high-level view of current business performance and compares sales, profit, margins, and target achievement with the previous year.

• Track Sales Amount, Gross Profit, Gross Profit Margin, and Target Achievement.
• Compare current results with last year and YoY change.
• Analyze Sales Amount Change Over Time by quarter or month.
• Identify the top contributing products by sales contribution and YoY growth.
• Identify the strongest customer industries by sales contribution.
• Drill from region to country and from province to city.

Target Performance

The Target Performance view compares actual sales with target values and highlights where performance is above or below expectations.

• Track overall Target Achievement %.
• Compare Sales Amount with Target Sales Amount across each month.
• Review the Percentage Gap from Target for each period.
• Identify months where actual sales exceed target.
• Analyze Target Variance by Geography across Asia Pacific, Europe, and North America.

Commercial Performance Drivers

The Commercial Performance Drivers page focuses on products and customers to explain which commercial areas create sales, profit, and margin.

• Track Sales Amount, Gross Profit, Gross Profit Margin, Quantity Sold, and Return Rate.
• Compare Sales Amount with the previous year across monthly trends.
• Identify the top category by Sales Amount.
• Identify the strongest subcategories by Sales Amount.
• Compare products using Return Rate and Gross Profit Margin.
• Separate products into profitability groups such as Profitability Leaders, Return Resilient, Margin Pressure, and Profitability Risks.

Sales Execution & Commercial Performance

The Sales Execution and Commercial Performance page analyzes sales teams, channels, individual salespeople, volume, and profitability.

• Track Sales Amount, Quantity Sold, Total Orders, and Top Salesperson.
• Analyze monthly Sales Amount and compare results with the previous year.
• Identify the top sales team by Sales Amount and drill into role.
• Identify the top channel group by Sales Amount and drill into individual channels.
• Compare salespeople by Quantity Sold and Gross Profit Margin.
• Separate salespeople into groups such as Margin Efficient, Volume Leaders, Performance Gap, and Margin Pressure.

Promotions & Events

The Promotions and Events view analyzes discount activity, promotion coverage, sales impact, and the relationship between business events and commercial performance.

• Track Average Discount %, Discounted Value, Discounted Sales, and Promotion Coverage %.
• Compare promotion metrics with the previous year.
• Analyze Sales Amount trends alongside business events.
• Switch between Sales Amount, Gross Profit, Gross Profit Margin, Quantity Sold, and Average Order Value.
• Identify the top promotion type by Sales Amount.
• Compare promotion types using Average Discount, Sales Amount, Gross Profit, Gross Profit Margin, Quantity Sold, AOV, Discounted Value, and Promotion Coverage.

Geographic Performance

Geographic analysis allows users to move from broad regional performance into more detailed country, province, and city-level sales results.

• Compare Sales Amount by region.
• Drill from region to country.
• Compare leading provinces by Sales Amount.
• Drill from province to city.
• Compare geographic sales contribution with target variance.

Interactive Exploration

The report is structured around executive performance, commercial drivers, sales execution, target analysis, and promotions, allowing users to move from high-level KPIs into detailed product, geographic, team, channel, and promotion analysis.

• Switch between Performance Analysis and Target Performance.
• Switch between Products and Customers.
• Switch between Sales Team and Channel and Promotions and Events.
• Explore trends by month and quarter.
• Drill into geography, products, teams, channels, and salespeople.