Course Info
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?
Defining Measures for business performance.
- Distinguishing the role of measures.
- Translating key business concepts into measures
Implementing DAX functions in Power Pivot
- Expressing information with measures
- Exposing hidden information from data
Exploiting data analytics with aggregation
- Quantifying information with DAX functions
- Aggregating data from other tables
Performing date and time analysis
- Grouping dates for time analysis
- Comparing and categorizing time periods with time intelligence functions
Target Audience
Pre-requisites
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
- Measures
- Choosing between Calculated columns and Measures
Simple DAX Functions
- SUMX
- RELATED
- DISTINCTCOUNT
- FILTER
- DISTINCT
- RELATEDTABLE
- COUNT
- COUNTX
- COUNTAX
- COUNTROWS
- DIVIDE
Row context and Filter context
- Row context
- Functions to aggregate expressions
- Filter context
- Relationships and Filter Context
- Measures and Filter Context
