portal.enterprisedna.co Open in urlscan Pro
2606:4700::6813:ef75  Public Scan

Form analysis
1 forms found in the DOM

GET /purchase

<form accept-charset="UTF-8" action="/purchase" class="sale_default" id="sale_default2" method="get">
  <input type="hidden" name="authenticity_token" value="i1EbFv/gqqHelrkd/D2a0TZyMyw1ttFSJQUJU8K9lamq7RJeZdP/Lpx+xeGHgl95guj4pXjMxtp/qVMHwPGH3g==">
  <input type="hidden" name="utf8" value="✓">
  <input type="hidden" name="course_id" value="108877" id="course_id">
  <input type="hidden" name="coupon_code" value="" id="coupon_code">
  <input type="hidden" name="school_domain" value="https://portal.enterprisedna.co" id="school_domain">
  <input type="hidden" name="product_id" value="3891114" id="product_id">
  <input type="hidden" name="user_src" value="" id="user_src">
  <button name="button" type="submit" id="enroll-button-top" data-course-id="108877" data-disable-with="Processing..." class="btn btn-hg btn-primary btn-header-enroll">
    <i class="fa fa-shopping-cart"></i>&nbsp;&nbsp; Enroll in Course for <span class="default-product-price product_3891114">FREE</span>
    <span class="coupon-price product_3891114"></span>
  </button>
</form>

Text Content

Toggle navigation
 * All Courses
 * PLATFORM ACCESS
   
 * Login
 * Sign Up

 


MASTERING DAX CALCULATIONS


CREATE ADVANCED ANALYTICAL MODELS BY LEARNING HOW TO HARNESS THE POWER OF DAX
CALCULATIONS FOR USE WITHIN POWER BI

   Enroll in Course for FREE






An outline of this training course

This training will take you from a beginner to advanced user of Power BI by
utilising the powerful DAX language to the fullest. Covered in the course
material are all the beginner theory that you must understand very well to
harness the analytical power of DAX. Through real-world scenarios you will be
taken through how to use DAX in practice to discover the insights you want to
find in your data. Covered are every major DAX function and how to use these
when completing calculations and in combination with each other. DAX is the most
difficult part of Power BI to learn and put into practice well. This course
covers all major tips and techniques that if practiced will have any Power BI
user creating compelling Power BI reports and solutions.

Number of Recommended CPE credits: 13.5

Field(s) of Study: Computer Software & App

Course Level: Intermediate

Participants of this module should have basic knowledge and understanding of how
to use Power BI and DAX. It is recommended to have completed the Ultimate
Beginners Guide to Power BI and DAX, and the Power BI Super Users Workshop
modules. No other advance preparation needed to take this course.

This course module is tailored to: Excel users, data analysts, reporting
managers

Mastering DAX Calculations - is a QAS self study (Traditional) course. It can
also be accessed through a purchase of an Enterprise DNA Membership or Center of
Excellence License.


This course was last updated on January 2020.






Details of what you will learn during this course
 * Learn - what DAX is and the journey required to master it
 * Understand - what you can achieve with DAX if learnt well
 * Review - DAX basics, including calculated columns vs measures, context &
   aggregation vs iteration formulas
 * Understand - why a quality data model is so important
 * Complete - a deep dive into simple aggregation and iterating functions
 * Review - the concept of 'context' comprehensively
 * Learn - the most important function in DAX, CALCULATE
 * Learn - all the major table and filtering functions
 * Review - how to use DAX in common analytical scenarios
 * Gain - a detailed overview of time intelligence functions and how to use
   within your models
   
 * Learn - advanced table functions and how to use them
   
 * Master - some of the most complex topics around how DAX actually works



What you get with the course
 * More than 9 hours of course videos
 * 1x demo data sets to follow along when practicing all DAX formula




Here are the specifics for the course
Learn how to;
 * Use DAX and also what you can achieve with DAX if utilised 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
 * Visualise how the DAX calculation engine works via the concept of 'context'
 * Audit your formulas by understand filter and row context
 * Use the CALCULATE function in your analysis
 * Add additional virtual filters to your calculations by using table functions
   
 * 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




Testimonials
For testimonials and to see how Enterprise DNA is helping thousands more Power
BI users, check out the testimonial wall




For a list of all courses available through Enterprise DNA view here




"I've found DAX really hard, but it makes far more sense now. The explanations
are clear and more simplified than I've read and watched elsewhere which is what
I needed. The examples are great too." - Scott T. - Michigan   "I've been
looking for resources like this everywhere but couldn't find any. So good to
have these all in one place, with detailed explanations on how to build this
myself. Seriously awesome stuff." - Renee M. - Melbourne   "I just started
learning Power BI with the courses on this page and they are awesome and easy to
follow and understand, even if English is not your origin language.." - Álvaro,
Chile


YOUR INSTRUCTOR


Sam McKay

Sam very early on saw the immense opportunity of using Power BI to create
analytical solutions. After years of developing some advanced analysis and tools
in excel, he was amazed that he could re-create most of those things in about
10% of the time with Power BI.

He is the founder and CEO at Enterprise DNA, a business intelligence training &
consultancy business primarily focused on driving better decision making within
organisations by empowering individuals and teams to transform raw data into
unmatched insights using Microsoft's Power BI suite of tools.

Sam has a strong history in Finance, previously working at ANZ, PIMCO, and
Fonterra. He is also a CFA charterholder, achieving the designation in 2011.

He has a passion for building highly scalable analytical solutions within
organisations, and wants to see others learn how to do the same.



COURSE CURRICULUM


  Introduction to DAX
Available in days
days after you enroll
 * Start
   How to get certified for this course?
 * Start
   Course resource pack download
 * Start
   What is DAX & how to learn to master it? (9:17)
 * Start
   Data types and operators (5:17)
 * Start
   The importance of naming conventions (6:05)
 * Start
   Formula syntax (4:51)
 * Start
   Measure groups (4:10)
 * Start
   Formatting DAX code (6:54)
 * Start
   Using variables to simplify formulas (6:00)
 * Start
   Writing comments in your code (3:12)
 * Start
   Quick measure feature (positives vs negatives) (7:53)
 * Start
   DAX doesn't work unless your data model and relationships are setup correctly
   (7:34)
 * Start
   The only way to learn is to practice (3:55)

  DAX basics
Available in days
days after you enroll
 * Start
   Calculated columns vs measures (8:46)
 * Start
   Understanding context & how the DAX calculation engine works (9:27)
 * Start
   Evaluation or initial context (3:52)
 * Start
   Aggregations or filter context (5:50)
 * Start
   Iterations or row context (8:11)
 * Start
   Understand context in calculated columns (context transition) (7:55)
 * Start
   How the data models iterates w/DAX (filter propagation) (4:10)
 * Start
   Review Questions
 * Start
   Review Question Feedback

  Getting started with DAX
Available in days
days after you enroll
 * Start
   DAX function types (4:10)
 * Start
   Aggregation Functions - SUM/AVERAGE/MIN/MAX (4:58)
 * Start
   More Aggregators - COUNT/COUNTA/COUNTBLANK/COUNTROWS/DISTINCTCOUNT (6:12)
 * Start
   Iteration Functions - SUMX/AVERAGEX/MINX/MAXX (4:47)
 * Start
   Measure branching methodology (7:47)
 * Start
   How to use combinations of DAX functions (6:45)
 * Start
   Error handling w/DAX - BLANK/ISBLANK/IFERROR (6:16)
 * Start
   Logical Functions - IF / SWITCH (10:56)
 * Start
   DIVIDE function (4:05)
 * Start
   Other Function Types - Information, Text, Conversion, Date & Time, Boolean
   (5:22)

  Introducing Simple Table Functions
Available in days
days after you enroll
 * Start
   What are table functions? (think of virtual tables!) (3:48)
 * Start
   FILTER (10:58)
 * Start
   The versatile VALUES function (12:58)
 * Start
   VALUES vs DISTINCT (4:57)
 * Start
   VALUES vs SELECTEDVALUE (& HASONEVALUE) (6:24)
 * Start
   ALL function - the remove filters function (11:02)
 * Start
   ALL & ALLEXCEPT (9:43)
 * Start
   ALLSELECTED requires a deeper understanding (8:47)
 * Start
   Review Questions
 * Start
   Review Question Feedback

  Expanding on CONTEXT
Available in days
days after you enroll
 * Start
   How filter and row context work with relationships (8:34)
 * Start
   Working with one table versus many tables (6:34)
 * Start
   ISFILTERED/ISCROSSFILTERED (6:11)
 * Start
   RELATED function (8:51)
 * Start
   EARLIER function (6:28)

  CALCULATE statement
Available in days
days after you enroll
 * Start
   Why CALCULATE is important? (2:18)
 * Start
   Why do you even have to use CALCULATE? (It's all about CONTEXT!) (2:30)
 * Start
   What can you do when you use CALCULATE? (6:50)
 * Start
   How are formula calculated when you involve CALCULATE? (6:43)
 * Start
   CALCULATE example w/USERELATIONSHIP (6:09)
 * Start
   Simple and advanced filters with CALCULATE using FILTER function (7:32)

  Time Intelligence Functions
Available in days
days after you enroll
 * Start
   What are time intelligence functions? (3:13)
 * Start
   Why you must have a date table? (3:18)
 * Start
   The best time comparison function - DATEADD (9:25)
 * Start
   DATEADD vs SAMEPERIODLASTYEAR (3:04)
 * Start
   Aggregations - YTD, QTD, MTD (7:45)
 * Start
   Time comparisons - PREVIOUSMONTH, PARALLELPERIOD (6:22)
 * Start
   Information - OPENINGBALANCEMONTH, STARTOFMONTH, ENDOFYEAR (6:47)
 * Start
   DATESBETWEEN, DATESINPERIOD, DATEDIFF functions (9:53)
 * Start
   Practical examples using time intelligence functions (9:34)
 * Start
   Review Questions
 * Start
   Review Question Feedback

  Advanced Techniques For Variables
Available in days
days after you enroll
 * Start
   Understanding how variables are evaluated (14:42)
 * Start
   Using table variables to simplify ultimate formulas (6:50)
 * Start
   Using variables to clean up multiple measures (5:53)

  Creating Virtual Relationships
Available in days
days after you enroll
 * Start
   When to create virtual vs physical relationships? (5:17)
 * Start
   TREATAS (8:40)
 * Start
   How does USERELATIONSHIP compare? (3:38)

  Advanced Table Functions
Available in days
days after you enroll
 * Start
   How to manipulate virtual tables using table functions (4:03)
 * Start
   ADDCOLUMNS (8:21)
 * Start
   SUMMARIZE (7:45)
 * Start
   You can also combine table functions together (3:50)
 * Start
   CROSSJOIN (7:45)
 * Start
   ROW (2:50)
 * Start
   UNION (5:21)
 * Start
   CALCULATETABLE (11:35)
 * Start
   INTERSECT & EXCEPT (10:07)
 * Start
   SUMMARIZECOLUMNS (4:26)
 * Start
   GENERATE (3:22)
 * Start
   GROUPBY (7:39)
 * Start
   Review Questions
 * Start
   Review Question Feedback

  Ranking Functions
Available in days
days after you enroll
 * Start
   RANKX (8:32)
 * Start
   TOPN (7:08)
 * Start
   Practical examples for using ranking functions (11:00)

  Advanced DAX Formula Combination Examples
Available in days
days after you enroll
 * Start
   This is where the measure branching methodology really shines (1:46)
 * Start
   Compare multiple quarterly sales on each other (10:36)
 * Start
   Using virtual tables with COUNTROWS (7:30)
 * Start
   Budgeting allocation algorithm (11:22)
 * Start
   Fixing errors with your totals efficiently (6:03)
 * Start
   Review Questions
 * Start
   Review Question Feedback

  Your Feedback
Available in days
days after you enroll
 * Start
   Course Survey

  Certification
Available in days
days after you enroll
 * Start
   Certificate & Badge



FREQUENTLY ASKED QUESTIONS


How long do I have access to the course?
You will have access to the course for as long as your Enterprise DNA membership
or CoE license is active.
Can I purchase a single course instead of the full Enterprise DNA membership?
The option to purchase a single course has been discontinued. To access any of
our courses, you will need to upgrade to full membership here.
Do you offer one-off support or coaching?
All support around Power BI and Enterprise DNA's online training content now
occurs at the Enterprise DNA Forum. You must have an Enterprise DNA Membership
or CoE access to receive support.
What if I need to train my team?
We recommend exploring Enterprise DNA Center of Excellence platform. To learn
more, see here.

Passionate about empowering users of Power BI

"My goal is to teach others that you have almost unlimited analytical power when
harnessing all the features in Power BI.

Through training across a number of different mediums, I've reached over 100,000
Power BI users, showing them a range of tips and tricks in Power BI development.

I'm a true believer that Power BI is the future of analysis and know individuals
with the right training can now create advanced analytics in a scalable way that
can have a real impact in the way insights are found and consumed within
organisations."

Sam McKay, CFA - Founder & CEO, Enterprise DNA

"Sam and EnterpriseDNA have taken my PowerBI to the next level. The courses are
excellently well presented. Sam's extensive experience in building BI tools
means the tutorials and webinars are always relevant and always hit the mark.
Enterprise DNA is a 5* resource - I highly recommend."- David Nightingale,
Johannesburg South Africa "I came across Enterprise DNA through one of the free
YouTube videos. After getting a lot of valuable info for free, I felt ready to
dig deeper into PowerBi in general and DAX in particular, and the membership
here certainly has given me good value for money therefore I highly recommend
signing a membership." - Erik Jacobsen, Scandinavian "I have been in the
Analytics and Data Warehouse space for about 20 years and have been a serious
advocate of Power BI from it’s inception. I am excited to become a member of
this forum, having review as many of Sam’s vidoes as I could and have enefited
significantly from his tutelage." - Brad - Canada






Home
Learning Center
Showcases
Resources
Forum
Blog

Membership
Center of Excellence
Virtual Events
Upcoming Courses
Our Experts
Certifications

Analytic Mind Podcast
Analyst Hub
Knowledge Base
Enterprise DNA TV
Testimonials
Earn a Membership

Corporate Partners
Affiliate Program
Scholarship Program
Social Responsibility
Careers
Contact Us
Privacy Policy


Incomplete Completed Incomplete disabled
0 people
are viewing this site


0 people
viewed this page
in the last





1