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 |