Power BI DAX Super User: DAX for Power Nerds

Power BI DAX Super User: DAX for Power Nerds, available at $74.99, has an average rating of 4.56, with 46 lectures, based on 9 reviews, and has 62 subscribers.

You will learn about Prep your data with the Power Query Editor Learn why you need a Rolling Calendar when you have date fields Learn a multitude of functions in nine DAX Category types Install and create new stunning visuals from the Marketplace and use the new slicer Examine the new DAX Query View Manage Roles of users before publishing to Web Service This course is ideal for individuals who are Students who have a solid foundation from using Power BI or Advanced Power BI users with 2-3 years working with functions in general or Someone who wants to upgrade their Power BI Knowledge and take it to the next level It is particularly useful for Students who have a solid foundation from using Power BI or Advanced Power BI users with 2-3 years working with functions in general or Someone who wants to upgrade their Power BI Knowledge and take it to the next level.

Enroll now: Power BI DAX Super User: DAX for Power Nerds

Summary

Title: Power BI DAX Super User: DAX for Power Nerds

Price: $74.99

Average Rating: 4.56

Number of Lectures: 46

Number of Published Lectures: 46

Number of Curriculum Items: 46

Number of Published Curriculum Objects: 46

Original Price: $99.99

Quality Status: approved

Status: Live

What You Will Learn

Prep your data with the Power Query Editor
Learn why you need a Rolling Calendar when you have date fields
Learn a multitude of functions in nine DAX Category types
Install and create new stunning visuals from the Marketplace and use the new slicer
Examine the new DAX Query View
Manage Roles of users before publishing to Web Service

Who Should Attend

Students who have a solid foundation from using Power BI
Advanced Power BI users with 2-3 years working with functions in general
Someone who wants to upgrade their Power BI Knowledge and take it to the next level

Target Audiences

Students who have a solid foundation from using Power BI
Advanced Power BI users with 2-3 years working with functions in general
Someone who wants to upgrade their Power BI Knowledge and take it to the next level

Welcome to my intermediate level for Power BI users who want to delve deeper into the DAX functional language. After taking my Power BI Data Analysis Course(for beginners) you now will be ready to take your skills to the next level and really get a grasp on the DAX language that is used in Power BI formulas.

In this course we will implement over 30 DAX functions from across nine different categories:

Conditional & Logical Functions
Date & Time Functions
Math & Stats Functions
Text Functions
Iterator Functions
Time Intelligence Functions
Table & Filter Functions
Infamous CALCUALTE Function
Information Functions

I will teach you how to problem solve your formulas and how to build them in pieces, so they are easier to understand and use that knowledge to have your measures call other measures. Not to mention learn to build a measures table to hold all the measure you will create for your report to keep them organized and all in one place.

You will also learn the need to have a rolling calendar and the benefits it provides for those people who have a multitude of tables with date fields and how the table will auto adjust its dates as new data is added.

All that combined with installing appealing new visuals from the marketplace and using stunning slicers to make your reports more interactive for your user. By the end of this course, you will have the confidence to build out your formulas to get the results you need and the visually appealing new visuals on your reports that show the results of your data analysis for the company!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview

Lecture 2: Support Notes for Students

Lecture 3: Download Course Resources & PDF Manual

Lecture 4: Contacting the Instructor

Lecture 5: Let's Set Some Expectations

Lecture 6: PDF Manual & Video Correlation

Chapter 2: Power BI Essentials

Lecture 1: Configuring Options & Settings

Lecture 2: Connecting to Data

Lecture 3: Managing Relationships

Lecture 4: Combining Queries

Lecture 5: Building Hierarchies

Lecture 6: Dedicated Measures Table

Chapter 3: Data Prepping with the PQE

Lecture 1: Understanding the Power Query Editor

Lecture 2: Data Profiling Tools

Lecture 3: Where do you Calculate?

Lecture 4: Grouping & Aggregating Data

Lecture 5: Pivoting & Unpivoting

Lecture 6: PQE Parameters

Lecture 7: Rolling Calendar

Lecture 8: Setting Relationships

Lecture 9: Section 3 / Lesson 2 Exercise

Chapter 4: Calculating with DAX Functions

Lecture 1: Conditional & Logical Functions

Lecture 2: Date & Time Functions

Lecture 3: Math & Stats Functions

Lecture 4: TEXT Functions

Lecture 5: Infamous CALCULATE Function

Lecture 6: Iterator Functions

Lecture 7: Time Intelligence Functions

Lecture 8: Table & Filter Functions

Lecture 9: Information Functions

Lecture 10: DAX Query View

Lecture 11: Section 4 / Lesson 3 Exercise

Chapter 5: Visualizing your Data Results

Lecture 1: Living in the Matrix

Lecture 2: Trends & Forecasts

Lecture 3: Geo Sync your Data with Maps

Lecture 4: Key Metrics with KPI Visuals

Lecture 5: Designing for Smart Phones

Lecture 6: Interactive Reports

Lecture 7: The New Slicer

Lecture 8: Section 5 / Lesson 4 Exercise

Chapter 6: Dashboard & Final Touches

Lecture 1: Creating Objects

Lecture 2: Slicers & Filters

Lecture 3: Custom Navigation

Lecture 4: Managing Roles

Chapter 7: Course Project

Lecture 1: Instructor Thank You!

Lecture 2: Power BI DAX Super User Project

Instructors

Robin Solonenko
Microsoft Instructor

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 4 votes
5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu