Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS

Focused View

Eugene Meidinger

2:58:38

21 View

01 - Course Overview

01 - Course Overview.mp4

01:09

02 - Understanding What Makes DAX so Unique

02 - What Is DAX.mp4

03:45

03 - Where Does DAX Shine.mp4

06:34

04 - The Challenge of Learning DAX.mp4

04:11

03 - Planning Your Data Governance - Power BI, Power Pivot, or SSAS Tabular

05 - What Is Data Governance.mp4

03:30

06 - Organizational vs. Self Service.mp4

05:00

07 - On Premises vs. Cloud.mp4

04:01

08 - Tools That Use Dax.mp4

05:15

09 - Summary.mp4

01:09

04 - Thinking in Columns, Not Rows

10 - Comparing OLTP vs. OLAP.mp4

04:35

11 - What Is a Columnar Database.mp4

06:40

12 - Compression and Encoding.mp4

04:54

13 - DEMO - Compression and Encoding.mp4

13:08

14 - Summary.mp4

00:28

05 - Adding Business Logic with Calculated Columns and Measures

15 - Adding Business Logic.mp4

04:44

16 - Calculated Columns.mp4

03:08

17 - DEMO - Calculated Columns.mp4

09:54

18 - Measures.mp4

04:01

19 - DEMO - Measures.mp4

07:07

20 - Summary.mp4

00:29

06 - Filtering Data Using CALCULATE

21 - Why Filtering.mp4

02:47

22 - Using CALCULATE.mp4

02:22

23 - DEMO - Implicit vs. Explicit Filtering.mp4

06:32

24 - Using Filter.mp4

02:22

25 - Demo - Using FILTER.mp4

06:33

26 - Using ALL.mp4

02:01

27 - DEMO - Using ALL.mp4

04:30

28 - Summary.mp4

00:28

07 - Looping Over Data with Iterators

29 - What Are Iterators.mp4

06:26

30 - DEMO - Iterators.mp4

07:57

31 - Evaluation Contexts.mp4

08:16

32 - DEMO - Nesting Evaluation Contexts.mp4

07:17

33 - Summary.mp4

00:27

08 - Analyzing History with Time Intelligence

34 - What Is Time Intelligence.mp4

02:25

35 - What Is a Date Table.mp4

03:46

36 - DEMO - Date Tables.mp4

13:04

37 - How Do You Use Time Intelligence.mp4

01:25

38 - DEMO - Time Intelligence.mp4

05:13

39 - Summary.mp4

01:05

Description

DAX is a popular language for any sort of analytical reporting in the Microsoft BI stack. Whether you are using Power BI, Power Pivot, or SSAS, this course will teach you how to model your data with DAX.

What You'll Learn?

If you want to use Power BI, Power Pivot, or SSAS (tabular mode), you'll need to learn DAX. In this course, Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS, you'll learn the basics of the DAX language. First, you'll learn how DAX works and why it has such good performance. Next, you'll explore how to encapsulate business logic using calculated columns and measures. Finally, you'll discover a variety of ways to manipulate filters or analyze your data. When you're finished this course, you'll have the skills and knowledge of DAX to model and analyze your data with the DAX expression language.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

DAX

Power Pivot

Eugene Meidinger

Instructor's Courses

Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.