Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Power Pivot Workshop Advanced

Improve your Power Pivot skills to master level, learning advanced DAX functions and data modeling techniques.
(54 reviews)
164 students
Created by


CourseMarks Score®







Platform: Udemy
Video: 3h 52m
Language: English
Next start: On Demand

Table of contents


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.
The course includes almost 4 hours of video in 24 lectures. You need some experience of Power Pivot and the DAX language, or you should take the Beginner and Intermediate courses before this one.
Sections included in this course:
Creating Reports and KPI Advanced DAX Concepts Advanced DAX Functions DAX as a Query Language DAX Patterns After this course, you will have all the tools and the knowledge to create complex calculations and models using Power Pivot for Excel.

You will learn

✓ By the end of the course, you will be able to use advanced DAX functions and to create complex data models in Power Pivot.
✓ You will learn how to solve typical business issues by applying predefined patterns in DAX


• Power Pivot for Excel 2010 or Excel 2013

This course is for

• Advanced Excel Users
• Business Analysts
• Business Intelligence Developers
• Data Scientists
Business Intelligence expert at SQLBI – SSAS Maestro & MVP
Marco is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 1999 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe.
Marco is also a book author and wrote two books for Microsoft Press about Power Pivot with Alberto Ferrari: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 3h 52m
Language: English
Next start: On Demand

Students are also interested in