Power Bi Dax Online Course

When it comes to mastering the Data Analysis Expressions (DAX) programming language, online courses can provide a practical and convenient solution. With a myriad of options available on the internet, it can be challenging to choose the best course that suits your learning needs. This article aims to provide a neutral overview of the top-rated DAX courses available online. By exploring the key features, course structure, and learning objectives, readers can make informed decisions when selecting the most suitable DAX course to achieve their data analysis goals.

Here’s a look at the Best Dax Courses and Certifications Online and what they have to offer for you!

Power Bi Dax Online Course

1. Microsoft Power BI DAX from Scratch by Learnsector LLP, Navya Kannan (Udemy) (Our Best Pick)

The Microsoft Power BI DAX from Scratch course offered by Learnsector LLP and Navya Kannan aims to provide a hands-on guide to using DAX functions for advanced reporting in Power BI. DAX, or Data Analysis Expression, is a library of functions and operators that can be used to create formulas and expressions. This course is designed in a Problem Statement – Solution format where each component of the DAX expression is explained in easy-to-understand terms.

The course covers the concepts of DAX and how to create calculate column, measure, tables, and quick measures. Participants will learn about the most frequently used functions from the family of Date and Time, Text, Logical, Relationship, X, Filter, Statistical, Time Intelligence, Information, and Table Manipulation functions. The course is divided into 10 sections and begins with an Introduction.

Throughout the course, participants will gain a better understanding of DAX and how to use it to create powerful formulas for data analysis and reporting. By the end of the course, participants should be able to use DAX functions to unlock the advanced power of reporting in Power BI.

2. Power BI DAX secrets – (Learn DAX formulas for Power BI) by Data Chunks (Udemy)

The Power BI DAX secrets course, taught by Data Chunks, is a complete training program that covers the basics and advanced concepts of the Data Analysis Expressions (DAX) formula language in Microsoft Power BI. DAX is a collection and combination of functions, operators, and constants used for data analysis and calculations in BI tools like Power BI.

Learning DAX is essential for building dynamic dashboards, as it is used in Power BI desktop, SQL Server Analysis Services (Tabular mode), and Microsoft Excel. Understanding the core concepts of DAX is crucial, as it is the soul of Power BI. The two types of contexts, filter context and row context, work together to evaluate DAX expressions.

DAX is an easy language to write but can be difficult to grasp initially. This course covers the underlying theory of DAX and its core concepts, with every topic explained before implementation. Students will learn the secrets of DAX, including error handling and variables, family of All() functions, ranking and filter propagation, special filtering and selection, context transition, time intelligence, and advanced functions in DAX.

The instructor, Muhammad Asif, is a Microsoft certified solutions expert in data management and analytics with over ten years of experience in the Microsoft BI stack. The course content is divided into 10 sections, starting with an introduction to DAX and ending with advanced functions in DAX. Students will gain hands-on experience in using DAX formulas for data analysis and calculations.

3. Advanced DAX for Microsoft Power BI Desktop by Maven Analytics, Aaron Parry (Udemy)

The Advanced DAX for Microsoft Power BI Desktop course, instructed by Maven Analytics and Aaron Parry, focuses on mastering the Data Analysis Expressions (DAX) language and building advanced Power BI and data analysis skills. The course is hands-on and project-based, with real-world business intelligence use cases where users can apply their DAX skills to analyze product inventory, repeat customers, store-level performance, and more. The course covers prerequisite topics, DAX engines, tips and best practices, scalar functions, advanced CALCULATE, table and filter functions, calculated table joins, relationship functions, iterator functions, advanced time intelligence, and performance tuning.

The course starts with reviewing core DAX concepts such as evaluation context, filter flow, and measures. Then, users will be introduced to the Maven Roasters course project and build the data model for analysis in Power BI Desktop. The course dives into DAX engines, formula, and storage engines, as well as data types, VertiPaq encoding and compression methods. Users will also learn helpful tips for formatting DAX queries, adding comments, handling errors, and using DAX variables.

The course covers common scalar functions such as rounding, information, conversion, and logical functions, and advanced CALCULATE modifiers, context transition, and interactions with tables. Users will also learn to create calculated tables, review common DAX filter functions, generate new data, and create calculated joins between physical and virtual tables in Power BI (UNION, EXCEPT, INTERSECT, etc.). The course explores expanded tables, physical and virtual relationships, common relationship functions, iterator cardinality, nested iterators, context transition, RANKX, DAX calculation granularity, etc. Users will also learn to build date tables with DAX, compare custom time periods, and manage fiscal calendars.

4. Mastering DAX Calculations in Power BI by Enterprise DNA, Sam McKay (Udemy)

