8 Best + Free DAX Courses & Classes [2021 SEPTEMBER]

Best DAX course tutorial class certification training online

If you’re interested in learning DAX programming so that you can work with Power Pivot tables, Power BI, Maps, and other tools, then it is better to take help from courses and tutorials that are created by some of the best instructors in the world. After in-depth research, our experts have come up with a practical list of the Best Classes, Courses, Tutorials, Specialization, and Training programs available online for 2021. We have tried to include almost every free and paid course on the list so that you don’t struggle to find the right path according to your requirements. Check our compilation of Best Data Visualization Courses.

 

8 Best + Free DAX Courses & Classes [2021 SEPTEMBER]

1. Excel Power Query, Power Pivot, Power Map & DAX Masterclass (Udemy)

If you have a basic knowledge of excel and want to master Excel Dashboard, then this course is for you. Created by Andreas Exadaktylos, founder of Mellon Training, this course is designed to learn excel power query, DAX, Power Pivot, Power Map & Power BI Tools along with building excel data analyst models with Excel 2019.  This course format is designed with a step by step approach so that you can quickly learn how to create business intelligence reports and dashboards quickly and effectively in Excel. It is perfect for data analysts, MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals, and students.

 

Key USPs –

– Learn to import data from access, spreadsheets, text files, SQL and add calculated columns & fields with DAX formula language.

– Know how to create exceptional excel pivot charts from Power Pivot along with making reports utilizing Slicers & Timeline.

– Summarize data with Matrices, cards, and Tiles and perform altering calculations to analyzing multiple tables together without using VLOOKUP formulas.

– Learn to create a complex reporting system and making an interactive sales map with the help of Excel Power View.

 

Duration: 5 hours

Rating: 4.5 out of 5

You can Sign up Here

 

Review: A thorough tutorial on using charts, pivot tables, etc. to create dashboard reporting. Very well presented and explain complex issues in a simple way. It is clear and easy to understand and has helped me develop reporting dashboards. Excellent! – Albert Loomer.

 

2. Master DAX Fundamentals: Power BI, Power Pivot & SSAS (Udemy)

If you are willing to learn the fundamentals of data analysis and modeling, and how to model data using Power BI, Power Pivot, or SSAS, then this is the perfect course for you. To enroll in this course, you must be familiar with Power BI, Power Pivot, or Analysis Services and have an interest in Data modeling. This is a hands-on course that will help you learn how to analyze and model your data within Power BI, Excels Power Pivot, and analysis services with data analysis expressions. The course is prepared by Paula Guilfoyle, who has ensured that the course content is present in the most accessible form so that individuals can easily understand it.

 

Key USPs –

– Get introduced to the use of most common DAX expressions, such as SUM and SUMX, ROUND, DIVIDE, COUNT, MAX, IF Statements, Variables, etc.

– Know about the fundamentals of how DAX works with theory and examples while discussing Row context and Filter context, Calculate, Earlier, and more.

– Learn how to use and explain Time intelligence functions like TOTALTYD, SAMEPERIODLASTYEAR, and many others.

– Be able to explain and use aggregation functions and expressions in DAX, as well as learn to use DAX for creating DATE tables.

 

Duration: 3 hours

Rating: 4.1 out of 5

You can Sign up Here

 

Review: It was great! I just had to spend a lot of time trying to find the workbook being used. Would have been great to have it attached to this lecture as a resource. Wonderful explanations really enjoyed! – Theresa Cronje.

 

3. DAX Power Pivot – 10 Easy Steps for Intermediates (Udemy)

This course is part of a previous program DAX Power Pivot – 10 Easy Steps for Intermediates. Created by Gilly Dow, the founder of gdteach.co.uk, this course is developed to help you learn how to create a data model with ‘Get & Transform’ in Excel. It focuses on helping you learn how to build Power Pivot Data models with Excel 2016 Power Query and take your DAX Business Intelligence to the next level. Joining this program will provide you with a solid understanding of the basic DAX aggregator and gives the confidence to build measures with several functions that advance your DAX Tool kit. Besides, it offers lifetime access, practice exercises, and quizzes for you to aid embed and consolidate your skills. So, you will be learning with an easy and interacting approach with professionals throughout the program.

 

Key USPs –

Acquire a thorough understanding of how “Disconnected” or “Parameter” tables can be used to gain extra insights in your data models.

– Learn to use “Get & Transform” to import data and reduce the size of your data model file size considerably.

– Know the real meaning behind “Initial Filter Context,” “Filter Context” and “Context Transition” along with explanations, diagrams, examples, and practice exercises.

 

Duration: 7.5 hours

Rating: 4.6 out of 5

You can Sign up Here

 

Review: “Do Love the way you teach. Hope to learn more from you for advanced DAX course with real-world case studies. Bravo! – HA.

 

4. Mastering Intermediate DAX – Power BI, Power Pivot & SSAS (Udemy)

Individuals who are attentive in learning data modeling and want to take their data analysis expression skills to the next level with DAX can take help from this course. It is specially designed for Data Analysts, Finance and Accounting Staff, Business Managers, Marketing Professionals, and all those involved with reporting. Taking up this course will help you understand Data Analysis and data modeling, which is made easy with Data Analysis expressions along with utilizing Power BI, Power Pivot, and Analysis Services. The course is created by Paula Guilfoyle, who has experience in Accounting, Business Management, and Training. She will help you throughout the sessions to assist with any queries related to the curriculum.

 

Key USPs –

