Microsoft Power BI Desktop: Advanced DAX for Data Analysis

BY
Udemy

Acquire advanced abilities in Power BI and data analysis and also become an expert in the DAX language.

Mode

Online

Fees

₹ 4099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Microsoft's Power BI is a technology-driven business intelligence solution for analyzing and displaying raw data in order to deliver actionable insights. It integrates business analytics, data visualization, and best practices to facilitate data-driven decision-making within an organization. DAX is a formula language that can be used to create custom calculations for measures and calculated columns. DAX has some of the same functions as Excel formulas, as well as other functions that work with relational data and do dynamic aggregation. Advanced DAX for Microsoft Power BI Desktop online certification, which is made available by Udemy to candidates who wish to learn the analytical and business intelligence techniques utilized by the industry's leading professionals.

Microsoft Power BI Desktop: Advanced DAX for Data Analysis online course is a short-term program that incorporates 11.5 hours-long learning resources with eight articles that cover the analysis of real-world projects and business intelligence use cases with data analysis expressions (DAX) for Power BI

Microsoft Power BI Desktop: Advanced DAX for Data Analysis online classes cover topics including DAX engines, DAX tips & best practices, and scalar functions, as well as incorporate advanced calculations, table & filter functions, iterator ("X") functions, advanced time intelligence, and more. 

The highlights

  • Certificate of Completion
  • Self-Paced Course
  • 5 Articles
  • 11.5 Hours of Pre-Recorded Video Content
  • Learning Resources

Course and certificate fees

Fees information
₹ 4,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Data science knowledge

After completing the Microsoft Power BI Desktop: Advanced DAX for Data Analysis certification course, candidates will gain a hands-on understanding of the strategies and technologies associated with the best ways to use DAX, such as with variables, comments, queries, and handling errors. In this DAX certification, candidates will learn about scalar functions, iterators, advanced time intelligence, calculated table joins, relationship functions, and more. Individuals will also get a sneak peek at performance tuning and DAX query optimization using DAX studio and power BI's performance analyzer tool.

The syllabus

Getting Started

  • Course Structure & Outline
  • Read Me: Important Notes For New Students
  • Download: Course Resources
  • Setting Expectations
  • Helpful Resources

Prerequisite Skills Review

  • Introduction
  • Data Modeling Fundamentals
  • Basic DAX Review
  • Quiz: Prerequisite Skills Review

Introducing the Course Project

  • Introducing the Course Project
  • Note: Power Bi Options & Settings
  • Maven Roasters Data Model Setup
  • Assignment: Getting Familiar With The Data Model

The DAX Engines

  • Introduction
  • DAX Formula & Storage Engines
  • DAX Query Evaluation In Depth
  • Data & Storage Types
  • VertiPaq Columnar Data Structure
  • VertiPaq Compression & Encoding
  • Value Encoding
  • Hash Encoding
  • Run Length Encoding
  • VertiPaq Relationships
  • Summary: DAX Engines
  • Quiz: The DAX Engines

Tips & Best Practices

  • Introduction
  • DAX Shortcuts
  • Formatting Best Practices
  • DAX Evaluation Order
  • Commenting Your Code
  • Pro Tip: Dedicated Measure Table
  • Error Handling
  • Creating & Using DAX Variables
  • Variable Evaluation Order
  • Pro Tip: Using Variables To Test & Debug Dax
  • Quiz: Tips & Best Practices

Scalar Functions

  • Introduction
  • Common Scalar Functions
  • Aggregation Functions
  • Pro Tip: Sum & Sumx
  • Rounding Functions
  • Assignment: Rounding Functions
  • Solution: Rounding Functions
  • Information Functions
  • Conversion Functions
  • Assignment: Conversion Functions
  • Solution: Conversion Functions
  • Logical Functions: SWITCH
  • Logical Functions: COALESCE
  • Assignment: Logical Functions
  • Solution: Logical Functions
  • Quiz: Scalar Functions

Advanced Calculate

  • Introduction
  • Expanded Tables
  • Context Transition
  • Evaluation Order
  • CALCULATE Modifiers
  • REMOVEFILTERS
  • KEEPFILTERS
  • Assignment: Advanced CALCULATE
  • Solution: Advanced CALCULATE
  • Pro Tip: Common CALCULATE Patterns
  • Quiz: Advanced CALCULATE

Table & Filter Functions

  • Introduction
  • Common Table & Filter Functions
  • Review: Calculated Tables
  • DISTINCT
  • VALUES
  • Assignment: VALUES & DISTINCT
  • Solution: VALUES & DISTINCT
  • SELECTEDVALUE
  • ALLEXCEPT
  • Assignment: ALLEXCEPT
  • Solution: ALLEXCEPT
  • ALLSELECTED
  • ASSIGNMENT: ALLSELECTED
  • Solution: ALLSELECTED
  • SELECTCOLUMNS
  • ADDCOLUMNS
  • SUMMARIZE
  • Assignment: SUMMARIZE
  • Solution: SUMMARIZE
  • Generating New Data
  • ROW
  • DATATABLE
  • GENERATESERIES
  • The Table Constructor
  • Assignment: Generating Data
  • Solution: Generating Data
  • Quiz: Table & Filter Functions

Calculated Table Joins

  • Introduction
  • CROSSJOIN
  • UNION
  • EXCEPT
  • INTERSECT
  • Assignment: Calculated Table Joins
  • Solution: Calculated Table Joins
  • Quiz: Calculated Table Joins

Relationship Functions

  • Introduction
  • Physical vs. Virtual Relationships
  • RELATED
  • RELATEDTABLE
  • Assignment: RELATED & RELATEDTABLE
  • SOLUTION: RELATED & RELATEDTABLE
  • USERELATIONSHIPS
  • CROSSFILTER
  • Assignment: CROSSFILTER
  • Solution: CROSSFILTER
  • TREATAS
  • Assignment: Sales Targets (TREATAS)
  • Solution: Sales Targets (TREATAS)
  • Quiz: Relationship Functions

Iterator Functions

  • Introduction
  • Review: Basic Iterators
  • Iterator Cardinality
  • CONCATENATEX
  • Pro Tip: Adding Dynamic Labels
  • Assignment: CONCATENATEX
  • Solution: CONCATENATEX
  • AVERAGEX
  • Pro Tip: Moving Averages
  • Assignment: Moving Averages
  • Solution: Moving Averages
  • RANKX
  • Assignment: RANKX
  • Solution: RANKX
  • Quiz: Iterator Functions

Advanced Time Intelligence

  • Introduction
  • Automatic Date Tables
  • Date Table Requirements
  • Calendar
  • CALENDARAUTO
  • Pro Tip: Building a Reusable Date Table
  • Date Formatting
  • Assignment: Date Formatting
  • Solution: Date Formatting
  • Common Time Intelligence Functions
  • PARALLELPERIOD
  • PREVIOUSQUARTER
  • SAMEPERIODLASTYEAR
  • Assignment: Time Periods
  • Solution: Time Periods
  • Week-based Calculations
  • Previous Fiscal Week
  • Fiscal Period to Date
  • Fiscal Previous Period
  • Assignment: 4-5-4 Calendar
  • Solution: 4-5-4 Calendar
  • Quiz: Advanced Time Intelligence

Sneak Peek: Performance Tuning

  • Introduction
  • Power BI Performance Analyzer
  • PRO TIP: Copy Query
  • DAX Studio
  • DAX Optimization Workflow

Wrapping Up

  • Bonus Lecture: More from Maven

Instructors

Mr Aaron Parry
Trainer
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books