| Day | Modules | Sharing |
| 1 |
- Exploring the Limits of Excel and How Databases Help
- Getting to Know Database Terminology
- Understanding Relationships
- Understanding the Power Pivot Internal Data Model
- Linking Excel Tables to Power Pivot
- 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
- Loading Data from Relational Databases
- Loading Data from Flat Files
- Loading Data from Other Data Sources
- Refreshing and Managing External Data Connections
- Directly Feeding the Internal Data Model
- Managing Relationships in the Internal Data Model
- Managing Queries and Connections
- Creating a New Pivot Table Using the Internal Data Model
- Filling the Internal Data Model with Multiple External Data Tables
|
Slides:
Demo Materials:
|
| 2 |
- Enhancing Power Pivot Data with Calculated Columns
- Utilizing DAX to Create Calculated Columns
- Understanding Calculated Measures
- Free Your Data with Cube Functions
- DAX Language Fundamentals
- Understanding Filter Context
- Power Query Basics
- Understanding Column-Level Actions
- Understanding Table Actions
- Importing Data from Files
- Importing Data from Database Systems
- Managing Data Source Settings
- Data Profiling with Power Query
|
Slides:
Demo Materials:
|
| 3 |
- Completing Common Transformation Tasks
- Creating Custom Columns
- Grouping and Aggregating Data
- Working with Custom Data Types
- Reusing Query Steps
- Understanding the Append Feature
- Understanding the Merge Feature
- Understanding Fuzzy Match
- Creating and Using a Basic Custom Function
- Creating a Function to Merge Data from Multiple Excel Files
- Creating Parameter Queries
- 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 Many Unique 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
- Getting Quick Information from the Queries & Connections Pane
- Organizing Queries in Groups
- Selecting Columns in Queries Faster
- Renaming Query Steps
- Quickly Creating Reference Tables
- Viewing Query Dependencies
- Setting a Default Load Behavior
- Preventing Automatic Data Type Changes
- Disabling Privacy Settings to Improve Performance
- Disabling Relationship Detection
|
Slides:
Demo Materials:
Useful Links:
|
