MS Excel 2016 – Multidimensional analysis with Power Pivot using DAX

The course is designed for people who want to learn about Power BI tools in Excel, allowing to optimize the analysis of large data sets and reporting in Excel

Ability to create analyses based on a large, distributed data set and generating attractive reports.

Effective navigation in the MS Excel 2013 interface. Knowledge of basic tools and formulas and basic functions.

• Training: English

1. Introduction
   • What is Power Pivot
   • The main benefits of using PowerPivot to analyse data in Excel
   • PowerPivot and multidimensional analysis terminology
   • What is Power View?
   • What is Power Query ?
2. Creating data models
   • Importing data to the model (from many sources)
     • From the active workbook
     • From other workbooks
     • From txt, csv files
     • From databases
   • Adding sources obtained with the help of Power Query
     • Import and transformation of file sources
     • Import and transformation of Internet sources
   • Creating relationships
3. Improving models using DAX (Data Analysis eXpressions language)<
   • Creating calculated columns
     • Necessary model adjustments using the RELATED function
     • Creating calculated measures
     • Creating calculated dimension elements and hierarchies
   • Creating calculated fields
     • Classified
     • Transparent
   • &Creating key performance indicators (KPIs)
4. Reporting from PowerPivot models
   • Tables and pivot charts
     • The rules for proper use of the pivot table
     • Differences in functionality of the PivotTable based on PowerPivot compared to the standard PivotTable
     • Slicers
     • Timeline
5. Downloading tables from the PowerPivot model
6. Power View sheets
   • Tables:
     • Sorting
     • Filtering
     • Charts
     • Maps