Search results for:
No result found! Try with different keywords!

Microsoft dax training in Chennai ,India

Nov 12, 2019 - Nov 22, 2019

Microsoft dax training in Chennai ,India

Time Tue Nov 12 2019 at 09:00 am to Fri Nov 22 2019 at 06:00 pm

online, Chennai

USD 300 Tickets

Microsoft dax training in Chennai ,India


Power BI Guru E Solutions Pvt Ltd” is considered to be the Best Advanced Training institute in Chennai 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

Report a problem

Date & Time

Tue Nov 12 2019 at 09:00 am to Fri Nov 22 2019 at 06:00 pm

Location

online, Chennai