- Course Structure & Outline
- Read Me: Important Notes For New Students
- Download: Course Resources
- Setting Expectations
- Helpful Resources
Online
₹ 549 3,499
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.
Advanced DAX for Microsoft Power BI Desktop 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.
Advanced DAX for Microsoft Power BI Desktop 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
certificate availability
certificate providing authority
What you will learn
After completing the Advanced DAX for Microsoft Power BI Desktop 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
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