Master DAX fundamentals : Power BI, Power Pivot & SSAS

Master DAX fundamentals : Power BI, Power Pivot & SSAS, available at $44.99, has an average rating of 4.75, with 47 lectures, based on 880 reviews, and has 4166 subscribers.

You will learn about 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 This course is ideal for individuals who are Analysis Services Users or Power BI Users or Excels Power Pivot Users or Those that need to model data using SSAS, Power BI or Power Pivot or Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting or This course is NOT for you if you are already comfortable working with basic and intermediate level DAX It is particularly useful for Analysis Services Users or Power BI Users or Excels Power Pivot Users or Those that need to model data using SSAS, Power BI or Power Pivot or Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting or This course is NOT for you if you are already comfortable working with basic and intermediate level DAX.

Enroll now: Master DAX fundamentals : Power BI, Power Pivot & SSAS

Summary

Title: Master DAX fundamentals : Power BI, Power Pivot & SSAS

Price: $44.99

Average Rating: 4.75

Number of Lectures: 47

Number of Published Lectures: 47

Number of Curriculum Items: 47

Number of Published Curriculum Objects: 47

Original Price: $189.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Master DAX fundamentals : Power BI, Power Pivot & SSAS

Lecture 1: Introduction

Lecture 2: How to take this course

Lecture 3: Before you forget

Chapter 2: DAX (Data Analysis Expression) An Introduction

Lecture 1: What is DAX

Lecture 2: Calculated Columns and Measures

Lecture 3: SUM and SUMX

Lecture 4: Count and CountX

Lecture 5: Currency Data Type and the need to ROUND in DAX

Lecture 6: DAX DIVIDE expression

Lecture 7: When you need a BLANK for the right data type

Lecture 8: Related and Related Table

Lecture 9: MIN and MAX

Lecture 10: Other Expressions

Lecture 11: IF Statements

Lecture 12: Conditional statement (AND OR and IN)

Lecture 13: Classification columns using AND OR and IN

Lecture 14: DAX Variables

Lecture 15: DAX SWITCH expression

Lecture 16: Working with Text in DAX

Lecture 17: Section Wrap up

Lecture 18: Section 1 Activities

Chapter 3: How DAX works

Lecture 1: How DAX works

Lecture 2: Table Functions

Lecture 3: Ignore Filters

Lecture 4: Combining Table Functions

Lecture 5: Nested Row Context

Lecture 6: Calculate

Lecture 7: More on Calculate

Lecture 8: DAX and Relationships

Lecture 9: Section 2 Wrap up

Lecture 10: Section 2 Activity

Chapter 4: Time Intelligence Functions

Lecture 1: Introduction to Time Intelligence

Lecture 2: Creating a Date Table

Lecture 3: Multiple Date Tables

Lecture 4: Marking a Date Table

Lecture 5: Year to Date Calculations

Lecture 6: How Time Intelligence Works

Lecture 7: Looking Back in Time

Lecture 8: Datesadd

Lecture 9: Parallel Periods

Lecture 10: Moving Totals

Lecture 11: Overall Total

Lecture 12: Time Intelligence conclusion

Lecture 13: Section 3 Activities

Chapter 5: Conclusion

Lecture 1: Course Conclusion

Lecture 2: Thank you and bonus

Lecture 3: Bonus

Instructors

Paula Guilfoyle CPA
CPA Accountant, & Life Long Learner

Rating Distribution

1 stars: 17 votes
2 stars: 39 votes
3 stars: 167 votes
4 stars: 321 votes
5 stars: 336 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu