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.