DA-100: Microsoft Power BI, Part 4 of 5: DAX

Course description

Data Science is a growing field, this course explores Data Analysis Expressions(DAX), the language developed to interact with data. Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. The DA-100 Exam validates this expertise.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

Experience with Microsoft Excel, pivot tables and power pivot modelling is helpful.

Meet the expert

Nikolai Schuler

Nikolai is a mathematician and works as a data scientist in a large German company. He is focused mainly on gaining insights from data and creating a positive impact with this knowledge.

Video Runtime

166 Minutes

Time to complete

289 Minutes

Course Outline

DAX Module 1

Welcome to DAX (19:02)

• Introduction (00:08)
• Let's look at our data (04:08)
• Measures vs. Calculated Columns (08:28)
• Calculate Revenue (06:10)
• Summary (00:08)

CALENDARAUTO (20:43)

• Introduction (00:08)
• CALENDARAUTO (08:17)
• CALENDAR (05:08)
• How to create a complete date table (03:43)
• Key Measures Table (03:19)
• Summary (00:08)

Aggregation functions (29:00)

• Introduction (00:08)
• Aggregation functions (06:07)
• COUNT (14:05)
• SUMX - How does it work (08:32)
• Summary (00:08)

DAX Module 2

DAX Calculate (36:10)

• Introduction (00:08)
• CALCULATE Basics (10:53)
• Changing the Context with FILTER (06:31)
• ALL (07:53)
• ALLSELECTED (03:13)
• ALLEXCEPT (07:24)
• Summary (00:08)

DAX TimeIntelligence (31:02)

• Introduction (00:08)
• TimeIntelligence & DATEADD (11:18)
• Year-to-Date & Month-to-Date (05:19)
• TOTALYTD VS DATESYTD (08:54)
• DATESBEETWEEN (05:15)
• Summary (00:08)

DAX Advanced Topics (30:04)

• Introduction (00:08)
• Logical Operators (09:27)
• Commenting and Formatting (05:48)
• Variables (09:47)
• Quickmeasures use Intelligently (04:46)
• Summary (00:08)