Press esc to close
Press esc to close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please log a ticket and choose the category ‘booking change’
Back to Course Information
Module 1: What is DAX?
Module 2: DAX Variables and Formatting
Module 3: Building Data Models
Module 4: Working with DAX in Power BI, Excel, and SSAS
Module 5: Progressive DAX Syntax and Functions
Module 6: Table Functions
Module 7: Date, Time, and Time Intelligence Functions
Module 8: Filter Functions
Module 9: Optimising Data Model
Module 10: Optimising DAX Queries
There are no formal prerequisites to attend this DAX Training course.
This 1-Day DAX Training course is ideal for anyone who wants to gain in-depth knowledge of Data Analysis Expressions (DAX). However, this course will be more beneficial for professionals working in Data Analysis and Analytics profession.
Data Analysis Expressions (DAX) is a formula language used to determine custom calculations for calculated columns and measures. It is specifically used for the handling of data models through the use of formulas and expressions. DAX is used in many Microsoft Products, including Microsoft Analysis Services, Microsoft Power BI, and Microsoft Power Pivot for Excel. DAX helps its users to enhance their data research capabilities and become more productive. The use of DAX helps organisations to gain benefits like improved performance, readability, simplifies the debugging process, and reduces complexity. Learning DAX will help individuals enhance their data analysis skills and gain more opportunities to work on lucrative jobs roles in prominent organisations.
This 1-day DAX Training course covers all the essential topics by which delegates can become fully familiar with the Data Analysis Expressions (DAX). During this training, delegates will learn about data types and operators, formatting DAX code, progressive DAX syntax and functions, etc. They will also learn about debugging errors in DAX code, DAX functions, date and time functions, working with percentiles, etc. Our highly professional trainer with years of experience in teaching such courses will conduct this course and help delegates get a complete understanding of using DAX.
This training will cover various essential topics, such as:
After attending this DAX Training course, delegates will be able to work with DAX patterns and optimise the data model. They will also be able to monitor performance with DAX studio and efficiently optimise DAX queries.
Why choose us
Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.
Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.
This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.
All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.
We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible
We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience
Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!
This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.
Our courses can be adapted to meet your individual project or business requirements regardless of scope.
Cut unnecessary costs and focus your entire budget on what really matters, the training.
This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.
Keep track of your employees’ progression and performance in your own workspace.
Course was run very smoothly, Richard our trainer was extremely knowledgeable and delivered the course in a succinct fashion with a twist of humour thrown in.
The course was great and the so was the trainer - brilliantly delivered and I would certainly recommend this course to my colleagues. Thanks to Richard for a great course and delivering it a tough environment virtually.
Richard was very knowledgeable and explained well
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
Introduction to SQLAUD2995
Microsoft Power BI TrainingAUD2995
Total without package: AUD12980
Package price: AUD7795 (Save AUD5185)