Visualizing Data: the Good, the Bad, and the Ugly
summary
Argues that clear decisions beat buzzwords and demonstrates Excel, Power Query/PowerPivot, Power View, Power BI and Reporting Services on real export data; shows avoid 3D and no scale breaks because they mislead, and recommends grouping tiny categories. Builds pivot charts, toggles line vs column, uses Power BI highlighting and pins visuals to dashboards, exports PDFs (layout needs manual fixes), and notes the conference has over 200 sessions and over 5,000 registrants.
AI-written summary · about
chapters (31)
- 0:00Introduction
- 12:36Time Series
- 15:01Ranking
- 15:38Deviations
- 16:30The Ugly
- 22:03The Rules
- 25:30Scale Variants
- 26:14Stacked Column Chart
- 26:47Excel
- 26:58Reporting Services
- 28:21Pivot Chart Options
- 30:05Pivot Chart Field Settings
- 30:50Remove Gridlines
- 31:46Export to PDF
- 33:01Power View
- 33:45Table View
- 34:25clustered column chart
- 35:07reordering charts
- 35:48adjusting charts
- 36:06highlighting
- 36:30additional formatting
- 36:49change fonts
- 37:08change background images
- 37:31Power BI
- 38:58Column Chart
- 39:37Color Picker
- 44:13Back to PowerPoint
- 44:51Data Visualizations
- 45:52Perfection is finally attained
- 46:21Questions
- 46:41Question
related talks
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
11mData Visualization & Storytelling
01h 10mStorytelling through data
54mMy Brain Hurts: Presenting Data with Microsoft Tools
01h 04mThe Art of Prototyping Analytics
01h 01mEffective Data Visualization
01h 09mThe Valued Analyst: From Data to Insight in 60 Minutes
20mLevel-Up Power BI Dashboard Storytelling with DataViz Tools