The Mastering DAX Calculations in Power BI course offered by Enterprise DNA and Sam McKay teaches individuals how to utilize the powerful DAX language to create advanced analytical models within Power BI. The course covers beginner theory, major DAX functions, and tips and techniques for practicing and implementing DAX well. Participants will learn the basics of DAX, the importance of a quality data model, and how to use DAX in common analytical scenarios. The course offers 11 hours of training and provides access to demo data sets for practice purposes.

Throughout the course, participants will learn how to structure and format DAX formulas, use calculated columns and measures in their models, and write aggregation and iteration formulas. They will also learn how to use the CALCULATE function, implement DAX functions in combination with each other, and use advanced table functions in unique calculation requirements. The course includes testimonials from individuals who have found the explanations and examples clear and easy to follow.

The course is worth 13.5 CPE credits and is a QAS self-study (Traditional) course. It can also be accessed through a purchase of an Enterprise DNA Membership or Center of Excellence License. The course content and sections include an introduction to DAX, DAX basics, getting started with DAX, simple table functions, expanding on CONTEXT, the CALCULATE statement, time intelligence functions, advanced techniques for variables, creating virtual relationships, advanced table functions, ranking functions, and advanced DAX formula combination examples. The course was last updated in January 2020.

5. Excel Power Query, Power Pivot, Power Map & DAX Masterclass by Andreas Exadaktylos (Udemy)

The Excel Power Query, Power Pivot, Power Map & DAX Masterclass Course, instructed by Andreas Exadaktylos, teaches users how to utilize Excel’s Business Intelligence (BI) tools to create interactive dashboards and reports. The course covers Power Query, Power Pivot, DAX, Power View, Power Map (3D Maps), and the Power BI Desktop application. The course is designed to guide users through creating BI reports and dashboards in Excel step-by-step using Microsoft Excel 2019 and Microsoft 365. Additionally, the course is compatible with older versions of Excel.

Throughout the course, users will learn how to import data from different sources such as spreadsheets, Access, SQL, and text files. They will also learn how to add calculated fields, columns, and measures using the DAX formula language. The course covers complex reporting systems, Power View presentation and analysis tools, and creating interactive sales maps using Excel Power View. Users will learn how to summarize data with matrices, cards, and tiles, and perform simple-to-sophisticated calculations like Month to date and Year to date.

The course is ideal for data analysts, MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals, and students. It’s also suitable for users with basic prior experience in Excel or Spreadsheets. The course’s content includes an introduction, sections on each BI tool, milestones, and a bonus section. Users will have lifetime access to the course videos and can download working files to follow along with the lectures. The course offers fast and responsive support within 48 hours, and if users are not 100% satisfied, there is a 30-day money-back guarantee.

Enrolling in the course includes a Certificate of Completion upon completion. The course is highly recommended by students who have completed it and found it helpful in developing their reporting dashboards.

6. Master DAX fundamentals : Power BI, Power Pivot & SSAS by Paula Guilfoyle CPA & MVP (Udemy)

The course titled Master DAX fundamentals: Power BI, Power Pivot & SSAS is instructed by Paula Guilfoyle CPA & MVP. The course focuses on the fundamentals of data analysis and modeling with DAX for Power BI, Power Pivot and Analysis Services. DAX is a useful tool for analyzing and modeling data. The course is a hands-on experience that consists of different sections.

In the first section, the course introduces the most commonly used DAX expressions, including SUM, SUMX, COUNT, ROUND, DIVIDE, MIN, MAX, IF Statements, TEXT expressions, Variables, and more. The section is designed to provide a basic understanding of DAX expressions and their usage.

In the second section, the course covers the fundamentals of how DAX works. The section includes both theory and practical examples. It is essential to understand how DAX works to apply it effectively. The section discusses Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships, and much more.

In the third section, the course covers Time Intelligence and Date Tables. The section focuses on expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and how to use CALCULATE to explore these functions.

Each section of the course contains Activities to complete, which is crucial for learning DAX. Master DAX fundamentals: Power BI, Power Pivot & SSAS course offers a complete overview of DAX, and it is ideal for data analysts and professionals who want to learn how to analyze and model data.

7. DAX Power Pivot – 10 Easy Steps for Intermediates by Gilly Dow (Udemy)

The DAX Power Pivot – 10 Easy Steps for Intermediates course is designed for individuals who have already acquired skills in Power Pivot and are looking to enhance their understanding of Disconnected or Parameter tables for gaining additional insights into data models. The course builds upon the skills learned in the first course and addresses Microsoft’s change to the DAX engine, which can be challenging to edit queries without an expert in SQL. The course covers topics such as Initial Filter Context, Filter Context, Context Transition, and various functions such as IF(), VALUES(), and HASONEVALUE().

The course provides examples and practice exercises to help students consolidate and embed their skills. The course also covers topics such as Thresholds, Cut-offs, and Banding. The course instructor, Gilly Dow, provides video solutions to the practice exercises to support the learning process. The course is suitable for individuals working in finance, statistics, project, business, and market analysis, or any data reporting role requiring the creation of Business Intelligence style dashboard and Insight reports.

