Power Pivot Workshop Intermediate

Learn the DAX language to improve Power Pivot models and publish them on Power BI or SharePoint.
4.7 (30 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.
74 students enrolled
$70
Take This Course
  • Lectures 21
  • Contents Video: 3 hours
    Other: 1 min
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2014 English

Course 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.

What are the requirements?

  • Power Pivot for Excel 2010 or Excel 2013

What am I going to get from this course?

  • 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.

What is the target audience?

  • Advanced Excel Users
  • Business Analysts
  • Business Intelligence Developers
  • Data Scientists

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: DAX Language
13:37

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.

19:01

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.

04:17

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.

18:50

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

Section 2: Table Functions and CALCULATE
10:55

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.

12:40

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

11:12

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

03:58

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.

Section 3: Basic Time Intelligence
04:51

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.

16:14

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

05:49

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.

05:10

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.

11:58

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.

Section 4: Power BI and SharePoint
02:54

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

14:52

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.

10:09

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.

04:49

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.

07:17

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

04:35

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.

Section 5: Conclusion
Intermediate Course Conclusion
00:20
Section 6: Additional Material
Article

Instructions to download sample database and files.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Marco Russo, 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.

Instructor Biography

Alberto Ferrari, 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.

Ready to start learning?
Take This Course