Introduction to DAX for Power BI

تعلّم DAX، لغة الصيغ في Power BI. خلال يومين تفهم قواعدها وأنواع بياناتها، وتنشئ الأعمدة المحسوبة والمقاييس والجداول، وتتقن مفهوم السياق، وتكتب حسابات أكثر تقدّماً.

يومانتأسيسي6 وحدات

سجّل أو استفسر ←اسأل عبر واتساب

نظرة عامة

ما ستتعلّمه

المحتوى التقني أدناه معروضٌ باللغة الإنجليزية كما ورد في منهاج الدورة، حفاظاً على دقّة المصطلحات.

Describe DAX syntax, data types, and errors
Use DAX to create calculated columns, measures, and tables
Explain how DAX calculations are evaluated, along with the differences between row context and filter context
Configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.
Create calculated columns and measures that use data from multiple tables in the data model
Write measures that handle error conditions gracefully
Use DAX to enhance the Power BI user experience
Use DAX Studio to connect to a Power BI data model and execute simple queries

المنهاج

6 وحدات

Introduction to DAX
Creating objects with DAX
Context and rules of evaluation
Variables, comments, and testing

Getting started with calculations
Implicit measures and adding quick measures
Working with DAX data types and basic math
Using logic in calculations: IF(), nested IF(), SWITCH(), advanced SWITCH(), logical operators and functions (OR(), AND(), NOT())
Aggregating and summarizing data with the SUM() function

Understanding context, data modeling basics, and dimensional modeling
Relationships and their effect on the evaluation context
Getting data from other tables: using RELATED(), RELATEDTABLE(), and looking up data without relationships
Modifying context using CALCULATE()