Learn how to use Power Pivot for Excel, writing DAX expressions and publishing reports to Power BI or SharePoint.

This bundle include two courses (Beginner and Intermediate). The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Intermediate course improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions.

Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics.

The course includes almost 6 hours of video in 49 lectures. You do not need any previous experience in Power Pivot to take this course.

Sections included in the Beginner course:

Introduction to Self-Service Business Intelligence
Introduction to Power Pivot
Loading Data
Data Modeling
Sections included in the Intermediate course:

DAX Language
Table Functions and CALCULATE
Basic Time Intelligence
Power BI and SharePoint
After this course, we suggest you to take the Power Pivot Workshop Advanced one.

Power Pivot Workshop Beginner + Intermediate Bundle.part1.rar
Power Pivot Workshop Beginner + Intermediate Bundle.part2.rar
Power Pivot Workshop Beginner + Intermediate Bundle.part3.rar
Power Pivot Workshop Beginner + Intermediate Bundle.part4.rar
Power Pivot Workshop Beginner + Intermediate Bundle.part5.rar
Power Pivot Workshop Beginner + Intermediate Bundle.part6.rar
Power Pivot Workshop Beginner + Intermediate Bundle.part7.rar