The DAX Power Pivot – 10 Easy Steps for Intermediates course offers ten steps that help students build upon their beginner DAX skills, taking them to the next level. Some of the topics covered in the course include DAX Iterators & Aggregator Functions, Disconnected/Parameter Tables, Harvester Measures, Conversion Measures, and Key Performance Indicators (KPIs). The course provides detailed instructions, real-world examples, and deep dives into advanced Power Pivot formulas.

The course instructor has received positive feedback from students who found the course well-explained and supported by examples. The course is suitable for individuals with Excel 2016, but they can follow along in Excel 2010 & 2013. The course provides a FREE preview lecture to help individuals learn more about the course. The course instructor aims to help students take the next step in developing their DAX skills.

8. Mastering Intermediate DAX – Power BI, Power Pivot & SSAS by Paula Guilfoyle CPA & MVP (Udemy)

The Mastering Intermediate DAX – Power BI, Power Pivot & SSAS course, taught by Paula Guilfoyle CPA & MVP, is designed to improve your Data Analysis eXpressions (DAX) skills for use in Power BI, Power Pivot, and Analysis Services. The course will teach you how to analyze and model data, with a focus on hands-on learning.

The course is divided into four sections. In the first section, you will review the fundamentals of DAX, including row context, filter context, and functions such as ALL, FILTER, and RELATEDTABLE. Section two introduces DAX functions in more detail, including ISFILTERED, ISCROSSFILTERED, ALLSELECTED, HASONEVALUE, and SELECTEDVALUES, which allow you to modify totals and subtotals.

Section three delves into CALCULATE and Context Transition, teaching you when to use FILTER inside CALCULATE, as well as when to combine CALCULATE and VALUES. Section four is dedicated to case studies, exploring parent-child hierarchies and the use of functions such as PATH and PATHLENGTH, different moving averages via EARLIER, FILTER, VALUES, and AVERAGE, and the use of iterator functions over different granularities.

Finally, the course covers advanced relationships, including BI Directional Filters, and the use of USERELATIONSHIP. Each section includes a downloadable folder that contains examples and activities for practice. The course emphasizes hands-on learning and practice to improve your mastery of DAX.

9. DAX Power Pivot Time Intelligence – 10 Easy Steps by Gilly Dow (Udemy)

The DAX Power Pivot Time Intelligence – 10 Easy Steps course, taught by Gilly Dow, aims to support the needs of Business Intelligence by utilizing custom calendars and time period functions in DAX. The course is a continuation of the first course in the series, DAX Power Pivot – 10 Easy Steps for Beginners.

The course content includes DAX Time Intelligence functions, which enable users to manipulate data using time periods, build calculations over those periods, and compare them. The first half of the course focuses on DAX time-ready functions for a standard calendar, while the second half delves into custom functions for non-standard 4-4-5 calendars used in various industries.

The course has received positive feedback from students, who praise the instructor’s clear explanations and enthusiasm. The course is suitable for individuals who want to improve their understanding of DAX and Power Pivot, even if it does not directly fit their remit.

The course covers topics such as date calculations, building standard and custom calendar tables, computing moving annual totals, aggregating and comparing growth percentages over time, and custom time intelligence with CALCULATE() and FILTER().

While the first half of the course is intuitive and straightforward, the second half may be challenging. However, the instructor provides guidance and support to help students create custom Time Intelligence functions.

The course is demonstrated in Excel 2016, but it is also compatible with Excel 2010 and 2013. The course includes 10 steps, a bonus section, and a conclusion. Students can message the instructor or preview the lectures to learn more about the course.

10. Mastering DAX Studio by Randy Minder (Udemy)

Course Title: Mastering DAX Studio

Course Instructors: Randy Minder

Course Short Description: This course aims to provide the learners with the necessary knowledge and skills to utilize DAX Studio to improve their productivity as DAX, Power BI, and Power Pivot developers.

Course Long Description: DAX Studio is an essential tool for DAX developers. This course is specifically designed to help learners master the features and functionality of DAX Studio. Throughout the course, learners will be guided through executing queries, exporting data to CSV and SQL Studio, troubleshooting queries, capturing all queries coming from Power BI, performing performance monitoring, dynamic management views, and more.

Course Content and Sections:

1. Introduction
2. Downloading and Installing
3. Working with DAX Studio
4. Debugging, Query Tracing & Performance Monitoring
5. SQL Server Management Studio (SSMS)
6. Wrap Up
7. New Releases
8. Time for some practice

Each section of the course aims to provide learners with comprehensive knowledge and skills to use DAX Studio effectively. Upon completion of the course, learners will be able to utilize DAX Studio to enhance their productivity as DAX developers.