Power Pivot is an add-in for Microsoft Excel 2013 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance. This hands-on course demonstrates how to take advantage of self-service business intelligence using Microsoft PowerPivot for Excel.
What Will I Learn From This Course?
- Distinguishing the role of measures.
- Translating key business concepts into measures
- Expressing information with measures
- Exposing hidden information from data
- Quantifying information with DAX functions
- Aggregating data from other tables
- Grouping dates for time analysis
- Comparing and categorizing time periods with time intelligence functions
Delegates should be proficient users of Excel and be familiar with the basics in creating Power Pivots, understand the concept of relationships in related tables.
At Course Completion:
Recap on the Fundamentals of PowerPivot
This module explains how to bring your data into Excel whether it’s an external source, text files, Excel data and other sources. It also shows you how to build relationships between tables which is vital to data analysis.
- Importing Data
- Creating Linked Tables
- Managing Relationships
- Creating A Power Pivot
Recap on Data Analysis Expressions (DAX)
PowerPivot has its own syntax for defining calculation expressions. It is conceptually similar to an Excel expression, but it has specific functions that allow you to create more advanced calculation on data stored in multiple tables.
- DAXS operators
- DAXS context
- Calculated Columns
- Choosing between Calculated columns and Measures
Simple DAX Functions
Row context and Filter context
- Row context
- Functions to aggregate expressions
- Filter context
- Relationships and Filter Context
- Measures and Filter Context