JOIN THIS SUBSCRIBER-ONLY EVENT
DAX Accelerator
- To be announced
Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI
Here's What You'll Get Through
This Accelerator Program
Over 4 days, accelerate your Power BI skills within our unique learning experience.
Get personal guidance and experience during instructure lead sessions from global experts
Best practice frameworks for elevating your Power BI skillset and development techniques
Build the exact skills you need around Power BI in the fastest way possible
- Time Commitment:
- 4 days
- 2 hour workshop each day
- 1 hour project based learning each day
- Benefits:
- Condensed learning
- Collaborative environment
- Ask questions live
- Network with other data professionals
A UNIQUE LEARNING EXPERIENCE FROM ENTERPRISE DNA
What specifics will you learn during this
DAX Accelerator Program
- Use DAX and also what you can achieve with DAX if utilized well
- Structure and format DAX formula
- Use DAX variables in your formulas effectively
- Use calculated columns and measures in your models
- Write aggregation, iteration and table DAX functions
- Implement DAX functions in combination with each other
- Visualize how the DAX calculation engine works via the concept of 'context'
- Audit your formulas by understand filter and row context
- Use the CALCULATE
- Add additional virtual filters to your calculations by using table functionsalysis
- Use DAX to solve common analytical scenarios you will face everyday in the real world
- Use time intelligence table along with a quality date table
- Use advanced table functions in unique calculation requirements
Here's an outline of the
DAX Accelerator Curriculum
DAX Basics
- Calculated columns vs measures
- Understanding context & how the DAX calculation engine works
- Evaluation or initial context
- Aggregations or filter context
- Iterations or row context
- DAX function types
- Aggregation Functions - SUM/AVERAGE/MIN/MAX
- More Aggregators COUNT/COUNTA/COUNTBLANK/COUNTROWS/DISTINCTCOUNT
- Iteration Functions - SUMX/AVERAGEX/MINX/MAXX
Virtual Tables & Measure Branching
- What are table functions? (think of virtual tables!)
- FILTER
- The versatile VALUES function
- VALUES vs DISTINCT
- VALUES vs SELECTEDVALUE (& HASONEVALUE)
- ALL function - the remove filters function
- How filter and row context work with relationships
- Working with one table versus many tables
- ISFILTERED/ISCROSSFILTERED
- RELATED function
- EARLIER function
CALCULATE & Time Intelligence
- Why CALCULATE is important?
- Why do you even have to use CALCULATE? (It's all about CONTEXT!)
- What can you do when you use CALCULATE?
- How are formula calculated when you involve CALCULATE?
- CALCULATE example w/USERELATIONSHIP
- What are time intelligence functions?
- Why you must have a date table?
- The best time comparison function - DATEADD
- DATEADD vs SAMEPERIODLASTYEAR
- Aggregations - YTD, QTD, MTD
Advanced DAX Techniques
- Understanding how variables are evaluated
- Using table variables to simplify ultimate formulas
- Using variables to clean up multiple measure
- When to create virtual vs physical relationships?
- TREATAS
- How does USERELATIONSHIP compare?
- How to manipulate virtual tables using table functions
- ADDCOLUMNS
- SUMMARIZE
- You can also combine table functions together
- ROW
What you get from participating in
an accelerator program
- Access to 4 days worth of training with two hour live sessions each day
- Ability to collaborate with other data analysts during the week during workshops and through projects
- Access will be given to all replays and instructor-led Q&A‘s will be available throughout the program
- A certification to showcase your participation and learning experience
- Tons of resources and direction to maintain your skills through time
- Live support throughout the week to improve your skills and development abilities
This Accelerator Program is Tailored for:
Data Analysts
Reporting Managers
Excel Users
Your Instructor For This Accelerator Program
Sam McKay
Sam is Enterprise DNA's CEO & Founder. He help individuals and organisations develop data driven cultures and create enterprise value by delivering business intelligence training and education on Microsoft’s Power BI platform
He partners with business decision makers and analysts across all industries and business functions.
- Industries include: Financial Services, Consumer Goods, Energy, Retail, Insurance and others
- Functions include: Finance, Accounting, Sales, HR, Marketing and more
- People include: Directors, Executives, Team leaders, Analysts
There is no faster way to build your practical skills and make a difference within your teams than by attending one of our accelerator programs
Use our accelerator programs to further advance your career in data and analytics.
Get full access to unparalleled training
& skill-building resources
For Individuals
Enterprise DNA
On-Demand
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities
For Teams
Enterprise DNA
For Business