Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Cleaning
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-03 20:13:44
30-Day Money-Back Guarantee

This course includes:

  • 6 hours on-demand video
  • 11 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
Business Business Analytics & Intelligence Microsoft Power BI

Power BI DAX Masterclass - Measures & Calculated Columns

Master advanced analysis with DAX - Learn Measures & Calculated Columns in Power BI (Advanced)!
Rating: 4.6 out of 54.6 (210 ratings)
1,180 students
Created by Nikolai Schuler
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Create your own Measures & Calculated Columns in DAX
  • Use DAX in Power BI for advanced data analysis
  • Gain advanced insights into your data with DAX
  • Understand the concepts behind Measures & Calculated Columns in DAX
  • Learn how to use the most important DAX functions
  • Create better reports with Measures & Calculated Columns
Curated for the Udemy for Business collection

Requirements

  • Some basic knowledge in Power BI is required

Description

From beginner to profesional in DAX – Master advanced analysis in Power BI with Measures & Calculated Columns

DAX is a really powerful language if you want to get all the advanced insights from your data. Wether you want to create custom columns or use more advanced calculations with Measures and realize the full potential of Power BI - DAX is the key to that.

Yet I know that many people feel discourage because they don't know where to start and without help it can be a bit frustrating and difficult.

That's why I have created this course!

In this course you will finally be able to learn DAX for your advance analysis in Power BI - and that in an easy and well structured way.


Get a fundamental understanding right from the beginning

In this course I will teach you everything clearly by looking at actual examples. Therefore we will be looking together at some sales data that you will also be able to download - so you can work and practise as much as you want.

Step by step you will then learn everything you need to know regarding DAX, Measures and Calculated Columns in Power BI.

At the end of this course you will be able to do your own analysis in DAX. At this point it will be easy for you to do and learn more in DAX because you have gained a fundamental understanding in DAX, Measures and Calculated Columns.


What you will learn in this course?


· DAX fundamentals:

· fundamental understanding of Measures & Calculated Columns

· Measures vs. Calculated Columns

· Filter context vs. row context

· DAX in the data model

· Aggregation functions

· Logical Operators and IF-Statements

· Automatically create comprehensive data tables with date features

· Advanced topics:

· Row based functions such as SUMX & AVERAGEX

· Running Totals, Moving Average

· Variables

· RANKX

· Custom Top-N-filtering

· CALCULATE

· All you need to know about CALCULATE

· Filter functions

· ALL, ALLSELECTED, ALLEXCEPT

· FILTER, VALUES

· How to use them the right way

· Quick Measures

· All you need to know about Quick Measures & how to use them properly

· Time Intelligence

· Year-to-Date, Date-To-Month etc.

· The most important time intelligence functions and the right way to work with them

· And much more!

Who this course is for:

  • Everyone that wants to know more about Power BI and wants to use DAX for Calculated Columns and Measures

Featured review

Alina Kapshyk
Alina Kapshyk
30 courses
12 reviews
Rating: 5.0 out of 54 months ago
An excellent course for the persistent professional. Nothing superfluous, concentration on Dax formulas, a laconic and interesting project at the end. Thanks to the instructor for attention to detail.

Course content

13 sections • 57 lectures • 5h 51m total length

  • Preview02:33
  • Preview04:09
  • DAX Cheat Sheet
    00:11
  • All the files for download
    00:12

  • Measures vs. Calculated Columns
    14:37
  • Automatically create a date table with CALENDARAUTO
    08:17
  • CALENDAR
    05:08
  • How to create a complete date table
    03:43
  • Script to reuse in your project for date tables
    00:23
  • Key Measures table
    03:19
  • Aggregation functions
    06:07
  • COUNT, COUNTA, COUNTBLANK,DISTINCTCOUNT & COUNTROWS
    14:05
  • Preview08:32

  • Exercises
    01:04
  • Solutions
    00:19

  • Power BI vs. Excel
    05:14
  • Filter context
    03:47
  • Row context
    03:48
  • Data model and DAX
    04:17

  • CALCULATE Basics
    10:53
  • FILTER
    06:31
  • ALL
    07:53
  • ALLSELECTED
    03:13
  • ALLEXCEPT
    07:24

  • Exercises
    00:53
  • Solutions
    00:19

  • Logical operators
    09:27
  • Commenting and Formatting
    05:48
  • VALUES & AVERAGEX
    08:47
  • Preview10:32
  • IF & Top-N-Filter
    11:12
  • Variables
    09:47

  • Exercises
    00:25
  • Solutions
    00:37

  • Time Intelligence & DATEADD
    11:18
  • Year-to-Date & Month-to-Date
    05:19
  • TOTALYTD vs. DATESYTD
    08:54
  • DATESBETWEEN
    05:15

  • ROUNDING (Numbers, Currency & Time)
    10:13
  • FORMAT (Predefined Numbers)
    09:59
  • Custom Formatting (Numbers)
    09:39
  • Custom Formatting (Time)
    06:01
  • Formatting Dates
    04:59

Instructor

Nikolai Schuler
Professional Data Scientist und BI Consultant
Nikolai Schuler
  • 4.7 Instructor Rating
  • 1,085 Reviews
  • 6,010 Students
  • 7 Courses

In my work as a data scientist and BI consultant in a big company located in Germany. I see that there a lot of new tools that bring a lot of benefits. Yet I also see that it is not always easy to learn working with these tool beside the daily other tasks we have to do.

Also I found it hard to find courses that are high quality as well as easy to understand and well structured.

For that reason I decided to create these courses that are high quality on the one hand and easy to learn with on the other hand.

As I am a data specialist on the one hand but also introducing ordinary users to Power BI and other tools on the other hand, I understand the common hurdels most people have.

Data and teaching are my passions and therefore I am really looking forward to level up your IT skills as well!


In meiner Arbeit als Data Scientist in einem großen Konzern sehe ich, dass neue Tools riesen Vorteile in der heutigen Zeit bringen und sie nicht mehr wegzudenken sind. Allerdings sehe ich auch, dass es nicht immer leicht ist sich neben der täglichen Arbeit in diese neuen Tools einzuarbeiten.

Mir selbst ist es auch schwer gefallen Kurse zu finden, die einerseits qualitativ hochwertig und andererseits verständlich und gut strukturiert sind.

Aus diesem Grund habe ich mich dazu entschlossen selbst strukturierte und praxisorientierte Kurse zu erstellen.

Da ich sowohl für einfache Anwender als auch für Datenspezialisten Einweisungen in Power BI und anderen Tools gebe, bin ich einerseits technischer Spezialist, habe aber andererseits auch ein gutes Gefühl für die, die nicht die reinen Datenspezialisten sind.

Mir zu überlegen wie man das Wissen wirklich sinnvoll und verständlich rüberbringen kann, ist das was mir dabei Freude macht.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.