Mastering the Power BI Key Fundamentals

person icon Packt Publishing

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

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Packt Publishing

architecture icon Business,Business Analytics & Intelligence,Microsoft Power BI


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint 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


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.


What will you learn in this course:

  • 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


What are the prerequisites for this course?

  • Prior experience with Power BI and DAX is required. Advance-level knowledge based on Power BI would be helpful but not mandatory.
Mastering the Power BI Key Fundamentals


Check out the detailed breakdown of what’s inside the course

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

Instructor Details

Packt Publishing

Packt Publishing

Founded in 2004 in Birmingham, UK, Packt's mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals.

Working towards that vision, we have published over 6,500 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done - whether that's specific learning on an emerging technology or optimizing key skills in more established tools.

As part of our mission, we have also awarded over $1,000,000 through our Open Source Project Royalty scheme, helping numerous projects become household names along the way.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us