It is essential to have a good understanding of variables and the data model. Variables allow you to store and manipulate data in Power BI, while the data model is the backbone of any Power BI report, representing the relationships between your data tables. This is crucial when it comes to analyzing seasonal trends in your budget information, as you will need to be able to filter and aggregate data by specific time periods. In this video, Sam showcases working with seasonal budget allocations in Power BI.

*****Video Details*****
00:00 Introduction
03:10 Budget allocation
04:43 Budget allocation with weightings
05:54 Total budget
06:37 Continue reading “Dealing With Seasonal Budget Allocations in Power BI [2023 Update]” →

Percent profit margins can be used in an organization to measure the profitability of its products or services. It is calculated by dividing the profit by revenue and multiplying by 100. This metric can help data analysts identify which products or services are more profitable and which ones need improvement.

By tracking changes in profit margins over time, analysts can also monitor the effectiveness of cost-cutting measures or pricing strategies. In this video, Sam will show how you can calculate percent profit margins in Power BI using DAX.

*****Video Details*****
00:00 Introduction
00:40 Data model
01:56 Total sales
02:20 Total costs using iterating function
03:14 Total Continue reading “How To Calculate Percent Profit Margins In Power BI [2023 Update]” →

The CALCULATE and TOPN combination is a powerful technique in data analysis that allows users to easily and efficiently discover insights within large datasets. By utilizing this technique, analysts can automate the process of identifying patterns and trends in their data, which historically would have required extensive manual effort and time investment.

This technique is particularly useful for data analysts who need to identify key trends and patterns in large data sets quickly and efficiently, making it a valuable tool in business decision-making scenarios where time is of the essence. In this tutorial, Sam will demonstrate how you can apply Continue reading “Find Your Top 3 Salespeople Per Region Automatically In Power BI Using DAX [2023 Update]” →

Today’s episode features Gilbert Quevauvilliers, an expert in the field of Business Intelligence and Data Analytics. He has been in the industry since 2009 and has been an early adopter of Power BI, which he has been using for many years in his consulting and various engagements. His expertise spans across the data stack, from multidimensional cubes to the tabular model, and he has continuously kept himself up-to-date with the latest technologies.

Starting off in a large company in Durban, South Africa, he has decided to specialize in the Microsoft ecosystem and has built a wealth of knowledge and experience Continue reading “Unlocking the Power of Data Architecture and Data Pipelines with Gilbert Quevauvilliers” →