- Courses/
- Microsoft Power BI/
- DAX Introduction/
Microsoft DAX Introduction Training Courses
DAX Introduction
Master DAX in Power BI with our Future Savvy 2-day training course. Focused on DAX language essentials, you'll learn to create advanced data models and reports. You will understand basic functions, relationship functions, and time intelligence in DAX for effective business analysis and reporting. This course is ideal for enhancing data skills in Power BI.
Master DAX in Power BI with our Future Savvy 2-day training course. Focused on DAX language essentials, you'll learn to create advanced data models and reports. You will understand basic functions, relationship functions, and time intelligence in DAX for effective business analysis and reporting. This course is ideal for enhancing data skills in Power BI.
Virtually Online Or On-Site
2 Days
Next Running:
28th November
UPCOMING COURSES
Course Information
Want to learn DAX language in Microsoft Power BI? We can help you learn DAX, in just 2-days so you can start using Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services.
DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. Learning how to use it unlocks a world of data applications and formulas for advanced business reporting.
The Future Savvy 2-day Microsoft DAX Introduction course will show you how to “speak” the DAX language, commonly used in Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. Our hands-on, instructor-led training will help users of Power BI, Power Pivot, and Analysis Services developers that want to learn and master the DAX language to get up and running fast.
Whether you choose our in-person training or virtual DAX training, after 2 days, you’ll be confident using all the features of the DAX language, and be able to write formulas for common and advanced business scenarios.
Course requirements
We recommend that students taking our DAX training course are competent Microsoft Excel users. You don’t need any experience of using DAX but we recommend that you attend our 2-day Microsoft Power BI Introduction course prior to taking this course.
What you will learn
With this Microsoft DAX Introduction course, you will be able to:
- Introduction to DAX
- Basic DAX functions, Relationship functions
- Time Intelligence functions
- and so much more
By the end of the 2-day instructor-led Microsoft DAX Introduction course for Power BI, you’ll go from complete DAX beginner to pro.
All with our 100% Money-Back Guarantee and Unlimited Email Support.
1
Introduction to DAX
- What is DAX?
- Naming Requirements
2
DAX Syntax
- Data Types
- DAX Code Formatting
- Rules & Guidelines
3
Basic DAX Functions
- Basic Aggregators
- Basic Iterators
- COUNTROWS Function
- DISTINCTCOUNT Function
4
Logical Functions
- IF Function
- SWITCH Function
- AND Function
- OR Function
- IFERROR Function
5
Filter Functions
- Introduction Evaluation, Row & Filter contexts
- FILTER Function
- CALCULATETABLE Function
- CALCULATE Function
6
Date & Time Functions
- CALENDAR Function
- CALENDARAUTO() Function
- DATE Function
- DATEVALUE Function
- YEAR Function
- MONTH Function
- WEEKDAY Function
- WEEKNUM Function
- FORMAT Function
- EDATE Function
- NOW Function
- TODAY() Function
- DATEDIFF Function
7
Information Functions
- Information Functions Overview
- HASONEVALUE Function
- ISFILTERED Function
- ISINSCOPE Function
- USERNAME Function
- USERPRINCIPALNAME Function
8
Relationship Functions
- RELATED Function
- RELATEDTABLE Function
- USERELATIONSHIP Function
9
Time-Intelligence Functions
- SAMEPERIODLASTYEAR Function
- DATEADD Function
- LASTDATE Function
- DATESMTD/DATESQTD/DATESYTD Functions
- TOTALMTD, TOTALQTD, TOTALYTD Functions
- Other Time Intelligence Semi-Additive Measures
10
Other Useful Functions
- DIVIDE Function
- RANKX Function
- ALL Function
- ALLSELECTED Function
- VALUES Function
- SUMMARIZE Function
- DATATABLE Function
11
Understand the Use of Parameter Tables
- What-If Parameter
- What if Parameter in Use
12
Creating Measures Using Variables
13
The DAX Studio Application Demonstration
- What is DAX Studio
- Format DAX Calculations in DAX Studio
- Evaluate a Calculation in DAX Studio
Private courses.
We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!
Tailored
Post Course Support
Cost Effective
Reviews
- Microsoft Power BI
Power BI Introduction
Kickstart your journey with Power BI in our 2-day beginner course at Future Savvy. Learn to analyse data and create striking visualisations using Power BI. Master skills like working with desktop files, data, visualisations, and connecting data sources. This course quickly turns beginners into capable Power BI users, ready to enhance their work with powerful data insights.
Virtually Online Or On-Site
2 Days
- Microsoft Power BI
Power BI Intermediate
This course is designed for existing users of Power BI user who wish to develop their skills in analysing and querying data. Students will learn how to use Power BI power tools for slicing, querying, shaping and drilling down in to data. Participants will get hands-on experience learning these skills and concepts using example data based on real world scenarios.
Virtually Online Or On-Site
1 Days
- Microsoft Power BI
Power BI Service Introduction
Master Power BI Service in a day: Navigate the interface, import Excel data, connect to databases, refresh data, and create reports with KPIs. Learn dashboard configuration, sharing, and Power BI Mobile use for on-the-go analysis. Boost your data visualisation and intelligence skills.
Virtually Online Or On-Site
1 Days
© 2024 - All Rights Reserved.
All trademarks are owned by their respective owners.
