Mastering the Power BI Key Fundamentals

This course teaches the fundamental concepts of DAX in Power BI. If you have the questions: How do I learn DAX? What is the best way to learn DAX fast?—then this is the best course for you. This course teaches fundamental concepts and does not cover visualization or various advanced DAX patterns for specific questions.

24 on-demand videos & exercises

Level: Beginner

English

2hrs 27mins

Access on mobile, web and TV

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. Prior experience with Power BI and DAX is required.

Advance-level knowledge based on Power BI would be helpful but not mandatory.

Course Curriculum

About the Author

Dave Murphy - With over twenty years of experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the world’s largest companies, Dave Murphy changed his career track in 2000 and has been a professional university educator for over 20 years. Dave is currently a lecturer in business information systems at the Technological University, Dublin. His main interests are in Microsoft certifications, project management, and business process analysis. Dave has a bachelor’s in science (Hons) from Trinity College, Dublin, and a master’s degree in computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in managing projects with Microsoft Project, is a MOS Master, and also a MOS examiner.