Master DAX Fundamentals : Power BI & Power Pivot

The Fundamentals of Data Analysis and Modeling with DAX for Power BI, Power Pivot and Analysis Services

Description


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

Analyse 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




Intended Audience: those involved in Data Modelling, Those Involved in Reporting, Those that wish to upskill in Power Pivot, those that wish to model data using Power BI or Power Pivot, Excel Users, SSAS users

Course Material
What is DAX
Calculated Columns and Measures
SUM and SUMX
COUNT and COUNTX - Fully understanding Columns and Measures
Working with the data type Currency and ROUND
DAX DIVIDE Expression
Dealing with BLANK()
RELATED and RELATEDTABLE
MIN and MAX
Other Function/Iterator Pairs
TEXT in DAX
DAX IF Statements
DAX Variables
SWITCH in DAX
Section 1 Activity
Section 1 Conclusion
How DAX Works
Table Functions
Ignore Table Functions
Combine Table Functions
Nested Row Context
CALCULATE
More on CALCULATE
DAX and Relationships
Section 2 Wrap up and Activity
Section 2 Activity files
Introduction to Time Intelligence
DAX to create a date table
Multiple DATE columns
Marking a DATE table
Year to date calculations
How Time Intelligence Works
Looking Back in Time
DATESADD
Parallel Periods
Moving Totals
Overall Totals
Time Intelligence Conclusion
Section 3 Activities
Course Conclusion
Course Bonus
Bonus Links

What's included

  • 38 Video Lessons
  • 5 Text Lessons

  • Works on all devices
  • Certificate of completion

Paula Guilfoyle

Instructor

My Name is Paula, and I am a qualified CPA with over 15 years’ experience in Accounting and Business. I have worked across a broad range of industries and levels of seniority. During this time I used Excel as my spreadsheet tool of choice, attending many courses and regularly updating my skills. It was my love for Excel that started my journey as an e-learning educator. As a manager and an Accountant, I noticed a skills gap amount Accountants and finance staff in Excel. In 2010 I launched www.theexcelclub.com with 1 course aimed at this market. I am now author and presenter of many online courses and can boast that I have thought over 10,000 students!

In addition to being an Accountant and an Online Educators I am also a wife and a mother of two, my youngest is 2 and eldest is 7. I currently work as an Accountant for a global company, which makes family life very very busy. I am always stuck for time, and finding a balance is very difficult. I’m sure all working parents understand the pressures involved.