Intermediate DAX & Time Intelligence

Corporate Finance Institute via Coursera

Go to Course: https://www.coursera.org/learn/intermediate-dax-and-time-intelligence

Syllabus

Getting Started

In this course, we’ll review the basics of DAX formulas for creating Measures and Calculated Columns. We’ll explore the difference between DAX functions that return a scalar value, and those that return a table. With this deep understanding of scalar values and tables, we'll show you the ins and outs of data modeling and context manipulation.

Introduction to DAX

In this module, we will recall the core concepts of DAX: measures, calculated column, row & filter context.

DAX Scalar Functions

In this module, we will learn to apply functions that return a single, scalar value of various data types.

Week 1 Challenge

DAX Table Functions

Table functions allow us to create dynamic tables based on our requirements. In this module, we will learn how to manipulate source data with Table functions.

Data Modeling & Context

In this module, we will learn to apply DAX concepts and functions on a data model.

Week 2 Challenge

Date & Time Intelligence

In this module, we will learn to analyze and manipulate data over time with Date & Time Intelligence functionality.

Course Summary

Week 3 Challenge

Overview

DAX is essential for working with data and data models in Excel and Power BI. Many analysts start building complex DAX formulas, without a solid grounding in DAX basics, context manipulation, and time intelligence. In this course, we’ll quickly review the basics of DAX formulas for creating Measures and Calculated Columns. We’ll explore the difference between DAX functions that return a scalar value, and those that return a table. With this deep understanding of scalar values and tables, we'll

Skills

Reviews

Just what I needed. To the point, and covered DAX at a level that is not to technical but still very useful.

Easily Understandable, even the intermediate sections of DAX