MS Power BI: Basics of DAX

Master the fundamentals of DAX (Data Analysis Expressions) with our comprehensive MS Power BI training. This course focuses on the principles of using basic DAX functions in Power BI to perform a wide range of calculations. Participants will gain a solid understanding of DAX, including aggregating, text, date & time, logical, filter, and time intelligence functions. Practical examples, calculations, and use cases are provided, along with hands-on tasks to reinforce learning.

• Introduction to DAX: Understand the basics of DAX, its role in Power BI, and how it is used to create custom calculations and measures.
• Aggregation Functions: Learn how to use DAX functions like SUM, AVERAGE, MIN, MAX, and COUNT to aggregate data and calculate totals across different dimensions.
• Date & Time Functions: Explore DAX functions such as DATE, TODAY, CALENDAR, and TIME to manipulate and analyze date and time-related data.
• Filter Functions: Understand DAX functions like FILTER, ALL, ALLEXCEPT, and VALUES to filter and manipulate data based on specific conditions.
• Logical Functions: Learn how to use DAX logical functions such as IF, AND, OR, and SWITCH to perform conditional logic operations in Power BI.
• Text Functions: Discover DAX functions like CONCATENATE, LEFT, RIGHT, and MID to manipulate text strings and perform text-related operations.
• Time Intelligence Functions: Explore DAX time intelligence functions such as SAMEPERIODLASTYEAR, DATESYTD, TOTALYTD, and DATEADD to perform calculations over time-based data.

By the end of this course, participants will:

• Gain a thorough understanding of DAX and its functions.
• Master the use of aggregating, text, date & time, logical, filter, and time intelligence functions.
• Apply DAX functions to create advanced calculations and measures in Power BI.
• Complete practical exercises and use cases to reinforce learning and proficiency.

Enhance your skills in using DAX functions within MS Power BI with our Basics of DAX course. This training is ideal for professionals who want to perform advanced data calculations and analysis in Power BI effectively.

Participants are expected to demonstrate the application of using DAX for the analysis of business data, create dashboards in PowerBI, and complete tasks independently.

1. Introduction to DAX (1 hour)
2. Aggregation Functions (2 hours)
3. Date & Time Functions (2 hours)
4. Filter Functions (3 hours)
5. Logical Functions (2 hours)
6. Text Functions (2 hour)
7. Time Intelligence Functions (3 hours)

Total: 15 hours