PowerPivot Alchemy: Patterns and Techniques for Excel

Book Description Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. Alchemy sets aside the fundamentals of past books and provides a series of practical, easy-to-follow “patterns” for dozens of common analysis, reporting, and dashboarding needs. Three “bonus” chapters introduce you to the newer members of the “Power BI” family – Power Query, Power View, and Power Map. Whether you are starting your transformation from “old school” Excel User to Modern Data Professional or a veteran of the Power BI arts, this book will dramatically expand your data superpowers.

Content

Chapter 1: Dashboard Tricks and Visualization Techniques
Chapter 2: Slicers: The Gateway to Interactivity
Chapter 3: Conquering Common Calculated Column Conundrums
Chapter 4: Modeling and Portable Formulas
Chapter 5: Power Query
Chapter 6: Power View
Chapter 7: Power Map