Master DAX fundamentals : Power BI, Power Pivot & SSAS
4.3 (68 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.
743 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master DAX fundamentals : Power BI, Power Pivot & SSAS to your Wishlist.

Add to Wishlist

Master DAX fundamentals : Power BI, Power Pivot & SSAS

The Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis Services
Best Seller
4.3 (68 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.
743 students enrolled
Created by Paula Guilfoyle
Last updated 9/2017
English
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 5 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Explain and use Calculated Columns and Measures
  • Explain and use aggregation functions and expressions in DAX such as SUM and COUNT
  • Explain and use table functions such as Filter and RelatedTable
  • Explain and use iteration pairs such as SUMX and COUNTX
  • Set up Variables
  • Work with IF statements and DAX SWITCH function
  • Describe the fundamentals of how DAX works
  • Explain Row context and nested Row context
  • Explain Filter context
  • Use the ALL function to remove filters
  • Use the Calculate function to modify and replace basic filters
  • Explain and demonstrate how Relationships and DAX work together
  • Discuss the need for a DATE table
  • Use DAX to create a DATE table using CalendarAuto and other DAX functions
  • Use and explain Time Intelligence Functions such as TOTALTYD, SAMEPERIODLASTYEAR and more
  • Calculate Moving totals and Rolling Totals
  • Carry out Basic to Intermediate level DAX analysis
View Curriculum
Requirements
  • You should be familiar with either Power Pivot, Power BI or Analysis Services
  • You should have a want to learn DAX (Data Analysis Expressions)
  • Have an interest in Data Modeling
Description

Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.

Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpressions.

This is a hands on course

Course Overview

In the first section of this course you will be introduced to the use of the most common DAX expressions, such as SUM and SUMX, COUNT, ROUND, DIVIDE, MIN, MAX, IF Statements, TEXT expressions, Variables and More

In the next section of this course you will learn the fundamentals of how DAX works.  This section will include both theory and examples and it is of utmost importance that you understand how DAX works. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.

In the third section of this course you will learn about Time Intelligence and Date Tables. We will look at expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and we will explore how many of these functions work using CALCULATE

Each section of this course contains Activities to complete. These Activities are of utmost importance.  When it comes to learning DAX, practice is a must.

Who is the target audience?
  • Analysis Services Users
  • Power BI Users
  • Excels Power Pivot Users
  • Those that need to model data using SSAS, Power BI or Power Pivot
  • Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting
  • This course is NOT for you if you are already comfortable working with basic and intermediate level DAX
Students Who Viewed This Course Also Viewed
Curriculum For This Course
44 Lectures
02:50:31
+
Master DAX fundamentals : Power BI, Power Pivot & SSAS
2 Lectures 03:32

A quick introduction to this course Master DAX Fundamentals: Power BI, Power Pivot and SSAS

Preview 02:03

Please read the attached as it contains important information on how to take this course to get the most out of it

How to take this course
01:29
+
DAX (Data Analysis Expression) An Introduction
16 Lectures 01:09:11

A brief history and overview of Data Analysis Expressions (DAX)

Preview 04:43

There are two types of calculations in DAX.  Calculated Columns and Measures.  We will look at both of these in this video

Calculated Columns and Measures
01:56

learn about SUM and SUMX, be introduced to RELATED and iterators

SUM and SUMX
09:59

learn COUNT and COUNTX and see how calculated columns and measures differ, and learn when it is best to use each

Preview 10:59

When working with the Data type Currency in DAX, you need to ensure that all of the values are to the correct decimal place, for this you can use ROUND

Currency Data Type and the need to ROUND in DAX
01:19

the DAX DIVIDE function will allow you deal with errors when dividing one value by another,  Learn how to use DIVIDE in this video.

DAX DIVIDE expression
04:17

Are you familiar with the use of "" to get a blank in Excel?  Well in DAX you need to use the BLANK expression to ensure that your blank is of the correct data type

When you need a BLANK for the right data type
01:42

Related and related table will allow you take values from tables joined by relationships.  In this video you will be introduced to related table and will we will at related in more detail

Related and Related Table
06:11

If you are looking for the minimum value or the maximum value then DAX MIN and MAX expressions are required.  This video includes the updated DAX syntax for MAX in versions 2016 and after, as well as the original syntax.

MINX and MAXX are also covered in this video

MIN and MAX
02:58

In this video you will be introduced to a number of iterators and pairs

Other Expressions
01:19

learn how to carry out an IF statement in DAX

IF Statements
04:38

Learn how to create a Variable to be used in DAX functions and expressions

DAX Variables
04:24

Learn how you can use the DAX SWITCH expression to replace nested IF statements

DAX SWITCH expression
04:04

There are many TEXT expressions available in DAX, Expressions that will also you format, clean and extract data from TEXT.  In this video we will cover many of these TEXT expressions

Working with Text in DAX
09:19

An overview of section 1.

Section Wrap up
01:10

Section 1 Activities
00:13
+
How DAX works
9 Lectures 44:58
How DAX works
07:34

Table Functions
07:06

Ignore Filters
06:56

Combining Table Functions
02:57

Learn to use DAX EARLIER expression 

Nested Row Context
06:22

CALCULATE is known as one of the most powerful functions in DAX.  Find out why in this video

Calculate
08:36

Learn to use CALCULATE with two filters

More on Calculate
03:30

Section 2 Wrap up
01:34

Section 2 Activity
00:23
+
Time Intelligence Functions
13 Lectures 44:25

a quick overview of what to expect in this section on DAX Time Intelligence

Introduction to Time Intelligence
01:29

learn how to use DAX to create a DATE table, which is used for time intelligence functions

Creating a Date Table
04:45

Learn how to address multiple date columns and tables when using DAX

Multiple Date Tables
04:41

in some user interfaces you need to mark a date table as a date table. Don't forget to do this

Marking a Date Table
00:58

In this video you will learn how to use DAX TOTALYTD, TOTALQTD and TOTALMTD expressions

Year to Date Calculations
09:31

Following on from the previous lesson, in this video you will learn how these time intelligence functions work using Calculate.

How Time Intelligence Works
05:20

Sometimes you need to show same period last year, with dax time intelligence this is rather easy

Looking Back in Time
03:42

learn more about how time intelligence works using datesadd

Datesadd
04:41

Parallel Periods
02:16

Moving Totals
03:09

Learn how to calculate the overall total ignoring any time period

Overall Total
02:54

Time Intelligence conclusion
00:36

Section 3 Activities
00:23
+
Conclusion
4 Lectures 08:57
Course Conclusion
00:59

Thank you and bonus
01:37

Bonus
01:08

DAX and Relationships
05:13
About the Instructor
Paula Guilfoyle
4.3 Average rating
1,593 Reviews
22,915 Students
19 Courses
CPA Accountant, Online Educator & Life Long Learner

Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.