An executive asking how sales are going could mean global or one region, volume or growth, this quarter or the year.
- The numbers only meant something next to their change. 18.6 billion cases means nothing without +4.1%.
- Sparkling is two-thirds of everything. Energy is tiny, and it was the only line going down.
- The report had five tabs and no clear first page.
- Someone had to decide what an executive sees first.
A front door with two depths
Three subjects, two levels. Key brands, unit cases, and revenue as an executive summary in Coca-Cola red, then the same three as detailed analysis in gray. The level you probably don't need looks quieter.
Every number comes with its change
The top row shows how big. The bottom row shows which way, against last year. Gray charts slice by region, because a region isn't something you drink. Colored charts slice by product, with Sparkling in Coca-Cola red. Declines show at the same weight as gains.
You can see where you are
Drill into a region and a tab row and filter chips appear. The active group is filled in and the breadcrumb shows the path, so you know what you're looking at without reading the title. "Ask a question" stays in the header as its own way in.
- Each number shown with its change, every time.
- Gray for regions, brand colors for products.
- Declines shown as plainly as gains.
- Drill-down state you can see at a glance.
- A front door that picks the starting point for you.
The report went into Coca-Cola's executive reviews.
- Executives got to the number they wanted in one or two clicks.
- Fewer side requests for custom cuts of the same data.
- The color and comparison rules carried into other Power BI reports.