Objective: To identify the key drivers of revenue and profit across different regional markets and sales channels.
The Data: Analyzed multi-regional sales data categorized by Sales Band, Channel, and Product Category.
Technical Execution:
Utilized Pivot Tables to segment revenue by "Region & Channel."
Applied Calculated Fields to determine the most profitable product categories.
Performed Sales Band Distribution to see which transaction sizes drive the most volume.
Key Business Insights:
Winning Combination: The East Region + Online Channel is the primary revenue engine.
Profit Leader: While many items are sold, the Electronics category maintains the highest profitability.
Top Performer: Identified Lina as the leading salesperson by profit contribution.
Revenue Driver: The High Sales Band dominates total revenue, suggesting a focus on premium transactions is most effective.