Introduction to DAX

with Dimitar Shutev
4.8/5
(601)

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

3 hours of content 4814 students

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 3 hours of content
  • 24 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Introduction to DAX

A course by Dimitar Shutev

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 3 hours of content
  • 24 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

$99.00

Lifetime access

Buy now

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 3 hours of content
  • 24 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

What You Learn

  • Get a comprehensive introduction to DAX, the powerful formula and query language used across Microsoft’s leading data analysis tools like Power BI, SQL Server, Power Pivot in Excel
  • Master the fundamental syntax of DAX to enhance your data manipulation capabilities
  • Build confidence in writing your own DAX expressions to create complex calculations and queries effectively
  • Leverage DAX expressions to build sophisticated business reports in Power BI
  • Improve your dashboard’s analytical power by adding well-written DAX expressions
  • Boost your career prospects by mastering DAX, a highly sought-after technical skill by employers in data-driven industries

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

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.

Learn for Free

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

Curriculum

  • 1. Introduction to DAX
    22 Lessons 205 Min

    This section lays the foundations of using DAX to gain complete control over your data.

    Course intro
    2 min
    Calculated Columns
    7 min
    Calendar Table
    16 min
    Building a Measure
    9 min
    Measures Table
    5 min
    CALCULATE
    7 min
    FILTER vs KEEPFILTERS
    13 min
    Iterators
    7 min
    RELATED vs RELATEDTABLE
    10 min
    SELECTEDVALUE
    5 min
    DIVIDE
    8 min
    Logical Operators
    6 min
    Variables
    13 min
    TREATAS
    14 min
    SWITCH
    13 min
    Text Functions
    19 min
    CONCATENATEX
    10 min
    Time Intelligence
    11 min
    Expression Based Titles
    13 min
    Role Level Security
    6 min
    Calculation Groups
    9 min
    DAX assignment Read now
    2 min

Topics

DAXBusiness IntelligenceData modelingdata preprocessing

Tools & Technologies

powerbi

Course Requirements

  • No prior experience with DAX is required
  • Highly recommended to take the Power BI and Power Query courses first
  • You need access to Microsoft Office 365

Who Should Take This Course?

Level of difficulty: Intermediate

  • Aspiring BI analysts, data analysts, and data scientists
  • Aspiring financial analysts, financial controllers, and business analysts who want the technical skills to satisfy their own data exploration needs
  • Everyone who wants to improve their practical Power BI skills

Exams and Certification

A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Exams and certification

Meet Your Instructor

Dimitar Shutev

Dimitar Shutev

Senior Data Analyst at

5 Courses

5802 Reviews

73034 Students

Dimitar started his career as a BI developer for Rimilia, DXC Technology, and NaXex Technological Development Ltd. Then, he was hired as a Senior Data Analyst at the global travel technology company Amadeus. Currently, Dimitar works as a Senior Data Engineer at EPAM Systems. As an instructor at 365, Dimitar has demonstrated a great passion for teaching and a genuine willingness to support his students along the way. He spends a great deal of time improving the lessons of his Power BI course and is willing to go the extra mile to create practice exam questions and course exam questions.

What Our Learners Say

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.