GLOBAL SPORTS EXECUTIVE PERFORMANCE DASHBOARD

GLOBAL SPORTS EXECUTIVE PERFORMANCE DASHBOARD

This Power BI dashboard is designed to provide an executive view of a global sports merchandise e-commerce business. It transforms business data into meaningful insights to support informed decision-making.

Business Objective

The dashboard analyzes Revenue, Profit, Orders, Customers, Sessions, Conversion Rate, Regional Performance, and Product Performance to help identify business trends, opportunities, and areas for improvement.

Key Analysis

Executive Business Performance
Customer and Channel Performance
Regional Performance Analysis
Product Performance Analysis
Executive Insights and Recommendations

Data Preparation and Modeling

Power Query was used for data preparation, transformation, cleaning, and shaping. The data model follows a dimensional Star Schema approach and includes FactSales, FactTraffic, DimDate, DimProduct, DimCustomer, DimChannel, and DimRegion.

DAX and Measures

DAX measures were used for KPI calculations, profitability, pricing, customer analysis, channel analysis, regional analysis, product analysis, and time-based analysis.

Example:
Average Selling Price = DIVIDE([Net Revenue], [Quantity Sold], 0)

Key Business Insights

Revenue remained strong across key product categories.
Regional performance varied significantly across countries.
Customer engagement remained strong across channels.
High-performing product categories generated the largest share of revenue and profit.
Performance highlights opportunities for targeted growth.

Business Value

The dashboard uses interactive visuals, slicers, navigation, and executive storytelling to transform data into meaningful business insights and support informed decision-making.

Created By

Sachin S. Chavan
Pune, Maharashtra, India