Search courses 👉
Professional Course

MS Power BI: Basics of DAX

Length
15 hours
Price
400 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
Length
15 hours
Price
400 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
This provider usually responds within 48 hours 👍

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

1 start date available

Start Anytime!

  • Self-paced Online
  • Online
  • English

Who should attend?

Prerequisites

Knowledge of MS Excel Functions is a plus

Training content

  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

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

Contact course provider

Fill out your details to find out more about MS Power BI: Basics of DAX.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Luxoft Training Center
Warsaw Spire, plac Europejski 1
00-844 Warsaw

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,...

Read more and show all training delivered by this supplier

Ads