Master Excel PowerPivot - Data Analysis & DAX for Beginners
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 29 lectures (2 hour, 43 mins) | Size: 1.44 GB

Use the PowerPivot Data Model & DAX functions to speed up your data analysis. Learn KPIs, Measures & Custom Hierarchies.
What you'll learn

This is a complete course on mastering PowerPivot
You'll learn basic data structure techniques.
You'll learn common data relationship definitions.
You'll learn basic DAX patterns.
You'll learn to construct PivotTables with PowerPivot.

Requirements

You should have access to Excel 365 or Excel 2019
There are no other requirements except for an interest in learning PowerPivot

Description

A brief glimpse of PowerPivot's usefulness and capabilities...

This course is designed for all Excel users -- not just power users capable of building incredible Excel worksheets with functions, VBA, and mystical trickery. Even if you never write a single formula, this course will teach you to build basic relationships and create PivotTables from multiple mapped tables without a single formula.

The course will also introduce you to the DAX formula language. DAX is very similar to Excel formulas; however, you do not need to have experience with Excel formulas in order to use them. DAX and it's concept of context can allow you to replicate many complex Excel formulas with very simple DAX formulas.

You'll learn to write formulas that are deceivingly simple yet generate results that seem like magic tricks.

Dramatically increase the your data crunching capabilities with PowerPivot