DAX IN POWER BI PART I

DAX IN POWER BI PART I

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

Power BI Training: Unlocking Data Mastery with DAX

Are you ready to supercharge your Power BI training experience? Welcome to the world of Power BI training, where we delve into the art of Data Analysis Expressions (DAX) in the context of Power BI. In our dynamic ‘DAX in Power BI Part I’ course, we empower you with the knowledge and tools to harness the full potential of your data.

What You'll Learn

In this 1-day instructor-led course, you’ll master the intricacies of Power BI formulas. From understanding data types and calculated columns to unleashing the power of evaluation contexts and time intelligence functions, you’ll gain a comprehensive understanding of how to transform data into actionable insights. Whether you’re a Sales Executive, Business Analyst, Project Manager, or Financial Executive, this course is designed to elevate your analytical prowess with specialized Power BI training.

Our Teaching Approach

Our training methodology combines interactive lectures, PowerPoint presentations, lively discussions, and hands-on exercises, all tailored to enhance your Power BI training journey. We don’t just teach concepts; we help you apply them in real-world scenarios. By the end of the course, you’ll be equipped to create impressive presentations, perform calculations, work with tables, and handle data with confidence. Don’t miss out on the opportunity to become a data master. Join us for ‘DAX in Power BI Part I’ and embark on your journey to data excellence.

Unleash the power of data today with our specialized Power BI training!

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

  • 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 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

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

  • Getting Started with Microsoft Excel 2019, Identify the Elements, and Interface of Excel
  • Performing Calculation, Basic Formula and Functions
  • Modify worksheet & Formatting Worksheet
  • Printing and managing large workbook

Outlines

  • What is DAX?
  • DAX data types
  • Calculated columns
  • Measures
  • Aggregation functions
  • Counting values
  • Conditional functions
  • Handling errors
  • Using variables
  • Mathematical functions
  • Relational functions
  • Introduction to table functions
  • Filtering a table
  • Ignoring filters
  • Mixing filters
  • DISTINCT Function
  • How many values for a column?
  • ALLSELECTED function
  • RELATEDTABLE function
  • Tables and relationships
  • Tables with one row and one column
  • Table variables  
  • Introduction to evaluation contexts
  • Filter context
  • Row context
  • Context errors
  • Filtering a table
  • Using RELATED in a row context
  • Ranking by price
  • Evaluation contexts and relationships
  • Filters and relationships
  • Introduction to CALCULATE function
  • CALCULATE function examples
  • CALCULATE function recap
  • What is a filter context?
  • KEEPFILTERS function
  • CALCULATE operators
  • Use one column only in a compact syntax
  • Variables and evaluation contexts   
  • CALCULATE modifiers
  • USERELATIONSHIP function
  • CROSSFILTER function
  • ALL function
  • ALLSELECTED function
  • KEEPFILTERS function
  • Context transition
  • Circular dependency
  • CALCULATE execution order
  • Working with iterators
  • MINX and MAXX functions
  • Useful iterators
  • RANKX function
  • ISINSCOPE function
  • Introduction to date tables
  • Auto Date/Time
  • CALENDARAUTO function
  • Mark as date table
  • Using multiple dates
  • What is time intelligence?
  • Time intelligence functions
  • DATEADD function
  • DATESINPERIOD function
  • Running total
  • Mixing time intelligence functions
  • Semi-additive measures
  • Calculation over weeks
  • What are hierarchies?
  • FILTER and CROSSFILTER function
  • Percentages over hierarchies
  • Parent-child hierarchies

Trainers

Reviews

Interested In

DAX IN POWER BI PART I

Starting From
RM500
Intake Date
25 MAR 2024
,
29 MAY 2024
,
29 JULY 2024
,
23 SEPT 2024
,
13 NOV 2024
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 I
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. *