Online Course free
Introduction to DAX

Learn the fundamentals of Microsoft’s native formula and query language DAX: Master essential techniques for powerful data analysis

4.9

868 reviews on
5,806 students already enrolled
  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners

Skill level:

Intermediate

Duration:

3 hours
  • Lessons (3 hours)

CPE credits:

4
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of professionals must earn to maintain their licenses and stay current with regulations and best practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's official website: www.nasbaregistry.org

Accredited

certificate

What you learn

  • Gain a comprehensive introduction to DAX for Power BI, Excel, and SQL Server.
  • Master DAX syntax to improve your data manipulation capabilities.
  • Build confidence writing DAX expressions for complex calculations and queries.
  • Leverage DAX to create sophisticated analytical reports in Power BI.
  • Boost your career by mastering a high-demand technical skill in data.

Topics & tools

DAXBusiness IntelligenceData ModelingData PreprocessingIndustry SpecializationData AnalysisPowerbi

Your instructor

Course OVERVIEW

Description

CPE Credits: 4 Field of Study: Information Technology
Delivery Method: QAS Self Study
DAX (Data Analysis Expressions) is a formula and query language used in Power BI to create calculated columns, measures, and custom tables. Knowing how to use DAX will take your Power BI analysis skills to the next level. In this course, we will show you how to create custom functions, which will help you build sophisticated business reports in Power BI. DAX is easy to learn, especially if you have used Microsoft Excel in the past, as it includes some of the same functions. However, DAX also contains several functions that make the work with relational data easier.

Prerequisites

  • Microsoft Power BI Desktop (free version available at powerbi.microsoft.com)
  • Completion of an introductory Power BI course is required.

Advanced preparation

Curriculum

22 lessons 1 exam
  • 1. Introduction to DAX
    205 min
    This section lays the foundations of using DAX to gain complete control over your data.
    205 min
    This section lays the foundations of using DAX to gain complete control over your data.
    Course intro Free
    Calculated Columns Free
    Calendar Table Free
    Building a Measure Free
    Measures Table Free
    CALCULATE Free
    FILTER vs KEEPFILTERS Free
    Iterators Free
    RELATED vs RELATEDTABLE Free
    SELECTEDVALUE Free
    DIVIDE Free
    Logical Operators Free
    Variables Free
    TREATAS Free
    SWITCH Free
    Text Functions Free
    CONCATENATEX Free
    Time Intelligence Free
    Expression Based Titles Free
    Role Level Security Free
    Calculation Groups Free
    DAX assignment Free
  • 2. Course exam
    25 min
    25 min
    Course exam Free

Free lessons

Course intro

1.1 Course intro

2 min

Calculated Columns

1.2 Calculated Columns

7 min

Calendar Table

1.3 Calendar Table

16 min

Building a Measure

1.4 Building a Measure

9 min

Measures Table

1.5 Measures Table

5 min

CALCULATE

1.6 CALCULATE

7 min

Start for free

$29,000

average salary increase

after moving to an AI and data science career

9 in 10

people walk away career-ready

with practical data and AI skills.

94%

of AI and data science graduates

successfully change

or advance their careers.

ACCREDITED certificates

Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global institutions.

Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities employers value most.

  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners
A LinkedIn profile mockup on a mobile screen showing Parker Maxwell, a Certified Data Analyst, with credentials from 365 Data Science listed under Licenses & Certification. A 365 Data Science Certificate of Achievement awarded to Parker Maxwell for completing the Data Analyst career track, featuring accreditation badges and a gold “Verified Certificate” seal.

How it WORKS

  • Lessons
  • Exercises
  • Projects
  • Practice exams
  • AI mock interviews

Lessons

Learn through short, simple lessons—no prior experience in AI or data science needed.

Try for free

Exercises

Reinforce your learning with mini recaps, hands-on coding, flashcards, fill-in-the-blank activities, and other engaging exercises.

Try for free

Projects

Tackle real-world AI and data science projects—just like those faced by industry professionals every day.

Try for free

Practice exams

Track your progress and solidify your knowledge with regular practice exams.

Try for free

AI mock interviews

Prep for interviews with real-world tasks, popular questions, and real-time feedback.

Try for free

Student REVIEWS

A collage of student testimonials from 365 Data Science learners, featuring profile photos, names, job titles, and quotes or video play icons, showcasing diverse backgrounds and successful career transitions into AI and data science roles.