for dummies store - a Wiley Brand
  • Print
  • Share
Excel Power Pivot and Power Query For Dummies (1119210666) cover image

Excel Power Pivot and Power Query For Dummies

ISBN: 978-1-119-21066-5
E-book
288 pages
March 2016
How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your e-book.

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

  • Print
  • Share