UNPIVOT Function in SQL

How to Unpivot a Table in SQL Server The Power of  the Unpivot function in SQL : How to Convert Columns into Rows in SQL Server with One Simple Operator     Have you ever encountered a table that has too many columns and not enough rows? A table that looks like this:   This […]

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 […]

PIVOT function in SQL

Introduction to the PIVOT function in SQL The PIVOT function in SQL can be used to create a dataset with aggregated rows from a list of data This post shows you how to transform a table of data like this Into a summary table of data with a column representing each month If you are […]

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 […]

CASE statements in SQL

What are Case Statements in SQL Case statements are a very powerful tool for an analyst Allowing you to add your own dynamic data classification, cleanse and structure data In SQL, CASE statements allow you to check for various conditions and return a value if a condition is met. CASE statements always begin with the […]

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 […]

Change The Column Order in SQL Output

Did you know that you can easily change the column order in the SQL output grid in SQL Server Management Studio This nano tip shows you one of the hidden features you may not know about in SQL Server Management Studio (SSMS) Have you ever run a query, then wished you had specified the columns […]

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 […]

How to use Format Painter in Excel

What is Format painter in Excel Format Painter is a tool in Excel that allows you to copy formatting from one cell or range of cells and apply it to another cell or range of cells. This can save you time when you want to apply the same formatting. For example, if you have a […]