Power Pivot Workshop – Video Course
Learn to master Power Pivot for Excel from your chair with our high quality video course.
This video course is divided in three parts: the first one (Beginner) 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 Beginner section is completely available in the free trial , you are just one click away to start.
The second part of the course (Intermediate) 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 last part (Advanced) 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.
Introduction to Self-Service Business Intelligence
Introduction to Self-Service Business Intelligence
FREE
Self-Service BI
FREE
Power Pivot
FREE
Power Query
FREE
Power View
FREE
Power Map
FREE
Introduction to Power Pivot
Introduction to Power Pivot
FREE
PivotTables in Excel
FREE
PivotTables in Excel 2013
FREE
Using Power Pivot
FREE
Calculated Columns
FREE
Linked Tables
FREE
Calculated Fields
FREE
Publishing to Power BI
FREE
Loading Data
Loading Data
FREE
Loading Data in Power Pivot
FREE
Loading from SQL Tables
FREE
Loading from SQL Queries
FREE
Loading from Access
FREE
Loading from Analysis Services
FREE
Using Linked Tables
FREE
Loading from Excel
FREE
Loading from Text Files
FREE
Loading from the Clipboard
FREE
Loading from Reports
FREE
Loading from Data Feeds
FREE
Loading from Azure Marketplace
FREE
Loading from SharePoint
FREE
Data Connection Properties
FREE
Data Modeling
Data Modeling
FREE
Introduction to Data Models
FREE
Normalization and Denormalization
FREE
Star Schemas
FREE
Over Denormalization
FREE
DAX Language
DAX Language
FREE
Introduction to DAX
FREE
Calculated Columns and Calculated Fields
DAX Error Handling
Overview of DAX Functions
Table Functions and CALCULATE
Table Functions and CALCULATE
FREE
RELATED and RELATEDTABLE functions
FILTER and ALL functions
CALCULATE function
Visual Totals and ALLSELECTED
Basic Time Intelligence
Basic Time Intelligence
FREE
What is Time Intelligence
Calendar Table
Counting Working Days
Multiple Calendar Tables
Aggregations Over Time
Power BI and SharePoint
Power BI and SharePoint
FREE
Power BI and SharePoint Introduction
Using Power Query
Using Power View
Using Power Map
Publishing on Office 365
Publishing on SharePoint
Creating Reports and KPI
Creating Reports and KPI
FREE
Using KPI in Power Pivot
FREE
Advanced Excel Features for Power Pivot
Optimizing the User Experience with the Data Model
Advanced DAX Concepts
Advanced DAX Concepts
FREE
Important DAX Concepts
Filter Context
CALCULATE
Row Context
Evaluation Contexts and Relationships
Context Transition
ALLSELECTED
Advanced DAX Functions
Advanced DAX Functions
FREE
Advanced DAX Functions and Patterns
RANKX
KEEPFILTERS
Semi Additive Measures
Event in Progress
Calculations Over Weeks
DAX as a Query Language
DAX as a Query Language
FREE
Basic DAX Query Functions
Linked-Back Tables in Excel
Advanced DAX Query Functions
DAX Patterns
DAX Patterns
FREE
DAX Patterns Introduction
Banding
ABC / Pareto Analysis
Parent-Child Hierarchies
Compare Budget and Sales
Additional Material and Sample Files
Download Sample Files
FREE
Student Rating
4-star Reviews (3 of 10)
Morris Muthubi (Apr 14, 2020) This was a well-outlined class. I look forward to finishing the definitive guide. I love Marco's teaching style and I look forward to more interaction. Worth the money and time
Kenneth Barber (Dec 4, 2019) This course has aged surprisingly well. However, some parts of this course are no longer relevant. SQLBI's Mastering DAX course largely supersedes this course, and I would recommend that most people take Mastering DAX instead.
Marshall Joubert (Jun 17, 2019) Despite covering a previous version of Excel, the material was still relevant.
What is included
This video course contains 10 hours of training, for a total of 87 lectures.
Our training platform tracks your progress and resumes the course from where you left off.
The course is accessible on desktop and mobile browsers for
36 months after the purchase date .
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
After completing all the lectures in this video course,
you will be able to download a certificate of completion in PDF format from your student dashboard.
Options
Volume discounts are offered when you purchase multiple courses within one same order. To obtain the discount, just press the
Enroll Now button and add more courses or students in the next step. The discount cannot be applied to transferable licenses.
Amount
Discount
$ 40010% $ 80015% $ 100020% $ 400025%
You can get a group discount by registering 10 or more students to the same course. To obtain the discount, just press the
Enroll Now button and add more students in the next step.
Students
Discount
10+ 25% 25+ 30% 50+ 40% 100+ 50% 200+ 65% 300+ 70% 350+ 72%
This video course is also available with a transferable license, which is a convenient solution for teams.
License type
Price
Duration
Student(s)
Untransferable
$ 99
36 months
1
Transferable
$ 390
36 months
Unlimited *
* The number of concurrent access reflects the number of licenses you have purchased. E.g. If you have a single transferable license, only one student can access the course at a time. To give another student access to the course, you must revoke the access and assign the license to the different student.
More on licenses
A team management dashboard is available if you choose to assign this course after the purchase or you get a
transferable license .
Use this tool to assign your licenses and monitor the study progress of your team.
Training Platform
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.
Learn more
Save the most interesting lectures for future use and easy access with bookmarks.
Press the marker button in every lecture and check the Bookmarks tab.
Learn more
You can highlight segments of the video transcripts, like you would with a printed book. Highlights are automatically saved and quickly accessible from your Bookmarks tab.
Learn more
In every section of this course, you will find an easy way to start a discussion about a topic relevant to the course.
Our team usually replies within a few hours!
Learn more