Power BI Course
DAX Essentials
Join our 2-Day Power BI course to master DAX, the key to advanced data manipulation. We start with the basics to build a solid foundation, then progress to complex functions, focusing on practical application and engagement.
By the end, you’ll confidently write tailored DAX expressions, tackle intricate challenges, and optimize functions using the best tools and techniques. This course is an invaluable step towards becoming a Power BI expert, equipping you with immediately applicable skills for your professional role. Book now and transform your data analysis capabilities.
About this Course:
Without using DAX, you can only use 50% of Power BI’s capability. Although Power BI Dax is simple, with only a few fundamental concepts, it is not easy as these concepts require deep learning. That is why a lot of Power BI users think they know DAX until they realize their functions are not returning correct results.
This 2-Day Power BI 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 90% of 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 and 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.
Prerequisites:
This Power BI 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, participants must have some expertise in using Excel functions or T-SQL.
Who should take 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 the next level by writing custom calculations using DAX functions to address specific business requirements.
WHY POWER BI TRAINING BY AMZ?
Upcoming Dates
July
| Date | Day | Training Mode | ||
|---|---|---|---|---|
| 01/07/24 | Mon | Online/Classroom | ||
| 08/07/24 | Mon | Online/Classroom | ||
| 15/07/24 | Mon | Online/Classroom | ||
| 22/07/24 | Mon | Online/Classroom | ||
| 29/07/24 | Mon | Online/Classroom | ||
| Please contact us for further dates | ||||
August
| Date | Day | Training Mode | ||
|---|---|---|---|---|
| 05/08/24 | Mon | Online/Classroom | ||
| 12/08/24 | Mon | Online/Classroom | ||
| 19/08/24 | Mon | Online/Classroom | ||
| 21/08/24 | Wed | Online Live | ||
| 26/08/24 | Mon | Online/Classroom | ||
| Please contact us for further dates | ||||
September
| Date | Day | Training Mode | ||
|---|---|---|---|---|
| 02/09/24 | Mon | Online/Classroom | ||
| 09/09/24 | Mon | Online/Classroom | ||
| 16/09/24 | Mon | Online/Classroom | ||
| 23/09/24 | Mon | Online/Classroom | ||
| 30/09/24 | Mon | Online/Classroom | ||
| Please contact us for further dates | ||||
October
| Date | Day | Training Mode | ||
|---|---|---|---|---|
| 07.10.24 | Mon | Online/Classroom | ||
| 14.10.24 | Mon | Online/Classroom | ||
| 21.10.24 | Mon | Online/Classroom | ||
| 23.10.24 | Wed | Online/Classroom | ||
| 28.10.24 | Mon | Online/Classroom | ||
| Please contact us for further dates | ||||
November
| Date | Day | Training Mode | ||
|---|---|---|---|---|
| 04.11.24 | Mon | Online/Classroom | ||
| 11.11.24 | Mon | Online/Classroom | ||
| 18.11.24 | Mon | Online/Classroom | ||
| 20.11.24 | Wed | Online/Classroom | ||
| 25.11.24 | Mon | Online/Classroom | ||
| Please contact us for further dates | ||||
December
| Date | Day | Training Mode | ||
|---|---|---|---|---|
| 02.12.24 | Mon | Online/Classroom | ||
| 03.12.24 | Tue | Online/Classroom | ||
| 09.12.24 | Mon | Online/Classrom | ||
| 10.12.24 | Tue | Online/Classroom | ||
| 16.12.24 | Mon | Online/Classroom | ||
| Please contact us for further dates | ||||
For more date options and to
complete the booking
Course Outline
Unit 1: Data Analysis Expression (DAX) language
✅ What is DAX
✅ What are the Data types in DAX
✅ DAX type handling/operator overloading
✅ DAX as Formula Language
✅ Vertipaq engine in DAX
✅ Difference between DAX, EXCEL functions, and M
✅ Dos, Don’ts, and Best Practices in DAX
Unit 2: Data Modeling Recap
✅ Fact vs Dimensions
✅ Schemas in Data Model
✅ Filter Propagation
✅ Data Denormalization
✅ Relationship Characteristics
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
Unit 4: Basic DAX Functions
✅ Two broad categories of functions in DAX
✅ Use of SUM(), DIVIDE() and COUNT()
✅ Use of DISTINCT COUNT ()
✅ Finding Min, Max, and Average
✅ Counting Rows
✅ Counting Blank Values
Unit 5: Evaluation Contexts in DAX
✅ What are the two evaluation contexts in DAX?
✅ What is the initial or incoming filter context
✅ What is Row Context
✅ Filter Context vs Row Context
✅ Rules of Evaluation
Unit 6: Table Functions
✅ Creating a Calculated Table
✅ Exploring Table Joins
✅ The Inner Join
✅ The Outer Join
✅ A Join on Unrelated tables – TREATAS()
✅ GENERATE() for Joins
✅ Creating a summary table for the requested totals using SUMMARIZE()
✅ Creating a summary table over a set of groups using SUMMARIZECOLOUMNS()
✅ Improve TREATAS() using SUMMARIZE()
✅ Getting the top N rows of the specified table using TOPN()
✅ Using VALUES()
✅ Using FILTER() as a Table function
✅ Virtual table lineage
Unit 7: Introduction To Data Modeling & Dax
✅ Creating & Optimizing Calendar Table using DAX
✅ Adding Date Columns
✅ Working with Fiscal Years
✅ Set sorting options
Unit 8: Basic Iterators
✅ Iterators vs. Normal Functions
✅ Using SUMX()
✅ Using COUNTX()
✅ Using AVERAGEX()
✅ Using MINX()
✅ Using MAXX()
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
Unit 10: Advance Filtering in DAX
✅ Modification of Filter context using CALCULATE()
✅ Modification of multiple Filter using 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()
✅ Modify how filters are applied using KEEPFILTERS()
✅ Using SELECTEDVALUE()
✅ Using CONCATENATEX()
Unit 11: Context Transition
✅ Implicit Calculate in Measures
✅ Row to Filter Context transition
✅ Using CALCULATE() and CALCULATETABLE()
✅ Using EARLIER() vs EARLIEST()
Unit 12: Time Intelligence in DAX
✅ What is Time Intelligence
✅ Date table properties for Time Intelligence
✅ Aggregations over time
✅ Total Year till Date, Month Till Date, and Quarter till Date
✅ Handling Fiscal Year
✅ Same Period Last Year
✅ Calculate the Running Total
✅ Using date modifier DATESBETWEEN
✅ Shifting forward/backward in time using DATEADD()
✅ Using DATESINPERIOD()
✅ Using MAX or LASTDATE()
✅ Using FIRSTNONBLANK() and LASTNONBLANK()
✅ Total Sales rolling 90 days
Unit 13: Conditionals in DAX
✅ Use of IF( ) statements
✅ Switching between cases using SWITCH( )
✅ Finding your text
✅ What to do if your text had one value
✅ Concatenating labels
✅ Using COALESCE( )
Unit 14: Hierarchies In DAX
✅ What are hierarchies
✅ Parent-child hierarchies
✅ Using Path functions
Unit 15: Other Functions
✅ Using RANKX() ✅ Dynamically controlling units ✅ Using COUNTA(), MINA(), MINAX()
Unit 16: DAX Tools and Other Resources
✅ Common errors and causes
✅ Error debugging
✅ What is DAX Formatter
✅ Getting started with DAX Studio
✅ Downloading and Installing DAX Studio
✅ Connecting DAX Studio with Power BI
✅ Calculation performance using Data Studio
✅ Power BI Helper
✅ Clear the Cache
✅ Other DAX references
First Choice For Power BI Training
