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

Excel Power Pivot and Power Query For Dummies

ISBN: 978-1-119-21064-1
Paperback
288 pages
April 2016
US $29.99 Add to Cart
Other Available Formats: 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