Table of Contents

Introduction 1 Part I: Supercharged Reporting with Power Pivot 7 Chapter 1: Thinking Like a Database 9 Chapter 2: Introducing Power Pivot 19 Chapter 3: The Pivotal Pivot Table 33 Chapter 4: Using External Data with Power Pivot 67 Chapter 5: Working Directly with the Internal Data Model 93 Chapter 6: Adding Formulas to Power Pivot 107 Chapter 7: Publishing Power Pivot to SharePoint 125 Part II: Wrangling Data with Power Query 135 Chapter 8: Introducing Power Query 137 Chapter 9: Power Query Connection Types 155 Chapter 10: Transforming Your Way to Better Data 171 Chapter 11: Making Queries Work Together 201 Chapter 12: Extending Power Query with Custom Functions 215 Part III: The Part of Tens 233 Chapter 13: Ten Ways to Improve Power Pivot Performance 235 Chapter 14: Ten Tips for Working with Power Query 243 Index 255

About the Author

Michael Alexander is a Microsoft Certified Application Developer and a Microsoft MVP. He has written numerous books on advanced business analysis with Microsoft Access and Excel. His tutorial website, www.datapigtechnologies.com, provides tips on Excel and Access for the Microsoft Office community.