Book description
A guide to PowerPivot and Power Query no data cruncher should be without!Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities.
Gone are the days of relatively small amounts of data—today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting.
- Demonstrates how Power Query is used to discover, connect to, and import your data
- Shows you how to use PowerPivot to model data once it's been imported
- Offers guidance on using these tools to make analyzing data easier
- Written by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brand
If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life—and work—easier.
Table of contents
-
- Cover
- Introduction
-
Part I: Supercharged Reporting with Power Pivot
- Chapter 1: Thinking Like a Database
- Chapter 2: Introducing Power Pivot
- Chapter 3: The Pivotal Pivot Table
- Chapter 4: Using External Data with Power Pivot
- Chapter 5: Working Directly with the Internal Data Model
- Chapter 6: Adding Formulas to Power Pivot
- Chapter 7: Publishing Power Pivot to SharePoint
- Part II: Wrangling Data with Power Query
-
Part III: The Part of Tens
-
Chapter 13: Ten Ways to Improve Power Pivot Performance
- Limit the Number of Rows and Columns in Your Data Model Tables
- Use Views Instead of Tables
- Avoid Multi-Level Relationships
- Let the Back-End Database Servers Do the Crunching
- Beware of Columns with Non-Distinct Values
- Limit the Number of Slicers in a Report
- Create Slicers Only on Dimension Fields
- Disable the Cross-Filter Behavior for Certain Slicers
- Use Calculated Measures Instead of Calculated Columns
- Upgrade to 64-Bit Excel
-
Chapter 14: Ten Tips for Working with Power Query
- Getting Quick Information from the Workbook Queries Pane
- Organizing Queries in Groups
- Selecting Columns in Queries Faster
- Renaming Query Steps
- Quickly Creating Reference Tables
- Copying Queries to Save Time
- Setting a Default Load Behavior
- Preventing Automatic Data Type Changes
- Disabling Privacy Settings to Improve Performance
- Disabling Relationship Detection
-
Chapter 13: Ten Ways to Improve Power Pivot Performance
- About the Author
- Cheat Sheet
- Advertisement Page
- Connect with Dummies
- End User License Agreement
Product information
- Title: Excel Power Pivot and Power Query For Dummies
- Author(s):
- Release date: April 2016
- Publisher(s): For Dummies
- ISBN: 9781119210641
You might also like
book
Excel Power Pivot & Power Query For Dummies, 2nd Edition
Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a …
book
Analyzing Data with Power BI and Power Pivot for Excel, First Edition
Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for …
video
Microsoft Excel - Pivot Tables In-Depth
In this Microsoft Excel – Pivot Tables training course, expert author Erin Olsen teaches you everything …
book
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
Renowned Excel expert Bill Jelen (MrExcel) helps you crunch data from any source with Excel pivot …