Advertisement Close

Events

Microsoft DAX training in Lebanon,UAE

By: | posted on: Jun 8, 2020

Date/Time
Date(s) - 06/08/2020
6:00 pm

0
Add This to Your Calendar

Categories

Cost:
$300 USD
Contact Person:

Email:

Website:
https://www.eventbrite.com/e/microsoft-dax-training-in-lebanonuae-tickets-74083633141?aff=ebdssbonlinesearch
Phone:

Organization:
Power bi guru E-solution pvt ltd


6:00 PM IST

About this Event

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

Tickets

Map Unavailable