DAX in a Day
Oct 10th
This course has been designed specifically for experienced model developers.
Overview
This course has been designed specifically for experienced model developers. We recommend that attendees have prior experience working with Power BI Desktop to create data models.
During this course you will review:
- Writing DAX formulas.
- Defining calculated tables and columns.
- Defining measures.
- Using DAX iterator functions.
- Modifying filter context.
- Using DAX time intelligence functions.
After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns.
BOOK YOUR COURSE
AUD 750
This is for 1 person per day.
We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please send us an enquiry.
Key Topics
Within 1 day, you will have a chance to go through 7 important modules below:
What Is Included
Students will have access to their own desk, chair, and space in a classroom during the course.
Each participant is required to bring his or her own laptop for exercises (Hands-on Lab).
Peter O’Gorman – Head of Training
Peter has over 19 years working with data and business intelligence eco-systems serves as Managing Consultant for Cloudstreet in Darwin. He is a certified Microsoft Certified Trainer, Microsoft Certified Solution Associate, Certified Data Vault 2 Practitioner and Certified Prince 2 Foundation. Having used data-driven & AI ecosystems to solve the repetitive and mundane, he leads Innovation and Learning for Cloudstreet Consulting.
Coffee breaks and a light lunch are included every day. When registering, please communicate any dietary restrictions.
Each participant will receive materials for 1 day training, including printed workbooks and online labs.
Each attendee will receive a PDF certificate by email after completing the course.
Target Audience
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.
This course is also targeted toward those individuals who develop reports that visualise data from the data platform technologies that exist both in the cloud and on-premises.
Prerequisites
DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience.
Skills Gained
After completing this training, the attendees should be:
- Able to work with Data Analysis Expressions (DAX),
- Perform calculations and define common business calculations for use in reports
- Address performance and functionality concerns.
NT Dataset
You will connect real public Crocodile Captures data in the Excel file, select the tables you want to use, and import them for transformation. Public and organisational datasets will often require understanding and shaping in order to make for interesting and useful analytics.
Power Query
Skills in Power Query are essential in being able to take charge of the clean-up and perhaps re-organisation of your input datasets. While you wait for the data owner to clean-up the data or provide it in another format, Power Query gives you the power to take this into your own hands and you will be surprised what you can do.
Offering NT’s Leading Microsoft Training Resources
Our trainees say
Your commitment, passion, and delivery were really amazing. We had a great start and the speed as well as intensity with which we rolled out globally over 3 years was unbelievable.
“Joining Cloudstreet Consulting gives me the opportunity and confidence to apply all the knowledge I had gained from school towards the IT industry”.
Improve the management of your company and save money by making wiser decisions. Discover all the services we offer.