Descriptive Analytics and Visualization: From PivotTables to Power BI and Data Storytelling (Analytics at Work)

What moved, why, and the chart that says so.

A report that answers a diagnostic question with a descriptive picture wastes everyone's time. This book runs from the pivot table to a tested executive dashboard, by way of the analyses that actually explain a change.

Ten bad charts are rebuilt in full, and the last chapter is the one-page memo that turns a finding into a decision.

What you will be able to do

• Variance, the price-volume-mix bridge, cohorts, retention and lead times
• Concentration, seasonality, trend and residual — read correctly
• What a chart encodes, how to choose one, and the axis that lies
• The model behind a dashboard, and the same measure in DAX and in SQL
• Designing an executive dashboard and testing it with three users

Who it is for

Analysts and managers who publish reports, and anyone whose dashboard is being ignored.

The labs

Every chapter ends with a practice lab. Each one can be worked in the tools you already have, or in a free browser version that checks your answer as you go — no account, no install. The address is printed inside the book.

About the series

Analytics at Work is an eight-book series for business professionals. All eight run on the same thirty-six months of enterprise data from Cedar Ridge Brands, a fictional American consumer-goods maker. This is Book 4 of 8.