Reza Rad
Reza Rad is an author, trainer, speaker, and consultant. He has been a Microsoft Data Platform MVP for 7 years, specializing in Microsoft Business Intelligence and data movement. Reza has worked with Microsoft BI technologies more than 15 years. He is an MCP, an MCT, and co-leader of the New Zealand Business Intelligence Users Group. He has previously published, and is currently writing, several books. You can find his technical articles on his blog at http://www.radacad.comHe is author of books: SQL Server Integration Services, Microsoft SQL Server 2014/16 BI, Power BI online book from rookie to rock star, and author of Channel 9 SSIS tutorial video series. he speaks in many conferences listed on his website's presentation section.

Course Description
This course is module 3 of the Power BI from Rookie to Rock Star course. In this module, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and also in SSAS Tabular and PowerPivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real world challenges of a BI solution.

Course Content

  • Power BI Modeling 101
    • Relationship in Power BI
    • Relationship based on multiple Columns
    • Role Playing Dimension
    • Formatting
    • Hide/Unhide
    • Hierarchy
    • Basic Calculated Column and Measure
    • Sort by Column
  • Introduction to DAX
    • Syntax of DAX
    • Naming in DAX
    • Logical Operations
    • Data Types in Power BI Model
    • Overview of Functions
    • Variables
  • Functions in DAX in Details
    • Text Functions
    • Information Functions
    • Logical Functions
    • Date and Time Functions
    • Aggregation Functions
  • Filter, Value, and Relationship Functions
    • ALL
    • Examples of using ALL function
    • Filter Function
    • Related
    • RelatedTable
  • Evaluation Contexts
    • Row Context
    • Filter Context
    • Exception for Row Context
    • Exception for Filter Context
    • Calculate Function
  • Time Intelligence Functions
    • Year to Date, Quarter to Date
    • Fiscal Year to Date
      Same Period Last Year
    • Running Total
    • Rolling 12 Month Sales
    • Average 12 Month Sales
    • Rolling 6 Months
    • Flexible banding
  • Calculated Tables
    • Role Playing Dimension
    • Top 10 Customers
    • More Scenarios of Using Calculated Tables
    • Performance Consideration
  • Best Practices Tips and Tricks
    • Solving DAX Now and Today Time zone Issue
    • Modeling Best Practices
    • Advanced Time Intelligence
    • Advanced Relationship in DAX
    • Hierarchies in DAX