TOP N in Power BI
Understanding TOP N in Power BI You have heard of the 80:20 rule (Pareto)? In the world of data analysis, having the ability to efficiently rank and prioritize information is crucial. This is where the TOP N function in Power BI comes into play. By utilizing this powerful ranking function, analysts and data professionals can […]
SAMEPERIODLASTYEAR in Power BI
How to Use SAMEPERIODLASTYEAR in Power BI SAMEPERIODLASTYEAR in Power BI is great way to simplify the analysis of year over year performance One of the most common tasks in data analysis is to compare the performance of a business or a process over time. For example, you might want to see how your sales […]
Power BI Drill Through
Understanding Drill Through in Power BI and How to Use it to Dig Deeper into Your Data Introduction: What is a Drill Through in Power BI and What Does It Do? Drill Through in Power BI is a powerful feature that allows users to explore their data in greater depth. It enables users to drill […]
Toggle Measures in Power BI
Space on your dashboards is a limiting factor To make the best use of limited space setting up toggle measures in Power BI helps to use the space better One of the key challenges with dashboard building is finding the balance between detail and available space This article shows you how to combine a couple […]
Rolling Averages and Rolling Sums in Power BI
Why are rolling averages useful Rolling averages and Rolling totals are used when analysing data over time Rolling averages smooth out fluctuations across the number of periods Both of these are possible in Power BI if you know the steps involved How to create rolling averages in Power BI Power BI has a really helpful […]
What are Power BI Template Files?
What are Power BI Template Files Power BI report templates are a type of file that is designed to be the starting point for report creation, they are also known as .PBIT files due to their file extension or simply pbit files Power BI report templates contain all the components of a report, from data […]
Sparklines in Power BI
This short guide to sparklines in Power BI tells you what they are, how they can be very useful and how to add sparklines to your power BI reports What are Sparklines? Sparklines are a very compact, space efficient way to show a trend behind a headline number. This tells you whether to investigate […]
How to use Power Pivot in Excel
Part 2 – Excel Power Pivot How to use Power Pivot in Excel for data modelling and analysis This follows on from our previous post How to use Power Query What is Power Pivot in Excel Power Pivot is a cutting-edge data modelling technology, It empowers you to create data models, establish relationships, and perform […]
Power BI RELATED Function
What is the Power BI RELATED function The Power BI RELATED function is a powerful tool that allows users to quickly and easily access related data from a related table It is similar in many ways to using lookups in Excel (VLOOKUP), Excel users wanting to learn this function will find the syntax fairly intuitive […]
How to use Power Query
How to use Power Query and Power Pivot for data modelling and analysis Whilst Power BI is known for its advanced data modelling and ability to transform data. You may not know that many of these functions are available in Excel. These Blogs aim to give you the knowledge or skills to use these, namely […]
