Video 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.
What You Will Learn
- 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
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.
Prior experience with Power BI and DAX is required. Advance-level knowledge based on Power BI would be helpful but not mandatory.
About The Author
Dan We: Daniel Weikert is a 33-year-old entrepreneur, data enthusiast, consultant, and trainer. He is a master’s degree holder certified in Power BI, Tableau, Alteryx (Core and Advanced), and KNIME (L1–L3).
He is currently working in the business intelligence field and helps companies and individuals obtain vital insights from their data to deliver long-term strategic growth and outpace their competitors.
He has a passion for learning and teaching. He is committed to supporting other people by offering them educational services and helping them accomplish their goals, gain expertise in their profession, or explore new careers.
Table of contents
-
Chapter 1 : Power BI DAX Fundamentals to Mastering
- Introduction to Power BI Fundamentals Key Concepts
- Setting Up the Data Model
- Few Insights
- Row Context Explained Deep Dive
- Iterators in Power BI Deep Dive - Part 1
- Iterators in Power BI Deep Dive – Part 2
- Cleaning Up the Measures
- Filter Context in Power BI
- Filter Context in Power BI Deep Dive – Part 1
- Filter Context in Power BI Deep Dive - Part 2
- Calculate and Filter Context in Power BI Deep Dive - Part 3
- Filter Context in Power BI Deep Dive – Part 4
- Context Transition in Power BI
- Context Transition with Different Levels or Granularity
- Context Transition - What to be Aware Of
- Expanded Tables in Power BI
- Final Words and Important Reminder
Product information
- Title: Mastering the Power BI Key Fundamentals
- Author(s):
- Release date: December 2021
- Publisher(s): Packt Publishing
- ISBN: 9781803247922
You might also like
video
Power BI Masterclass 2023
Welcome to the Power BI masterclass! This masterclass course is designed to equip you with the …
video
Power BI Masterclass - Beginners to Advanced
Companies are constantly searching for ways to make better and faster decisions. Therefore they rely heavily …
video
Exam AZ-900: Microsoft Azure Fundamentals (Video), 2nd Edition
5 Hours of Video Instruction Includes coverage of the November 2020 exam updates! Prepare for Microsoft …
video
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of …