We use cookies to provide essential features and services. By using our website you agree to our use of cookies .


Warehouse Stock Clearance Sale

Grab a bargain today!

Excel Power Pivot and Power Query for Dummies


Product Description
Product Details

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.

This item has low availability through normal channels. The supplier has a low reliability rating in Fishpond's system and may not arrive on time. Learn more.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
Item ships from and is sold by Fishpond.com, Inc.
Back to top