Power Pivot Workshop Intermediate
4.7 (34 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
84 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Power Pivot Workshop Intermediate to your Wishlist.

Add to Wishlist

Power Pivot Workshop Intermediate

Learn the DAX language to improve Power Pivot models and publish them on Power BI or SharePoint.
4.7 (34 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
84 students enrolled
Last updated 12/2014
English
Price: $70
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of the course, you will be able to write DAX expressions performing calculations such as Ratio-to-Parent, Year-to-Date, Year-Over-Year and so on.
View Curriculum
Requirements
  • Power Pivot for Excel 2010 or Excel 2013
Description

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 course includes 3 hours of video in 19 lectures. You need a minimal experience of Power Pivot, or you should take the Beginner course before this one.

Sections included in this 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.

Who is the target audience?
  • Advanced Excel Users
  • Business Analysts
  • Business Intelligence Developers
  • Data Scientists
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 21 Lectures Collapse All 21 Lectures 03:04:48
+
DAX Language
4 Lectures 55:45

DAX is the programming language of Power Pivot. This module provides the basic information to understand what a DAX expression is and how to start writing your DAX code.

Preview 13:37

It is important to learn when to use calculated columns versus calculated fields. They are useful in different scenario. In this lecture, we highlight the differences between them, and clarify when to choose one or the other.

Calculated Columns and Calculated Fields
19:01

Your formulas can contain errors, due to bad or unexpected data. In this lecture, you learn how to prevent errors in data that might break your reports.

DAX Error Handling
04:17

This lecture shows some examples of most of the categories of DAX functions, which we will use extensively in the following lectures.

Overview of DAX Functions
18:50
+
Table Functions and CALCULATE
4 Lectures 38:45

In this lecture, you learn the RELATED and the RELATEDTABLE functions. Both are useful to navigate through relationships and evaluate expression over them. We also introduce the concept of table functions, i.e. functions that return tables.

RELATED and RELATEDTABLE functions
10:55

FILTER and ALL are the most commonly used table functions, and you will learn when and how to use them.

Preview 12:40

CALCULATE is a powerful function, useful in many calculations. This lecture explains the basic functionality of CALCULATE.

CALCULATE function
11:12

Do you want to compute the percentage of a cell in a PivotTable against the visible total, in case a slicer filters data? Then ALLSELECTED is the function for you.

Visual Totals and ALLSELECTED
03:58
+
Basic Time Intelligence
5 Lectures 44:02

Year-To-Date, Month-To-Date, Comparison of sales in the current period compared with the same period in the previous year. All this is what we refer to as “time intelligence”, which is the topic introduced in this lecture.

What is Time Intelligence
04:51

Before using Time Intelligence functions, you have to build a good calendar table. This lecture shows how to do that, avoiding common mistakes.

Calendar Table
16:14

Calculation of working days difference between two dates, calculation of sales per working days: these are just two examples of the kind of calculations explained in this lecture.

Counting Working Days
05:49

If your data models includes more date, such as ship date and order date, you have to adapt the data model, for example by creating more calendar tables. This lecture shows how to do that in the right way.

Multiple Calendar Tables
05:10

This lecture provides an in-depth explanation of Year-To-Date, Month-To-Date, comparison of sales with the same period in the previous year, and other similar Time Intelligence calculations.

Aggregations Over Time
11:58
+
Power BI and SharePoint
6 Lectures 44:36

This lecture introduces a deeper explanation of the features available in Power BI and SharePoint to publish Power Pivot workbooks.

Power BI and SharePoint Introduction
02:54

Power Query will quickly become your best friend whenever it is time to load data. It is extremely powerful and easy to use as a data management tool inside Excel.

Using Power Query
14:52

It is impossible to describe the experience of using Power View. You need to try it by yourself. This lecture shows how to get the best out of Power View and how to shape your data in the correct way, improving the user experience navigating data.

Using Power View
10:09

Power Map is a gorgeous tool to create stories about data showing them on maps. You can create great presentations by coloring areas based on data values and by building entire movies about your data.

Using Power Map
04:49

This lecture explains how to publish your data to the Office 365 platform, sharing reports with colleagues and stakeholders using a simple internet browser.

Publishing on Office 365
07:17

This lecture shows how to publish your data to SharePoint. This is useful if your company adopted SharePoint as a collaboration tool and installed Power Pivot for SharePoint.

Publishing on SharePoint
04:35
+
Conclusion
1 Lecture 00:20
Intermediate Course Conclusion
00:20
+
Additional Material
1 Lecture 01:05

Instructions to download sample database and files.

Download Sample Files
01:05
About the Instructor
Marco Russo
4.3 Average rating
999 Reviews
13,745 Students
4 Courses
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.

Alberto Ferrari
4.3 Average rating
999 Reviews
13,745 Students
4 Courses
Business Intelligence expert at SQLBI - SSAS Maestro & MVP

Alberto is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 2005 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.

Alberto is also a book author and wrote two books for Microsoft Press about Power Pivot with Marco Russo: 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.