Power BI DAX Essentials Course
(4.9 out of 5) 439 Student Reviews
About the Course
This 2-Day course is designed to lay solid foundations before diving deep into complex DAX functions. This is achieved by focusing on 2 key elements i.e. engagement, and practicality. Participants will be spending their time writing hands-on DAX functions, looking at the result, discussing what works, and especially what does not work and WHY? Additionally, all the modules and concepts are reinforced by real-life, scenario-based examples to solidify the learnings.
After this course, participants should be able to write DAX expressions to address their specific business needs, leverage available resources to tackle complex problems, debug and optimize using available tools and the right techniques. Moreover, the entire course walks through a single data set so participants can concentrate on mastering the concepts rather than worrying about the specifics of the dataset.
Who should do this course?
This course is for business users (Finance, Marketing, Operations etc.) or SQL Server report creators who want to take their reports and dashboards to a next level by writing custom calculations using DAX functions to address specific business requirements.
Prerequisites
This DAX course is suitable for people who have either completed the Power BI essentials course or have a reasonable understanding of data modeling concepts. To benefit most from this course, basic knowledge in using Excel functions or SQL queries is recommended.
Course Details
$990 incl GST
- Duration:2 Days
- Max. Class Size:10
- Avg. Class Size:5
-
Study Mode:
Classroom Online Live
- Level:Advanced
- CPD Hours:12 hours
- Course Times: Classroom: 9.00am to 5.00pm approx(Local Time) Online Live: 9.00am to 5.00pm approx(AEST or AEDT)
- Download Course PDF
Course Dates
Looking for Power BI DAX Essentials dates?
There are currently no scheduled dates matching your selected filter, but we'd love to assist. Get in touch with our team to discuss your individual training needs or corporate group requirements, and we'll explore available options with you.
Course Units
⊕ Expand full topic list
Unit 1: Getting to know Data Analysis Expression (DAX) Language
- What is DAX?
- Understanding the Data types in DAX
- Understanding DAX Type Handling
- Understanding DAX Operator Overloading
- Learning DAX as Formula Language
- Vertipaq Engine in DAX
- Difference between DAX, EXCEL Functions and M
- Do's, Dont's and Best Practices in DAX
⊕ See more
Unit 2: Data Modelling Recap
- Fact vs Dimensions
- Understanding Schemas in Data Model
- Understanding Filter Propagation
- Understanding Data Denormalization
- Understanding Relationship Characteristics
⊕ See more
Unit 3: Calculated Columns and Measures
- Calculated Column and its Use Case
- When do Calculated Columns Fail
- Calculated Measure and its Use Case
- When to use Calculated Column vs Calculated Measure
⊕ See more
Unit 4: Basic DAX Functions
- Understanding Two Broad Categories of Functions in DAX
- Using SUM()
- Using DIVIDE()
- Using COUNT()
- Using DISTINCTCOUNT ()
- Finding Min, Max and Average
- Counting Rows
- Counting Blank Values
⊕ See more
Unit 5: Evaluation Contexts in DAX
- What are the Two Evaluation Contexts in DAX?
- What is Initial or Incoming Filter Context
- What is Row Context
- Filter Context vs Row Context
- Rules of Evaluation
⊕ See more
Unit 6: Table Functions
- Creating a Calculated Table
- Exploring Table Joins
- The Inner Join
- The Outer Join
- The Cross Join
- A Join on Unrelated Tables – TREATAS()
- Using GENERATE() for Joins
- Creating Summary Table for the Tequested Totals Using SUMMARIZE()
- Creating Summary Table Over a Set of Groups Using SUMMARIZECOLOUMNS()
- Improving TREATAS() using SUMMARIZE()
- Getting Top N rows of the Specified Table Using TOPN()
- Using VALUES()
- Using FILTER() as a Table Function
- Understanding Virtual Table Lineage
⊕ See more
Unit 7: Creating Date Table
- Creating Calendar Table using DAX
- Optimising Calendar Table using DAX
- Adding Date Columns
- Working with Fiscal Years
- Setting Sorting Options
⊕ See more
Unit 8: Basic Iterators
- Iterators vs. Normal Functions
- Using SUMX()
- Using COUNTX()
- Using AVERAGEX()
- Using MINX()
- Using MAXX()
⊕ See more
Unit 9: Variables in DAX
- Creating Variables
- Features of a Variable
- Location of Variable Evaluation
- Conditional Computations using Variables
- Increasing Code Readability
- Writing single and multi-line comments
⊕ See more
Unit 10: Advance Filtering in DAX
- Modification of Filter context using CALCULATE()
- Modification of multiple Filter using with CALCULATE()
- Mixing Filtering
- Using LOOKUPVALUE()
- Specifying the cross-filtering direction using CROSSFILTER()
- Activating Relationships with USERELATIONSHIP()
- Return all the rows in a table using All()
- Using ALLSELECTED()
- Using ALLEXCEPT()
- Modify how filters are applied using KEEPFILTERS()
- Using SELECTEDVALUE()
- Using CONCATENATEX()
⊕ See more
Unit 11: Context Transition
- Understanding Implicit Calculate in Measures
- Understanding Row to Filter Context transition
- Using CALCULATE() and CALCULATETABLE()
- Using EARIER() vs EARLIEST()
⊕ See more
Unit 12: Time Intellegence in DAX
- What is Time Intelligence
- Understanding Date table properties for Time Intelligence
- Aggregations Over Time
- Understanding Total Year till Date
- Understanding Month Till Date
- Understanding Quarter till Date
- Handling Fiscal Year
- Same Period Last Year
- Calculating Running Total
- Using Date Modifier DATESBETWEEN
- Shifting Forward/Backward in time using DATEADD()
- Using DATESINPERIOD()
- Using MAX or LASTDATE()
- Using FIRSTNONBLANK() and LASTNONBLANK()
- Working with Total Sales Rolling 90 Days
⊕ See more
Unit 13: Conditionals in DAX
- Using IF() statements
- Switching between Cases using SWITCH()
- Finding your Text
- What to do if your Text had One Value
- Concatenating Labels
- Using COALESCE()
⊕ See more
Unit 14: Hierarchies In DAX
- What are Hierarchies
- Understanding Parent-child Hierarchies
- Using Path Functions
⊕ See more
Unit 15: Other Functions
- Using RANKX()
- Understanding Dynamically controlling units
- Using COUNTA()
- Using MINA()
- Using MINAX()
⊕ See more
Unit 16: DAX Tools and Other Resources
- Understanding Common Errors and Causes
- Working with Error Debugging
- Understanding DAX Formatter
- Getting started with DAX Studio
- Downloading and Installing DAX Studio
- Connecting DAX Studio with Power BI
- Calculating Performance using Data Studio
- Understanding Power BI Helper
- Clearing the Cache
- Other DAX References
⊕ See more
Training Packages
Power BI Training Package
Related Courses
Student Reviews
FANTASTIC course, super informative and explanatory BUT very intensive - would recommend taking more breaks - especially towards the end of the second day - since some of the more technical code is covered, by my attention span is diminishing - BUT AWESOME content and great instructor
Great course. Learnt a lot about DAX and functions that you would encounter in the real world. Great explanation about everything and how to fundamentally understand what we're trying to do.
This was a great course and extremely well delivered. The course was well-structured and easy to follow, covering everything from fundamental concepts to more advanced calculations with practical, real-world examples. The content was presented in a logical sequence, the complex topics were broken down into smaller concepts made easy to follow. It was a bit fast paced considering the content that had to be covered. Adam was outstanding and very kind to answer all my requests and went out of the way to teach the hierarchal concepts. I would have liked to spend some more time doing a deep dive in filtering techniques and complex filter conditions across multiple columns. But I am aware that it would be challenging in the given timeframe. Overall a great course; I will happily recommend to anyone looking to improve their Power Bi skills.
Gordana has an excellent teaching style that makes this course a breeze to follow. The content can get tricky, but she is able to pace the class well enough so that no one falls behind.
Amazing PowerPoint slides and presentation of the concepts in a very structured manner. Gordana is very knowledgeable and easy to comprehend her teaching styles, and I have learned a lot through her.
Tons of good content which I will definitely use day to day. Adam is an excellent instructor - structured, clear, engaging, thorough and enthusiastic!
I found the course very informative and provided great insight into what DAX can do in Power BI. I found the instructor very helpful and happily answered any questions brought up throughout the course.
without a doubt - amazing - Adam is both a brilliant communicator - with great knowledge and keeps people both engaged and deals with our unique 'requirements' and questions. He is fast - but that is half the fun.... the fellow attendees - we all were running with it.. questions - lots of them - and always answered...
Adam was a fantastic facilitator and maintained great energy and pace over the course of the two days. He made the group feel comfortable asking questions and explained all of the concepts in logical and easy to understand terms. I appreciated the opportunity to develop the foundation for my understanding of how DAX formulas operate and interact with PBI datasets and feel much more confident about using these expressions in the future.
Gordana was a really great instructor. She explained all topics clearly and was easy to follow along with. It is a lot of information but gives you a great starting point for applying DAX in PowerBI.
I can't praise Gordana enough for delivering a great course. In the last 6 months I've done 8 courses with Dynamic Web Training & this one was the most well-presented & well-paced one I've done.
Very helpful. Good to do but I will probably need to retake the course later once I have developed more knowledge and skills.
-Valuable course that gives fundamental knowledge on DAX. - Excellent Course Content (Theory + Hands On exercises). - Ali was great in teaching the course. Excellent communication and teaching skills along with vast knowledge on POWER BI.
Ali is an amazing instructor with so much expertise and knowledge particularly about sharing and capturing info as a resource. I find his annotations really helpful particularly during the discussions and he has a lot of tools that he used which is so captivating.
Excellent course overall. The second day was incredibly fast-paced, with a substantial amount of material to absorb. Despite the intensity, it was a highly valuable learning experience.
Enquire Now
Fill in your details to have a training consultant contact you to discuss your training needs.
Note: Form fields marked with * are required.
Book our 4 core Power BI course together and
SAVE $330
For more info please
Call 1300 888 724