Developed a comprehensive Power BI dashboard to provide senior management with critical business insights for market expansion strategies and strategic product selection.
The dataset stores global sales information for a company called Superstore. It consists of 03 data tables:
- Orders: a table that records transaction information.
- People: a table that contains information about salespeople in each region.
- Returns: a table that records returned transactions.
The senior manager wants to understand the company's business situation to develop market expansion strategies and make decisions about strategic product selection.
- Stage 1: Empathize
- Stage 2: Define POV
- Stage 3: Ideate
- Stage 4: Prototype and Review
Market
- Focus: Given the high revenue potential in the APAC, EU, US, the company should invest in marketing and distribution efforts in countries like Australia, France, Germany, and the US.
- Further Research on China: Focusing on China presents a significant opportunity for our company due to its high profit margins. As one of the largest consumer markets in the world, China offers immense potential for growth across various sectors, particularly in technology and office supplies.
Product
APAC:
Category & Sub-Category:
- Technology: Phones, Copiers
- Furniture: Bookcases, Chairs
Target Segment: Consumer, Corporate
EU:
Category & Sub-Category:
- Technology: Accessories, Phones, Copiers
- Office Supplies: Appliances, Art, Storage, Binders
Target Segment: Consumer, Corporate
US:
Category & Sub-Category:
- Technology: Accessories, Phones, Copiers
- Furniture: Chairs, Furnishings
- Office Supplies: Paper, Binders
Target Segment: Consumer, Corporate