Microsoft Excel Power Pivot

Data Analysis Using ‘Get & Transform’ and Microsoft Excel Power Pivot

Description:The topics included in this course provide the user with additional
tools for data analysis. The course covers importing data from a
variety of sources, analysing quantities of data beyond the normal
scope of Excel and speeds up linking data held in different tables
Pre-requisites:Delegates must have an advanced knowledge of Microsoft Excel
and be comfortable using Pivot Tables
Duration:One Day
An Introduction to Get and Transform
Import Data from Different Sources
Use the Power Query Editor to Transform Data
Add Calculated Columns
Load Data into the Data Model
Data Models in Excel
Integrate Data from Multiple Tables
Create Relationships Between Tables
Display the Information in PivotTables
Power Pivot
Top Features
Connect Power Pivot to Data Sources
Add or Remove Imported Columns
Add Calculated Columns
Use the Diagram View to Create Relationships
Measures
Implicit vs Explicit Measures
Create Explicit Measures Using DAX
CALCULATE()
DISTINCTCOUNT()
FILTER()
Creating Parameterised Reports
Create Measures Based on a Parameter Table
List Items Based on Specified Parameters

Angela Jones

Angela is our Training26's Manager and has a strong background in customer facing roles. Angela joined Training 26 to enjoy a new challenge