$300

Microsoft DAX training in JOHOR BAHRU,Malaysia

Event Information

Share this event

Date and Time

Refund Policy

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Event description
Microsoft DAX training in JOHOR BAHRU

About this Event

Power BI Guru E Solutions Pvt Ltd” is considered to be the Best Advanced Training institute in JOHOR BAHRU that offers quality and Instructor-led classes to all the intended audience. Domain Expertise mainly helps the audience to leverage practical knowledge skills in Data Modelling to solve complex business issues with an optimized solution.

By the end of SSAS and DAX Course, aspirants can be able to crack the interviews for Data Modelling Analyst

COURSE CONTENT :

DAX (Data Analysis Expressions)

Purpose of Data Analysis Expressions (DAX)

Scope of Usage with DAX. Usability Options

DAX Context : Row Context and Filter Context

DAX Entities : Calculated Columns and Measures

DAX Data Types : Numeric, Boolean, Variant, Currency

DAX Operators & Symbols. Usage. Operator Priority

Parenthesis, Comparison, Arithmetic, Text, Logic

DAX Functions and Types: Table Valued Functions

Filter, Aggregation and Time Intelligence Functions

Information Functions, Logical, Parent-Child Functions

Statistical and Text Functions. Formulas and Queries

Syntax Requirements with DAX.

Naming Conventions and DAX Format Representation

Working with Special Characters in Table Names

Attribute / Column Scope with DAX – Examples

Measure / Column Scope with DAX – Examples

YTD, QTD, MTD Calculations with DAX

Time Intelligence Functions with DAX

DATESYTD, DATESQTD, DATESMTD

ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH

FIRSTDATE, LASTDATE, DATESBETWEEN

CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR

SAMEPERIOD and PREVIOUSMONTH,QUARTER

Share with friends

Date and Time

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved