⚒ Tools:

✔Skill:

☰ Short Description

📊 PowerBI

• Utilized AI visualizations to identify top income influencers.

• Applied DAX and Power Query to clean, model, and transform data.

• Developed a branded, interactive report using bookmarks for spotlight storytelling and presentations.

• Conducted an income pattern analysis to uncover key performance drivers.

• Enhanced stakeholder understanding through interactive visual insights.

• Delivered actionable recommendations using data-driven storytelling in Power BI.

Overview

This project will benchmark Sintec (a fictional manufacturing company) against competitors across category, segment, product, and country. It surfaces where revenue concentrates, what drives YoY growth, and which influencer, micro-segments deliver outsized returns and drive the revenue. Additionally, this project leverage AI integrated in PowerBI to visualize the patterns and insights.

What you will find in this project:

• Market snapshot (revenue, growth, share, mix)
• Brand–country performance and localization opportunities
• AI-assisted insights: Top Segments & Key Influencers
• Decomposition paths to pinpoint winning SKU × segment combos
• Actionable recommendations for merchandising, marketing, and supply

Analysis Process

• Ingest & Clean: Unified sales, product, category, segment, and geo tables; standardized product codes; handled blanks.
• Model & Measures: Star schema; DAX for Revenue, PY Sales, % Growth, % GT Revenue, Market Share.
• Visual Design: KPI cards, brand carousel, Country × Manufacturer bars, detail drill-through, AI visuals (Top Segments, Key Influencers), Decomposition Tree, and bookmarks for guided storytelling.
• QA: Validated totals vs detail; flagged small-denominator growth spikes; sorted tables descending by % Growth to surface outliers.

Key Insights

• Urban is the engine: ~77% of revenue with ~59% YoY growth, core segment still scaling.
• Fastest growth, small base: Youth & Mix grow ~64–63%, but tiny shares (3%/2%)—use test-and-learn, not broad rollout.
• Brand–country fit matters: Sintec: USA (~$47M); Artisans: Japan then Germany. Localize assortments by pairing.