Power BI Drill Through allows users to focus on specific details within a report by navigating to related information in a separate page or report, which helps in identifying patterns and making informed decisions. This interactivity and flexibility empowers users to analyze data more effectively and gain deeper insights.

Typically, what you see in Drill Through is a table and drill through to a detailed page. In this video, Brian shares how you can drill through other constructs of your report, and his tips on how to maximize this underrated aspect of Power BI.

*****Video Details*****
00:00 Introduction
01:59 Where to get the images
02:25 Continue reading “Top 10 Power BI Drill Though Pro Tips” →

Dynamic outliers are data points that significantly deviate from the typical pattern of the data over time. Identifying these outliers can help highlight underlying performance trends and provide insights for better decision-making.

In this tutorial, Sam shows how to identify dynamic outliers in your data set using DAX. By mastering these advanced concepts, you’ll be able to showcase underlying performance trends and gain valuable insights for better decision-making.

***** Video Details *****
00:00 Introduction
02:01 Classification of an outlier
03:48 Outlier vs non-outlier
05:15 Outlier measure
05:53 Total sales
09:05 Real-life applications

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – Continue reading “Break Out Outliers And Analyze Over Time – Advanced DAX Concepts [2023 Update]” →

In this episode of the podcast, learn from the expertise of Thomas Martens, a Microsoft Data Platform MVP and Solution Architect at Munich Re. Join us as he explores the role of a Power BI Sherpa in driving a data culture and overcoming challenges in organizations. With 25 years of experience delivering Business Intelligence, Data Warehousing, and Analytics solutions, Tom shares his insights on using Power BI to tackle analytical challenges and apply analytical methods to small and large amounts of data. In this episode, Tom discusses the importance of Power BI in fostering a data culture, the challenges faced Continue reading “Driving a Data Culture and Overcoming Challenges as a Power BI Sherpa with Thomas Martens” →

The Performance Analyzer tool in Power BI is an essential feature for anyone working with DAX formulas. It provides a range of powerful tools and features that can help you debug, optimize, and fine-tune your formulas to improve their performance.

With the Performance Analyzer tool, you can identify performance bottlenecks, debug DAX formulas, optimize calculations, and monitor query execution. You can use it to step through your formula line by line, identify areas that need optimization, and monitor the performance of your queries in real-time.

In this tutorial, Brian is going to demo how you can use the Performance Analyzer tool to Continue reading “How To Use The Performance Analyzer Tool In Power BI To Debug DAX” →

Session 25: ChatGPT & The Future Of Learning Data Skills

When is it?
February 23rd – 3pm Los Angeles (PST), 6pm New York (EST), 11pm London (GMT)
February 24th – 10am Sydney (AEDT), 12pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay & Brian Julius

During This Free Event, You Will:

• Learn what we think about ChatGPT
• See how it can compliment your learning journey
• How can you use AI tools right now!
• What’s the future of ChatGPT and its integration with MS tools

If Continue reading “ChatGPT & The Future Of Learning Data Skills | Innovations In Power BI & Power Platform Summit” →