Presenting Analysis: From Numbers to a Story, Writing the Analysis Email, and Matching the Chart to the Question

Returns example: 5,400 sold, 1,410 returned (26.1%). Bullets: returns 26%, lower than last year; about 70% of returns are size-related and rising; roughly 43% of returns (wrong size received, damaged in transit) are within the company's control - so tighten QC; the biggest bucket, customers ordering the wrong size, needs customer-journey work and a deeper study. The same thinking shapes the email: subject "November 23 Diwali sales analysis", "Hi Kumar", a snapshot (revenue up year on year on traffic growth, top categories), actions for the next sale, and a file named for its content.

Pie: category share (t-shirts about a third of sales). Area: Apple revenue by business over quarters - iPhone growing, iPod shrinking. Revenue-cost-profit chart coloured blue, red, green. Waterfall: growing 50 to 75 crores via market growth, new products and marketing, with negative steps allowed. Pictorial charts for markets and price bands. Exercise: a beauty brand's nail paints and mascara by region versus two competitors - grouped bars show it leads nail paints in North and South but trails in the East, and is a close second in mascara with a gap in the North, so you know where to dig. Assignment: a two-slide leadership deck from the chapter 4 dataset.