– Learn the fundamentals of how DAX works along with Row context and Filter context, ALL, Filter, RELATED TABLE, CALCULATE, EARLIER, RELATIONSHIPS, and much more.

– Know more about DAX functions in detail and alter or amend how totals and subtotals are shown.

– Dive deeper to understand how to calculate and contest transition along with learning to use filter inside calculate.

– Gain the ability to modify the current filter context with DAX expressions while understanding bidirectional filters.

 

Duration: 2 hours

Rating: 4.5 out of 5

You can Sign up Here

 

Review: The presentation is swift but repetitive, explaining the logic and reasoning for each element. Easy to follow. – Rachel Matthews.

 

5. DAX Power Pivot Time Intelligence – 10 Easy Steps (Udemy)

This is another excellent course by instructor Gilly Dow, which is specially designed for individuals who want to study DAX Time Intelligence functions with standard or custom calendars. It will help you learn how to build a standard calendar table, perform date calculations in DAX with a standard calendar, manipulate DAX patterns. It supports the needs of business intelligence utilizing the custom calendars & Time Period Functions in DAX. Besides, it is included with a 4-4-5 Custom Calendar in Excel that relates to the existing Data Model and use of DAX patterns to master the custom calendar. At the end of the course, you will be equipped with all the aspects of the DAX Power Pivot table.

 

Key USPs –

– Learn how to support the needs of business intelligence with the help of Time Period Functions in DAX.

– Get to know how to manipulate DAX to create your own custom functions to work with 4-4-5 calendars used in several industries, including retail.

– Learn some new DAX functions that will promote your skills, enabling you to create custom functions for those pesky non-standard calendars.

– Gain knowledge about computing periods, closing balance, aggregating and comparing growth %’s overtime, and computing values between dates.

 

Duration: 6 hours

Rating: 4.7 out of 5

You can Sign up Here

 

Review: Gilly is absolutely a star. The post-purchase service is the greatest experience I’ve ever had on Udemy. I really hope Gilly’s talent will be discovered by a vast number of Udemy audience. BTW, she provides a manual for each course on top of working files, no one else does. So thoughtful!!! – Anne Ye.

 

6. DAX Language (SQLBI)

SQLBI offers a variety of programming courses, and this DAX course is prepared to enhance your comprehensive knowledge of Power BI, Power Pivot, and Analysis services tabular. It is divided into three parts – the DAX video course, Mastering DAX Workshop, and the Optimizing DAX Workshop. The training is not outsourced here, and the in-house experts have gained knowledge from traveling to different parts of the world. So, the instructor will be sharing their personal experience with you throughout the course, and you’ll get answers to your questions along with explanations. Moreover, you’ll also get access to a copy of the book that has been written by the experts. Don’t forget to check our curation of Best Pivot Trading Courses. 

 

Key USPs –

– Learn the basic idea of DAX syntax and standard functions used in most of the solutions and apply in your business to see verified results.

– The Mastering DAX Workshop is the most advanced course accessible on the DAX query language that brings our learners to a whole new level of expertise.

– The Optimizing DAX Workshop explains how to identify bottlenecks in DAX calculations, thus improving the performance of DAX formulas and Tabular data models.

 

Duration: Self-paced

Rating: 4.6 out of 5

You can Sign up Here

 

7. Introduction to DAX (Microsoft Docs)

As Microsoft provides a lot of free tutorials and programs related to its products and technologies, this tutorial on Power BI is designed to help individuals learn about the basics of DAX. This guided tutorial is focused on teaching you the basics and fundamental concepts of DAX, such as how to think about DAX, how it works, and its most useful features. The tutorial is developed by Alberto Ferrari, who is a renowned DAX expert at Microsoft. He has developed this tutorial from his personal experience, so you will be gaining a lot of insights about working with DAX.

 

Key USPs –

Get introduced to the basics of DAX, unique programming concepts and patterns used by DAX, and other essential topics.

– Learn about the primary calculations that can be created with DAX, which include calculated columns and measures.

– Know about various functions of DAX, such as aggregation, counting, logical, information, text, and date functions.

– Learn from the perspective of how the DAX formula language works, which is useful while creating DAX formulas from scratch, as well as creating queries in the Query editor.

 

Duration: Self-paced

Rating: 4.5 out of 5

You can Sign up Here

 

8. Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS (PluralSight)

This online learning module is designed to help you learn how to model your data with DAX. Taking up this course will aid you in learning the basics of DAX language and explore how to encapsulate the business logic utilizing the calculated measures and columns. However, you need a basic knowledge of creating reports in Power BI, Power Pivot, or SQL Server Analysis Services before initiating this course. The course is designed by Eugene Meidinge, who is certified in Querying & Administering SQL Server 2012. During the lessons, the instructor will provide you with multiple examples to get started with DAX Formulas in Power BI, Power Pivot, and SSAS. You may like to check our take on Best Pivot Tables Courses.

 

Key USPs –

– Learn and understand what makes DAX unique, and the challenges of learning it along with planning data governance and tools involved.

– Get a stronghold of comparing OLTPS vs. OLAP, compressions & encoding, DEMO, and adding business logic with calculated columns & measures.

– Gain knowledge of Filtering data using CALCULATE, DEMO, using ALL, using CALCULATE, using filter align with looping over data with iterators.

– Be able to model and analyze your data with the DAX expression language after concluding the curriculum.

 

Duration: 3 hours

Rating: 5 out of 5

You can Sign up Here

 

 

These courses and programs will help you explore the DAX field from scratch without any prior knowledge. Also, they will provide you with real-world examples of DAX technology so that you can understand the concepts in a better way.