Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Michael Alexander
Excel Power Pivot and Power Query For Dummies
Cover
Cover
Introduction
About This Book
Foolish Assumptions
How This Book Is Organized
Icons Used In This Book
Beyond the Book
Where to Go from Here
Part I: Supercharged Reporting with Power Pivot
Chapter 1: Thinking Like a Database
Exploring the Limits of Excel and How Databases Help
Getting to Know Database Terminology
Understanding Relationships
Chapter 2: Introducing Power Pivot
Understanding the Power Pivot Internal Data Model
Activating the Power Pivot Add-In
Linking Excel Tables to Power Pivot
Chapter 3: The Pivotal Pivot Table
Introducing the Pivot Table
Defining the Four Areas of a Pivot Table
Creating Your First Pivot Table
Customizing Pivot Table Reports
Understanding Slicers
Creating a Standard Slicer
Getting Fancy with Slicer Customizations
Controlling Multiple Pivot Tables with One Slicer
Creating a Timeline Slicer
Chapter 4: Using External Data with Power Pivot
Loading Data from Relational Databases
Loading Data from Flat Files
Loading Data from Other Data Sources
Refreshing and Managing External Data Connections
Chapter 5: Working Directly with the Internal Data Model
Directly Feeding the Internal Data Model
Adding a New Table to the Internal Data Model
Removing a Table from the Internal Data Model
Creating a New Pivot Table Using the Internal Data Model
Filling the Internal Data Model with Multiple External Data Tables
Chapter 6: Adding Formulas to Power Pivot
Enhancing Power Pivot Data with Calculated Columns
Utilizing DAX to Create Calculated Columns
Understanding Calculated Measures
Free Your Data With Cube Functions
Chapter 7: Publishing Power Pivot to SharePoint
Understanding SharePoint
Understanding Excel Services for SharePoint
Publishing an Excel Workbook to SharePoint
Publishing to a Power Pivot Gallery
Part II: Wrangling Data with Power Query
Chapter 8: Introducing Power Query
Installing and Activating a Power Query Add-In
Power Query Basics
Understanding Column-Level Actions
Understanding Table Actions
Chapter 9: Power Query Connection Types
Importing Data from Files
Importing Data from Database Systems
Managing Data Source Settings
Chapter 10: Transforming Your Way to Better Data
Completing Common Transformation Tasks
Creating Custom Columns
Grouping and Aggregating Data
Chapter 11: Making Queries Work Together
Reusing Query Steps
Understanding the Append Feature
Understanding the Merge Feature
Chapter 12: Extending Power Query with Custom Functions
Creating and Using a Basic Custom Function
Creating a Function to Merge Data from Multiple Excel Files
Creating Parameter Queries
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
About the Author
Cheat Sheet
Advertisement Page
Connect with Dummies
End User License Agreement
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Excel® Power Pivot & Power Query
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset