Mastering the Power BI Key Fundamentals
Power BI DAX row context, filter context, context transition, DAX iterators, expanded tables in Power BI and master the key concepts
Development ,Data Science,Data Analysis
Lectures -17
Duration -2 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Business intelligence/business analytics is in high demand. Companies are constantly searching for ways to make better and faster and smarter decisions. Therefore, they rely heavily on data. Small company or multinational - data-driven decision making is the key to success for any business in the world of tomorrow.
Because of this, companies are drastically increasing to step up their efforts to find skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights.
Therefore, Power BI as the leading BI tool from Microsoft is in remarkably high demand. When we want to do calculations in Power BI, we need DAX (Data Analysis Expressions).
Here, we explore all the DAX fundamental key concepts. You will start with looking at row context, followed by iterators. After that, you will look at filter context and context transition. Finally, you learn about the expanded tables.
By the end of this course, you will learn the fundamental key concepts of DAX in Power BI to do your data analysis work. You can repeat the concepts from time-to-time and master your DAX journey.
All the resource files are uploaded on the GitHub repository at https://github.com/PacktPublishing/Mastering-the-Power-BI-Key-Fundamentals
Audience
This course is designed for students who want to master Power BI DAX and understand key concepts in DAX. Individuals who want to become a better Power BI developer, a data analyst, and those who want to follow this career path will also get benefitted from this course. Data scientists who want to use Power BI and business users who work with Power BI and need to create DAX calculations will gain a lot as well.
Goals
- Look at the fundamentals of Power BI DAX concepts
- Learn Row Context in Power BI
- Understand filter context in Power BI
- Explore iterators in Power BI
- Look at context transition in Power BI
- Learn expanded tables in Power BI
Prerequisites
- Prior experience with Power BI and DAX is required. Advance-level knowledge based on Power BI would be helpful but not mandatory.

Curriculum
Check out the detailed breakdown of what’s inside the course
Power BI DAX Fundamentals to Mastering
17 Lectures
-
Introduction to Power BI Fundamentals Key Concepts 01:24 01:24
-
Setting Up the Data Model 06:08 06:08
-
Few Insights 05:30 05:30
-
Row Context Explained Deep Dive 10:12 10:12
-
Iterators in Power BI Deep Dive - Part 1 08:31 08:31
-
Iterators in Power BI Deep Dive – Part 2 14:09 14:09
-
Cleaning Up the Measure 02:24 02:24
-
Filter Context in Power BI 04:25 04:25
-
Filter Context in Power BI Deep Dive – Part 1 12:50 12:50
-
Filter Context in Power BI Deep Dive - Part 2 06:36 06:36
-
Calculate and Filter Context in Power BI Deep Dive - Part 3 07:48 07:48
-
Filter Context in Power BI Deep Dive – Part 4 17:03 17:03
-
Context Transition in Power BI 11:28 11:28
-
Context Transition with Different Levels or Granularity 10:15 10:15
-
Context Transition - What to be Aware Of 09:53 09:53
-
Expanded Tables in Power BI 18:03 18:03
-
Final Words and Important Reminder 00:51 00:51
Instructor Details

Packt Publishing
Packt are an established, trusted, and innovative global technical learning publisher, founded in Birmingham, UK with over eighteen years experience delivering rich premium content from ground-breaking authors and lecturers on a wide range of emerging and established technologies for professional development.
Packt’s purpose is to help technology professionals advance their knowledge and support the growth of new technologies by publishing vital user focused knowledge-based content faster than any other tech publisher, with a growing library of over 9,000 titles, in book, e-book, audio and video learning formats, our multimedia content is valued as a vital learning tool and offers exceptional support for the development of technology knowledge.
We publish on topics that are at the very cutting edge of technology, helping IT professionals learn about the newest tools and frameworks in a way that suits them.
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now