Acerca del autor

Rob Collie, one of the founding engineers behind Power Pivot during his 14-year career at Microsoft and creator of the world's first Power Pivot service, is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology. In 2010, he realised that Power Pivot was not "just another tech" and that its power resided not in the software itself, but in the unique way it empowers human beings. Inspired, he left Microsoft and founded a consulting and training company, P3Adaptive.com to make that human empowerment his full-time mission. Avichal Singh built a successful Power Pivot BI platform during his tenure at Microsoft. Avichal has a Masters in Computer Science from the University of Washington and spend 10+ years as a business analyst at Microsoft.

Fragmento. © Reproducción autorizada. Todos los derechos reservados.

Power Pivot and Power BI: the Excel User's Guide to the Data Revolution

Holy Macro! Books

Contents

Dedications, 
Supporting Workbooks and Data Sets, 
Errata and Book Support, 
A Note on Hyperlinks, 
Foreword and Forward, 
Introduction - Our Two Goals for this Book, 
1 - A Revolution Built On YOU, 
2 - Power Pivot and the Power BI Family: Making Sense of the Various Versions, 
3 - Learning Power Pivot "The Excel Way", 
4 - Loading Data Into Power Pivot, 
5 - Intro to Calculated Columns, 
6 - Introduction to DAX Measures, 
7 - The "Golden Rules" of DAX Measures, 
8 - CALCULATE() – Your New Favorite Function, 
9 - ALL() – The "Remove a Filter" Function, 
10 - Thinking in Multiple Tables, 
11 - "Intermission" – Taking Stock of Your New Powers, 
12 - Disconnected Tables, 
13 - Introducing the FILTER() Function, and Disconnected Tables Continued, 
14 - Introduction to Time Intelligence, 
15 - IF(), SWITCH(), BLANK(), and Other Conditional Fun, 
16 - SUMX() and Other X ("Iterator") Functions, 
17 - Multiple Data Tables, 
18 - Multiple Data Tables – Differing Granularity, 
19 - Performance: Keep Things Running Fast, 
20 - Power Query to the Rescue, 
21 - Power BI Desktop, 
22 - "Complicated" Relationships, 
23 - Row and Filter Context Demystified, 
24 - CALCULATE and FILTER – More Nuances, 
25 - Time Intelligence with Custom Calendars: Greatest Formula in the World, 
26 - Advanced Calculated Columns, 
27 - New DAX Functions ... and Variables!, 
28 - "YouTube for Data" – The Importance of a Server, 
PS: Can We Ask You for a Special Favor?, 
A1 - Power Pivot and SSAS Tabular: Two Tools for the Price of One (again!), 
A2 - Cube Formulas – the End of GetPivotData(), 
A3 - Some Common Error Messages, 
A4 - People: The Most Powerful Feature of Power Pivot, 
Index,