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
Getting Started with Microsoft Power BI
Power BI is a new software product from Microsoft that helps you find meaning in your …
book
Exam Ref DA-100 Analyzing Data with Microsoft Power BI
Prepare for Microsoft Exam DA-100 and help demonstrate your real-world mastery of Power BI data analysis …
book
Mastering Microsoft Power BI
Design, create and manage robust Power BI solutions to gain meaningful business insights Key Features Master …
video
Master in Microsoft Power BI Desktop and Service
Power BI is a business intelligence tool by Microsoft that provides analytics services. It provides interactive …