Power Pivot Workshop Beginner + Intermediate Bundle

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 6 Hours | 1.80 GB

Genre: eLearning | Language: English

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.