Mastering Intermediate DAX – Power BI, Power Pivot & SSAS
Mastering Intermediate DAX – Power BI, Power Pivot & SSAS, available at $54.99, has an average rating of 4.15, with 30 lectures, based on 430 reviews, and has 3544 subscribers.
You will learn about Carry out difficult DAX expressions in Power BI, Power Pivot and SSAS Have the ability to modify the current filter context with DAX expressions Have the ability to modify how totals and subtotals are shown Explain and work with Context Transition in DAX Work with hierarchies and related functions Calculate different moving averages without using Time Intelligence functions Work with advanced calculations using iterators Understand Bidirectional filters Advanced relationships and UseRelationship 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 intermediate or advanced 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 intermediate or advanced level DAX.
Enroll now: Mastering Intermediate DAX – Power BI, Power Pivot & SSAS
Summary
Title: Mastering Intermediate DAX – Power BI, Power Pivot & SSAS
Price: $54.99
Average Rating: 4.15
Number of Lectures: 30
Number of Published Lectures: 30
Number of Curriculum Items: 33
Number of Published Curriculum Objects: 33
Original Price: $79.99
Quality Status: approved
Status: Live
What You Will Learn
- Carry out difficult DAX expressions in Power BI, Power Pivot and SSAS
- Have the ability to modify the current filter context with DAX expressions
- Have the ability to modify how totals and subtotals are shown
- Explain and work with Context Transition in DAX
- Work with hierarchies and related functions
- Calculate different moving averages without using Time Intelligence functions
- Work with advanced calculations using iterators
- Understand Bidirectional filters
- Advanced relationships and UseRelationship
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 intermediate or advanced 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 intermediate or advanced 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 AnalysiseXpressions.
This is a hands on course
Course Overview
In the First section of this course you will refresh the fundamentals of how DAX works. as this section is a refresher section we will work through example rather fast.. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.
The aim of section 2 is to introduce you to some DAX functions that we will be working with in more detail later in this course. Many of the functions and expressions we will use in this section allow you alter or amend how totals and subtotals are shown. Functions covered will include ISFILTERED, ISCROSSFILTERED, ALLSELECTED, HASONEVALUE and SELECTEDVALUES
In Section 3 we will look in dept at CALCULATE and Contest Transition. You will learn when to use FILTER inside CALCULATE and also when it is useful to combine CALCULATE and VALUES.
Section 4 is packed with Case Studies. We will look at different problems and the solutions. The first case study will focus on parent-child-hierarchy and include functions such as PATH and PATHLENGHT. The second case study will look at different Moving Averages using EARLIER, FILTER, VALUES and AVERAGE. In the third case study we will look at the use of Iterator functions over different granularities.
Finally you will learn about about advanced relationships. We will look at BI Directional Filters and the use of USERELATIONSHIP
Each section of this course contains a folder to download. The folder contains the examples shown in the course and also activities for you to complete. These Activities are of utmost importance. When it comes to learning DAX, practice is a must.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: Downloads for this section
Lecture 3: The Basics Recap 1
Lecture 4: The Basics Recap 2
Lecture 5: How to take this course
Lecture 6: Don't forget
Chapter 2: Section 2 More DAX Expressions
Lecture 1: Section 2 Intro
Lecture 2: Section Downloads
Lecture 3: ISFiltered and ISCrossfilter
Lecture 4: ALLSelected
Lecture 5: HasOneValue
Lecture 6: SelectedValues
Chapter 3: More Complex uses of Calculate
Lecture 1: Section Overview
Lecture 2: Section Downloads
Lecture 3: When to use Filter inside Calculate
Lecture 4: Using Values with Calculate
Lecture 5: Context transition
Lecture 6: Context transition 2
Lecture 7: More complex context transition issues
Chapter 4: Case Studies
Lecture 1: Section Introduction
Lecture 2: Section Activities and Downloads
Lecture 3: hierarchies – case study 1- the problem
Lecture 4: hierarchies – case study 1- the solution
Lecture 5: Moving Averages – case study 2 – the problem
Lecture 6: Moving Averages – case study 2 – the solution
Lecture 7: Iterators – case study 3 – the problem
Lecture 8: Iterators – case study 3 – the solution
Lecture 9: Course Conclusion
Lecture 10: Bonus
Lecture 11: Bonus Material
Instructors
-
Paula Guilfoyle CPA
CPA Accountant, & Life Long Learner
Rating Distribution
- 1 stars: 10 votes
- 2 stars: 22 votes
- 3 stars: 80 votes
- 4 stars: 133 votes
- 5 stars: 185 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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024