BYU Student Author: @Michael_Barney
Reviewers: @James_Behling, @Saul_Esplin
Estimated Time to Solve: 30 Minutes
We provide the solution to this challenge using:
- Power BI
Need a program? Click here.
Overview
EcomX Retail is an online retail company specializing in consumer electronics, home appliances, and accessories. Over the past year, sales have fluctuated across different regions, product categories, and customer segments. The company’s leadership is concerned about declining sales in certain regions and wants data-driven insights to improve performance.
As a business analyst at EcomX, your task is to use Power BI to analyze the company’s sales data and provide actionable insights.
EcomX’s management has identified the following concerns:
Regional Sales Decline – Some regions have shown a drop in revenue, but leadership is unsure which ones and why.
Product Performance – Some product categories are selling well, while others are underperforming. The company needs to identify which categories contribute most to revenue and which need attention.
Customer Segmentation Insights – There is interest in understanding how different customer segments contribute to revenue. Are returning customers more valuable than new customers?
Seasonality Effects – Leadership suspects seasonal trends in sales but wants data to confirm.
Your challenge is to build a Power BI dashboard to address these concerns.
Instructions
Load Data into Power BI
You will receive a dataset containing sales transactions, including:
- Order ID
- Order Date
- Region
- Product Category
- Product Name
- Customer Type (New or Returning)
- Quantity Sold
- Revenue
- Profit Margin
- Discounts Applied
Create a Power BI Dashboard that answers these key questions:
Regional Sales Trends: Which regions are experiencing the most success? Provide a visualization using a column chart.
Product Performance: Which product categories generate the highest revenue? Provide a visualization using a funnel chart.
Customer Insights: Compare the sales contribution of new vs. returning customers. Provide a visualization using a pie chart.
Seasonality Analysis: Identify if there are specific months where sales peak or drop. Provide a visualization using a column chart column chart.
Data Files
Solution
