Unique Analytical Scenarios
Solve unique analytical problems faced within many business functions, industries and data scenarios.
An outline of this mini series module
Details of what you will learn within this mini series module
- Learn - how to use Power BI for unique analytical problem solving
- Review - various techniques used to discover rare insights
- Learn - how to combine many DAX formula concepts together
- Understand - the analytical power you have at your disposal with Power BI
- Learn - how to think about your analysis in new and interesting ways
What you get with this mini series module
- Over 4 hours of video tutorials
- Over 15 short form video tutorials covering best practice analytical techniques
- An accompanying resource download for each video tutorial
- Resources made available for review and to use when replicating the showcased techniques
- Master advanced analytical work in Power BI
- Think deeply about complex problem solving within Power BI
- Solve unique data analysis scenarios
- Use a variety of modeling and formulas techniques to get the right answers
For a list of all courses available through Enterprise DNA view here
Course Curriculum
-
StartHow To Calculate Averages per Day in Power BI with DAX (5:39)
-
StartAdvanced DAX - Show Percentage Sales Per Custom Group Each Year In Power BI (5:57)
-
StartDiscover Which Custom Groups Contribute The Most To Profit in Power BI w/DAX (9:02)
-
StartUsing Complex Logic Inside Iterating Functions - Advanced DAX (7:00)
-
StartCalculating New & Existing Customer Sales Using DAX in Power BI - Advanced DAX (8:16)
-
StartIn-Depth Customer Churn, New Customers & Lost Customers Examples In Power BI using DAX (11:58)
-
StartTesting The Pareto Principle (80/20 Rule) in Power BI wDAX (9:39)
-
StartIdentify Which Customers Are Purchasing Behind Trend in Power BI w/DAX (10:58)
-
StartEvaluating Cross Selling Opportunities With DAX In Power BI - Advanced (9:06)
-
StartCalculating Average Monthly Purchases in Power BI using DAX (9:19)
-
StartOutlier Detection & Visualization in Power BI - Advanced DAX (11:12)
-
StartPredict When Customers Will Purchase Next - Advanced Power BI & DAX (7:46)
-
StartWhat's Causing The Change - Power BI & DAX Techniques (11:58)
-
StartDetect Abnormal Patterns In Behaviour Using DAX In Power BI (6:51)
-
StartWhat's The Most Common Behaviour From Customers - DAX in Power BI (6:29)
-
StartCalculating Averages Per Transaction Using DAX in Power BI (8:41)
-
StartShowcasing Deviations Effectively In Power BI - Analytical Techniques (7:50)
-
StartSegment Customers Based On Historical Performance - Power BI & DAX Techniques (9:20)
-
StartCompare One Sale Versus The Last Sale (No Time Intelligence) - Advanced DAX Insights (7:04)
-
StartBreak Out Outliers & Analyze Over Time - Advanced DAX Concepts (10:30)
-
StartCreating Dynamic Outlier Trigger Points - Advanced Power BI Analysis Technique (10:05)
-
StartHow Many Customers Have Multiple Product Purchases - Power BI & DAX Analytics (7:30)
-
StartWhat Is The First Product A Customer Purchased? - Power BI Analytics (6:57)
-
StartHow Does Sensitivity Analysis Work In Power BI - DAX Analytical Techniques (8:59)
-
StartHow To Download Latest Exchange Rates Into Your Power BI Model (7:05)
-
StartCalculate A Reverse Cumulative Total In Power BI Using DAX (6:44)
-
StartHow To Create Tables Combining UNION & ROW Function - Power BI & DAX (6:34)
-
StartShowcasing Growth Performance Effectively In Power BI - Advanced DAX (10:04)
-
StartCross Selling Matrix Deep Dive - Power BI & DAX Tutorial (11:06)
-
StartCalculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI (9:27)
-
StartCalculating The Previous High Dynamically In Power BI Using DAX (5:33)
-
StartHow To Create Unique Subtotals In Power BI Tables Using DAX (8:32)
-
StartCreate Unique Table Template Designs Within Power BI - Power BI & Financial Reporting (7:22)
-
StartDynamically Group Receivables Based On When Cash Is Expected - Power BI/Accounting (8:45)
-
StartCreate A Gantt Chart In Power BI With A Matrix Visual (10:49)
-
StartUsing ALLEXCEPT To Stop Cumulative Total From Resetting - DAX Solution (5:02)
-
StartCalculate Total CRM Forecasts From Today Until End Of Month - DAX Insights (6:34)
-
StartWho Is Our Top Purchasing Customer Per Product? - Power BI Analysis (8:49)
-
StartCreate A Pareto Chart In Power BI Using DAX Function Combinations (11:01)
-
StartSimple Currency Conversion in Power BI w/DAX (12:34)
-
StartHow To Format Currencies in Power BI w/DAX (14:54)
-
StartAccounting For Missing Currency Rates w/DAX (21:08)
-
StartAccounting For Missing Data In Currency Table w/PowerQuery (25:21)
-
StartHandling Missing Currency Data Using Average-to-Date (46:29)
Your Instructor
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
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