Course description
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.
Upcoming start dates
Who should attend?
Prerequisites
Knowledge of MS Excel Functions is a plus
Training content
- Introduction to DAX (1 hour)
- Aggregation Functions (2 hours)
- Date & Time Functions (2 hours)
- Filter Functions (3 hours)
- Logical Functions (2 hours)
- Text Functions (2 hour)
- Time Intelligence Functions (3 hours)
Total: 15 hours
Certification / Credits
Objectives
Participants are expected to demonstrate the application of using DAX for the analysis of business data, create dashboards in PowerBI, and complete tasks independently.
Quick stats about Luxoft Training Center?
More than 200 training courses
Conducted over 1,500 training sessions
Customized training solutions for business
Contact this provider
Luxoft Training Center
Luxoft Training Center — an essential part of the global technology leader, Luxoft, a DXC Technology Company. We play a pivotal role in propelling B2B businesses forward by delivering customized training solutions. Emphasizing the significance of learning and employee development,...