Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

Mastering the Power BI Key Fundamentals

person icon Packt Publishing

4.5

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 Jul, 2024

language icon Language - English

person icon Packt Publishing

English [CC]

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

Lectures -17

Duration -2 hours

4.5

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

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.
Mastering the Power BI Key Fundamentals

Curriculum

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


Course Certificate

Use your certificate to make a career change or to advance in your current career.

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
Annual Membership

Online Certifications

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

Explore Now
Online Certifications

Talk to us

1800-202-0515