Udemy - Power Pivot Workshop Complete Bundle (2015)

MP4 | AVC 704kbps | English | 1280x720 | 30fps | 10 hours | AAC stereo 62kbps | 2.83 GB

Genre: Video Training

This bundle include all the three courses of Power Pivot Workshop: Beginner, Intermediate, and Advanced. 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. The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot. 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. You do not need any previous experience in Power Pivot to take this course.

The course includes almost 10 hours of video in 73 lectures, divided in these sections:

Introduction to Self-Service Business Intelligence

Introduction to Power Pivot

Loading Data

Data Modeling

DAX Language

Table Functions and CALCULATE

Basic Time Intelligence

Power BI and SharePoint

Creating Reports and KPI

Advanced DAX Concepts

Advanced DAX Functions

DAX as a Query Language

DAX Patterns

01 Introduction to Self-Service Business Intelligence

02 Introduction to Power Pivot

03 Loading Data

04 Data Modeling

05 DAX Language

06 Table Functions and CALCULATE

07 Basic Time Intelligence

08 Power BI and SharePoint

09 Creating Reports and KPI

10 Advanced DAX Concepts

11 Advanced DAX Functions

12 DAX as a Query Language

13 DAX Patterns

14 Conclusion

15 Additional Material