IT and Computing > Dax in Power BI Part 2

Dax in Power BI Part 2

Course Objectives

being able to select, join, filter data in a dynamic way
create smarter calculated columns and/or measures by which you can limit the data the dashboard has to fetch and visualize
shows a cumulative growth in value overtime
compare sales in a date range to another date range

Target Audience

Sales Executive / Managers
Business Analysist
Resource Planning Team
Project Managers
Purchasing Manager
Financial Executive / Managers

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Course Modules

Module 10: Data Lineage and TREATAS

What is data lineage?
TREATAS function

Module 11: Expanded Tables

Filters are tables!
Difference between base tables and expanded tables
Filtering a column

Module 12: Arbitrarily Shaped Filters

What are arbitrarily shaped filters?
Example of an arbitrarily shaped filter

Module 13: ALLSELECTED and Shadow Filter Contexts

ALLSELECTED function revisited
Shadow filter contexts

Module 14: Segmentation

Static segmentation
Circular dependency in calculated tables
Dynamic segmentation

Module 15: Many-to-many Relationships

How to handle many-to-many relationships
Bidirectional filtering
Expanded table filtering
Comparison of the different techniques

Module 16: Ambiguity and Bidirectional Filters

Understanding ambiguity

Module 17: Relationships at Different Granularities

Working at different granularity
Using TREATAS function
Calculated tables to slice dimensions
Leveraging weak relationships
Scenario recap
Checking granularity in the report
Hiding or reallocating

Module 18: Querying with DAX

Working with tables and queries
EVALUATE syntax
CALCULATETABLE function
SELECTCOLUMNS function
SUMMARIZE function
SUMMARIZECOLUMNS function
CROSSJOIN function
TOPN and GENERATE functions
ROW and DATATABLE functions
Tables and relationships
UNION, INTERSECT and EXCEPT functions
GROUPBY functions
Query measures

Get To Know The Trainer

Trainer Lim

Lim has been working in the IT industry for the past 20 years. He leads, plans and supports a functionally organized, technically oriented team and environment with a wide variety of technical activities and service operations.He is good in developing and implementing IT initiatives for regional service operation activities and actively participates in global projects to align corporate/regional direction and IT standard according to ITIL operational framework and software development.

VIEW PROFILE

Trainer CK

4.5

CK has been involved in Microsoft Office Consulting for more than 15 years with the intention of helping friends and working adults to reach their full capability which in return will increase their work productivity. Throughout his many years of working experience using Microsoft Office Applications, he participated with various projects involving Engineering Data Analysis, A Complete System for Employees such as Leave Application, Petty Cash Claim, Arranging Schedule and so on with Programming using VBA Programming.

VIEW PROFILE

Trainer P.L

4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

VIEW PROFILE

View more trainers