IT and Computing > Data Modeling and Calculation in Power Bi

Data Modeling and Calculation in Power Bi

Course Objectives

User has an intermediate knowledge of Microsoft Power BI Desktop

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

Lesson 1 : Introduction to DAX

What is DAX
Component of DAX
- Functions
- Operators
- Values
Types of Calculation

Lesson 2 : Aggregation Functions

Implicit Measure with
- SUM
- COUNT / COUNT (DISTINCT)
- AVERAGE
- MAX

Create Measure with Aggregation Function
- SUMX & FILTER
- COUNTX & FILTER
- AVERAGEX & FILTER
- COUNTROWS & FILTER
- COUNTBLANK & FILTER

Lesson 3 : Filter Functions

Measure with
- CALCULATE
- ALL
- ALLCROSSFILTERED
- ALLSELECTED
- ALLEXCEPT
- KEEPFILTERS
- REMOVEFILTERS
- RUNNING SUM
- ORDERBY

Lesson 4 : Logical Functions

Column with
- IF
- SWITCH
Measure with
- IF
- RANKX

Lesson 5 : Information Functions

Measure with
- ISINSCOPE
- HASONEVALUE

Lesson 6 : Relationship Functions

Measure with
- CROSSFILTER
- USERELATIONSHIP
Column with
- RELATED
- RELATEDTABLE

Lesson 7 : Table Manipulation Functions

Table with
- ADDCOLUMN
- CROSSJOIN
- EXCEPT
- UNION
- INTERSECT
- SUMMARIZE
- SELECTCOLUMNS
- CALCULATETABLE
- GROUPBY
- DISTINCT

Measure with
- TOPN

Lesson 8 : Text Functions

Column with
- CONCATENATE
- SUBSTITUTE

Lesson 9 : Time Intelligence Functions

Table with
- CALENDAR
- CALENDARAUTO
Column with
- DATEADD
- DATEDIFF
- NETWORKDAYS
- WEEKNUM
- YEAR
- MONTH
- FORMAT
Measure with
- PREVIOUSDAY / PREVIOUSMONTH / PREVIOUSQURTER
- SAMEPERIODLASTYEAR
- PARALLELPERIOD
- DATESINPERIOD
- TOTALMTD / TOTALQTD / TOTALYTD
- DATESMTD / DATESQTD / DATESYTD

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