Pragmatic Self-Service BI with PowerPivot for Excel
This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You'll soon be assembling data from diverse sources into models that deliver business intelligence upon demand.
What you'll learn
Use PowerPivot for Excel to deliver self-service business intelligence! This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You'll soon be assembling data from diverse sources into models that deliver business intelligence upon demand. Throughout the rapid but practical exercises, you will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise.
Table of contents
- Introduction and Installation 3m
- Check for Installation 1m
- Demo: Verify Installation 0m
- Self-Service BI and PowerPivot 4m
- Managed Self-Service Business Intelligence 4m
- How PowerPivot Works 5m
- Demo: A Brief Overview of PowerPivot 2m
- Importing Text into PowerPivot 0m
- Demo: Import a Text File 4m
- Importing from Excel to PowerPivot 1m
- Demo: Import from Excel 2m
- Files Underlying PowerPivot 1m
- Demo: Examine Files Underlying PowerPivot 1m
- PowerPivot with SharePoint 4m
- PowerPivot Features and Limitations, and Relationships 5m
- Demo: Add a Relationship 3m
- Calculated Columns with DAX Examples 1m
- Demo: Add Calculated Columns 4m
- Mount PivotTable with a Measure 1m
- Demo: Create a Basic Dashboard with PowerPivot Data 5m
- Installation and Overview Summary 1m
- Introduction and Distinctive PowerPivot Features 3m
- PowerPivot PivotTables vs. Standard PivotTables, and Data Sources 3m
- Demo: Import SQL Server Relational Database Tables to PowerPivot 3m
- Examining Imported Relationships 0m
- Demo: Examine Imported Relationships 3m
- Creating a Basic PowerPivot PivotTable 1m
- Demo: Create a Basic PowerPivot PivotTable 2m
- Querying PowerPivot Data from within a PivotTable 3m
- Data Quality and Data Governance Considerations 2m
- Avoiding Disaster and Basic PowerPivot Data Model Summary 4m
- Introduction 1m
- Navigating PowerPivot and Manipulating Data 3m
- Manipulating Data: Formatting 2m
- Manipulating Data: Data Types 1m
- Manipulating Data: Sorting 2m
- Manipulating Data: Filtering, and Working with Columns 2m
- Calculated Columns in PowerPivot 4m
- Introducing Data Analysis Expressions (DAX) 3m
- DAX Functions: Type Groupings 2m
- Working with DAX: The Basics 4m
- Enhancing the Model and Designing Calculated Columns 3m
- Adding Calculated Columns to the Model 4m
- Adding a Missing Relationship 4m
- The Related() Function and Concatenation 4m
- More about Concatenation, and Date / Time Functions 4m
- Logical-type Functions 3m
- A Few More DAX Functions, and Summary 4m
- Introduction 1m
- Planning, Importing and Relating Data in the PowerPivot Model 4m
- Adding Support Tables 5m
- Creating a Calendar Support Table 3m
- Importing Data via a Linked Table and Creating a Relationship 3m
- Adding Date-related Calculations 4m
- Overview: Holiday Support Table 6m
- Reviewing Results in a PivotTable 2m
- Summary 1m
- Introduction 1m
- Add Further Support Logic 3m
- Discussion: Adding Support for Calculating Operating Days 2m
- Building Structural Support for Operating Days 2m
- Review Results via a PivotTable: Operating Days 2m
- Adding Time Intelligence: 'To-Date' Aggregations 4m
- Review Results via a PivotTable: 'To-Date' Aggregations 4m
- Adding Time Intelligence: 'Prior Time Periods' 5m
- Review Results via a PivotTable: 'Prior Time Periods' 4m
- Adding Time Intelligence: 'Prior Year plus Rolling Total' 2m
- Review Results via a PivotTable: 'Prior Year' 2m
- Review Results via a PivotTable: 'Rolling Total' 3m
- Averages, Sharing Calculations and More ... 4m
- Review Results via a PivotTable: Averages and More ... 3m
- Summary 1m
- Introduction and Objectives 1m
- PivotTable and PowerPivot Field List Overview 5m
- Demo: Examine the PowerPivot Field List 3m
- Building a PivotTable with PowerPivot Data 1m
- Perform a Review from the PowerPivot Window 4m
- Demo: Design and Construct a PivotTable from Scratch 5m
- Calculated Measures in the PivotTable 3m
- Demo: Create Calculated Measures 5m
- Understanding Evaluation Context 3m
- Key Performance Indicators (KPI's) 6m
- Demo: Examine a Simple KPI 4m
- PivotTable Rules of the Road 3m
- Summary 1m