Dax In Power BI Part II | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Dax In Power BI Part II

Location

Format What’s this?
Starting From
RM 500.00
  1. 1 Day with 08 hours per day
  1. Tue 13 Sep 09:00 - Tue 13 Sep 17:00
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
Starting From
RM 500
  1. 1 Days
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy

 

 

 

Thank You

Our learning consultant will get back to you in 1 business day

Dax In Power BI Part II

WHAT YOU WILL LEARN

DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models in Power BI. Learning how to create effective DAX formulas will help you get the most out of your data.

WHEN TO USE
• 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

AUDIENCE

• Sales Executive / Managers

• Business Analysist

• Resource Planning Team

• Project Managers

• Purchasing Manager

• Financial Executive / Managers


PREREQUISITES

• Attended PART I

• Familiar with creating formulas in Microsoft Excel

• Import data from various source into Power BI

• Understand relationship between tables

• Creating visual reports in Power BI


METHODOLOGY

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

Expand All

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


Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Course Reviews

No Remarks

0

0 Ratings