Excel Power Pivot & Power Query For Dummies

ISBN-13: 9781119844488 / Angielski / Miękka / 2022 / 288 str.

TX) Alexander Michael (McKinney

Spis treści

Introduction 1Part 1: Supercharged Reporting with Power Pivot 5Chapter 1: Thinking Like a Database 7Chapter 2: Introducing Power Pivot 17Chapter 3: The Pivotal Pivot Table 29Chapter 4: Using External Data with Power Pivot 63Chapter 5: Working Directly with the Internal Data Model 89Chapter 6: Adding Formulas to Power Pivot 103Chapter 7: Diving into DAX 121Part 2: Wrangling Data with Power Query 141Chapter 8: Introducing Power Query 143Chapter 9: Power Query Connection Types 159Chapter 10: Transforming Your Way to Better Data 175Chapter 11: Making Queries Work Together 207Chapter 12: Extending Power Query with Custom Functions 225Part 3: The Part of Tens 243Chapter 13: Ten Ways to Improve Power Pivot Performance 245Chapter 14: Ten Tips for Working with Power Query 253Index 263

O autorze

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years' experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.