[vc_row][vc_column][vc_tta_tabs][vc_tta_section tab_id=”1615816245393-a7abddab-ee55″ title=”DAX”][vc_column_text]DAX  مخفف Data Analysis Expression  می باشد. DAX  یک زبان برنامه نویسی نیست و درواقع یک زبان فرمول نویسی است و در ابزار های متفاوت بصری سازی و BI استفاده می شوند. و یادگیری این زبان برای انجام راحت تر و سریع تر مدل سازی بسیار ضروری می باشد

هوش تجاری کیسان[/vc_column_text][/vc_tta_section][vc_tta_section tab_id=”1615816245517-70407e1b-a3db” title=”سرفصل و اهداف دوره”][vc_column_text]

سرفصل و اهداف دوره:طراحی Cube/ SSAS/ MDX

DAX EXPRESSIONS – Level 1

* Purpose of Data Analysis Expresssions (DAX)

* Scope of Usage with DAX. Usabilty Options

* DAX Context : Row Context and Filter Context

* DAX Entities : Calculated Columns and Measures

* DAX Data Types : Numeric, Boolean, Variant, Currency

* Datetime Data Tye with DAX. Comparison with Excel

* DAX Operators & Symbols. Usage. Operator Priority

* Parenthesis, Comparison, Arthmetic, 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. Differences with Excel

* 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

DAX EXPRESSIONS – Level 2

* YTD, QTD, MTD Calculations with DAX

* DAX Calculations and Measures

* Using TOPN, RANKX, RANK.EQ

* Computations using STDEV & VAR

* SAMPLE Function, COUNTALL, ISERROR

* ISTEXT, DATEFORMAT, TIMEFORMAT

* Time Intelligence Functions with DAX

* Data Analysis Expressions and Functions

* DATESYTD, DATESQTD, DATESMTD

* ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH

* FIRSTDATE, LASTDATE, DATESBETWEEN

* CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR

* SAMEPERIOD and PREVIOUSMONTH,QUARTER

* KPIs with DAX. Vertipaq Queries in DAX

* IF..ELSEIF.. Conditions with DAX

* Slicing and Dicing Options with Columns, Measures

* DAX for Query Extraction, Data Mashup Operations

* Calcualted COlumns and Calculated Measures with DAX[/vc_column_text][/vc_tta_section][/vc_tta_tabs][/vc_column][/vc_row]