Strategic Questions & Analysis Framework
Before diving into data, define what questions matter most — and for whom.
As a Sales Data Analyst at Gondowangi, the job isn't just making charts — it's answering the questions that drive business decisions. Here are the 3 strategic questions this analysis addresses.
Strategic Questions
Q1: How are Gondowangi brands performing vs competitors in each category?
With 4 brands across 8 categories, management needs to know where Gondowangi is winning and where it's losing. Market share by category tells us which brands need more investment and which categories to deprioritize.
Q2: Which regions are underperforming relative to their potential?
Gondowangi distributes across 10 regions in Indonesia. Some regions may have high population but low sales penetration — these are growth opportunities.
Q3: What's the optimal channel mix for maximizing revenue and margin?
With 6 sales channels, each has different margin profiles. E-commerce is growing fast but comes with platform fees. The question is: where should Gondowangi invest?
Analysis Framework
| Lens | Metric | Why It Matters |
|---|---|---|
| Brand Performance | Revenue share, growth rate, category rank | Identify which brands are winning/losing |
| Regional Analysis | Revenue per region, penetration rate | Find underserved markets with growth potential |
| Channel Mix | Revenue share, margin estimate, growth trend | Optimize distribution for profitability |
| Competitive Intel | Market share, price positioning, category dominance | Understand competitive threats and opportunities |
💡 Senior vs Junior Thinking
A junior analyst would jump straight to "let me make a bar chart of revenue by brand." A senior analyst asks: "Who needs this information, what decision will they make with it, and what's the business impact?" Every chart in this portfolio exists because a stakeholder needs it to make a specific decision.