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
Business,Business Analytics & Intelligence,Microsoft Power BI
Lectures -17
Duration -2 hours
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.
![Mastering the Power BI Key Fundamentals Mastering the Power BI Key Fundamentals](https://d3mxt5v3yxgcsr.cloudfront.net/courses/8565/course_8565_image.jpg)
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](https://www.tutorialspoint.com/assets/profiles/154467/profile/200_283401-1581924256.png)
Packt Publishing
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
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![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)