DAX IN POWER BI PART II

DAX IN POWER BI PART II

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

Course Details

Duration: 1 Day; Instructor-led

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.

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.

Course Objectives

Upon completion of this program, participants should be able to :

  • Enhance your productivity using ribbons in PowerPoint
  • Move beyond default PowerPoint templates
  • Create impressive presentations using templates

Outlines

  • What is data lineage?
  • TREATAS function
  • Filters are tables!
  • Difference between base tables and expanded tables
  • Filtering a column
  • What are arbitrarily shaped filters?  
  • Example of an arbitrarily shaped filter
  • ALLSELECTED function revisited
  • Shadow filter contexts
  • Static segmentation
  • Circular dependency in calculated tables
  • Dynamic segmentation
  • How to handle many-to-many relationships
  • Bidirectional filtering
  • Expanded table filtering
  • Comparison of the different techniques
  • 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
  • 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

Trainers

Reviews

Interested In

DAX IN POWER BI PART II

Starting From
RM500
Intake Date
17 NOV 2023, 22 SEPT 2023
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: DAX IN POWER BI PART II
Duration: 1 Day
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *