Enterprise DNA

This Live Training Workshop Has Been Completed. The Replay is now accessible in the Enterprise DNA Online Portal with an upgraded membership.

Scenario Analysis Patterns using DAX in Power BI


Click the Button Now to Join Us for This Free Webinar for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more.

Here's Exactly What We'll Be Covering

Scenario Analysis Patterns

  • What-if scenarios
  • Projecting trends forward
  • Combining multiple DAX formulas
  • Visualizing future results
  • Advanced analytical techniques 

Check Out What You Will Learn During This Free Virtual Training Event

  • Master Power BI development techniques
  • Create compelling visuals and reports
  • Solve advanced analytical questions using Power BI
  • Master the key components of high quality model development

Here Are the Details for This Webinar

  • When is it? Wednesday, June 5th, 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT) - Thursday, June 6th, 8am Sydney (AEDT), 10am Auckland (NZST)
  • Where is it? Join in from your laptop, desktop or connected device
  • Who's doing it? Presented by Sam McKay, Founder of Enterprise DNA - Driving an analytical movement through using Power BI!
  • Why should I be there? To learn how to bring scenario analysis patterns and techniques into your analysis in Power BI
  • What's it all about? We'll be reviewing a number of techiques specifically around scenarios analysis in Power BI. Don't just think Power BI is just a visualisation tool, it is a powerful analytical engine that can produce amazing insights including running custom scenarios on your raw data.

This training begins in...


Join the analytical movement with Enterprise DNA!

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

Come join me on this journey to rid the world of terrible reporting, instead produce amazing insights that actually create value for your organisations and yourselves.

This webinar is a combination of many advanced techniques and much more. Whether your beginner or advanced I'm very confident you'll learn something new. See you there!"

Sam McKay, CFA - Founder, Enterprise DNA


During This Free Training, You Will Learn:

  • How to assess a data set and analytically think about what insights you want to showcase. Before you begin developing in Power BI desktop you should always complete some initial thinking around what answers you want and how do you want to display them. I'll walk through my thought process around this.

  • How to architect a data model with the correct relationships. Before you start completing any calculations or writing any DAX formula you need to make sure your data model is correct. I'll go over some simple tips on how to architect an effective data model.

  • How to use DAX to discover interesting insights. DAX is the true power behind Power BI. If you know which formula to use and when, then you can complete some really incredible analysis fast. We'll be going through some examples of how this all works.

  • Develop an entire reporting dashboard that contains compelling insights within an hour. I'm going to re-create this compelling dashboard within the hour. I'll showcase every formula that I used and then how I built up the dashboard from scratch.