Category leader
Home & Office
$29,233 revenue at 45.4% margin. Keep inventory and premium positioning protected.
Automated decision layer
Insights & recommendations
Plain-language business statements generated from the same Clean_Data model and active dashboard filters—designed for a concise interview walkthrough.
Category attention
Sports
$4,992 revenue. Test focused bundles before applying broad price reductions.
Best product
Summit Standing Desk
$18,678 revenue makes this the strongest individual demand signal.
Top revenue location
New York
$11,590 revenue; prioritize local retention and account expansion.
Executive narrative
Revenue concentration: Home & Office is the strongest category at $29,233, while Sports trails at $4,992. Maintain service levels for the leader and use targeted experimentation—not blanket discounting—for the weaker category.
Location opportunity: New York is the highest-revenue location, and Northeast has the largest profit contribution at $7,434. Replicate its account mix and product availability playbook in comparable markets.
Seasonality signal: Jan 25 is the strongest month at $6,864; May 25 is the lowest at $2,218. The most recent filtered month changed 47.3% down versus the prior month.
Recommended next moves
- 01Secure replenishment and complementary-product offers for Summit Standing Desk.
- 02Review cost-to-price coverage in Sports before increasing promotional spend.
- 03Use Northeast as the operating benchmark for higher-margin expansion.
Interview talking points
Data quality
Explain the immutable Raw_Data layer, exact date validation, duplicate Transaction_ID control, and downstream standardization.
Excel technique
Discuss structured tables, SUMIFS, XLOOKUP, UNIQUE, FILTER, SORT, IFERROR, PivotTables, and connected slicers.
Decision value
Show how KPIs and visuals convert a transaction table into inventory, regional, and promotion decisions.