Platform Access

Advanced Analytics in Power BI

Implement advanced & practical analytical techniques inside of Power BI and find insights you never thought possible in an intuitive way. Enhance the abilities of understanding outliers or anomalies and many many more advanced analytical insights

Enroll Now
Advanced Analytics in Power BI, power bi advanced analytics course

Here's What You'll Get

With The Course

Over 3 hours of

video training

3x demo data sets to practice DAX formula and dashboarding design

10x demo model downloads showing specific analytical techniques

Advanced Analytics in Power BI

Advanced and Unique Analytical Power BI Techniques

  • Impress your consumers with the actionable insights you can produce.
  • Apply Power BI to solve great insights like cross selling opportunities, fraud detection, understanding outliers or anomalies and many many more advanced analytical insights.

Details Of What You Will Learn

During This Course

  • Learn - how to utilize combinations of DAX formula for advanced insights
  • Understand - the analytical power of using DAX in Power BI
  • Implement - a variety of DAX techniques over different data scenarios
  • Learn - advanced analytical concepts and possibilities
  • Learn - how to automate advanced insights
  • Learn - how to use Power BI as an analytical engine
  • Understand - how to structure an effective data model for your data scenario
  • Predict - future outcomes before they occur by 'shocking' business variables
  • Learn - how to think analytical about your own datasets
  • Build - technical and practical analytical solutions using Power BI
Advanced Analytics in Power BI

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Participants of this module should have ample knowledge and skills in using Power BI as a reporting and analytical tool and want to learn how to use it to intuitively find insights.


Utilize the key features within Power BI

Optimizing Dax
  • Advanced DAX formulas inside your Power BI models
  • Combinations of analytical techniques
  • Design a great data model the enables advanced insights
  • Layer many DAX techniques to discover the insights you need
  • Key aspects of information
  • Develop end to end 'analytical solutions' that wow data consumers
  • Outcomes and detect outliers in your data
  • Solve difficult and advanced analytical scenarios

Course Curriculum

1. Introduction to the Course

  • How to get certified for this course?

2. Advanced Power BI Analytical Techniques

  • Anomaly detection
  • Cluster analysis
  • Outlier detection
  • Cross-sell opportunities
  • Pattern recognition
  • Customer segmentation
  • Review Questions
  • Review Question Feedback
  • Threshold triggers & breaches
  • Secondary table logic
  • Pareto rule
  • Customer attrition
  • Dynamic ranked lists
  • Review Questions
  • Review Question Feedback

What our Students Say

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.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription 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 On-Demand Subscription 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.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA


Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace