This project involves creating a comprehensive business intelligence dashboard for a global retail company called Superstore. The dashboard aims to provide senior management with actionable insights for market expansion strategies and strategic product selection.
The company operates in a competitive global market, requiring strategic insight into regional performance and product success to maintain and expand its market position. With increasing demands for efficiency and profitability, senior management needs a clear, data-driven understanding of which markets and products drive the most value and where there may be operational challenges.
This project offers a clear view of global operations, helping senior management make informed decisions on market expansion and product optimization. The dashboard highlights key metrics on market and product profits, enabling leaders to identify strengths, address challenges, and make data-driven decisions to drive growth and efficiency.
The analysis is based on three main datasets:
- Orders: Contains detailed transaction information from global sales
- People: Stores information about sales representatives across different regions
- Returns: Tracks returned transactions and related data
- Power BI for Visualization: Design dashboards to display key insights visually, using charts, tables, and KPIs.
- Data Processing: Use Power Query to clean and transform data, and structure a well-designed data model.
- Calculations and Measures: Use DAX to create measures such as profit, ROS.
- Sales and Profit Trends: Both sales and profit have grown steadily over the years, with a noticeable increase in recent years. This shows an overall positive trend, potentially due to expanding markets or product demand.
- Market Analysis : The APAC region contributes the highest profit, followed by the EU and the US. These three regions account for a significant portion of overall profits, with APAC leading at 30%. EMEA, Canada, and Africa show lower profit contributions, indicating potential for improvement or that these markets are currently underutilized.
- Category Analysis : Technology products are the largest profit contributor (61%), followed by Office Supplies (20%) and Furniture (19%). This suggests that technology products are highly profitable and may have a strong demand.
- Segment Analysis : The Consumer segment contributes the highest profit (52%), followed by Corporate (30%) and Home Office (18%). This indicates that the Consumer segment is the primary market focus, which could guide future marketing and sales strategies.
- Within regions, Central EU and North America stand out for high profitability.
- The United States, China, and India are top-performing countries, contributing substantial profits.
- Sub-categories like Copiers and Phones are leading in profits, with Technology-related products (e.g., TEC-CO and OFF-AP series) among the most profitable items.
- Here are some outlines strategic focuses for large and limited capital investments across different regions highlighting the key markets, product categories, sub-categories, target segments, and countries to prioritize in order to optimize investment outcomes.
In conclusion, this project equips the senior management team with actionable insights into global operations, supporting data-driven decisions to enhance market reach, optimize product offerings, and boost overall business performance. The dashboard built provides a powerful tool for quickly identifying growth opportunities and addressing operational challenges, ultimately driving sustainable success.