Power Pivot Workshop Beginner + Intermediate Bundle

Course details

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.