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 […]
How to split a column in SQL Server
This quick guide shows you how to split a column in SQL Server This can be a very common problem, but with a few commands it is easily achieved The guide shows you step by step how to split one column into multiple columns in SQL Server. You can copy the code and work through […]
How to use Transpose in Excel
What is the TRANSPOSE function in Excel The TRANSPOSE function in Excel enables users to easily switch between vertical and horizontal ranges of cells. It is used to rearrange data so that it can be more efficiently read and analysed. With its versatility, the function assists with quickly converting two-dimensional cell ranges without having to […]
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 further […]
The Select Distinct Statement in SQL
One of the most useful functions in SQL is the SELECT DISTINCT statement *The SQL function which inspired our company name Introduction to the SELECT DISTINCT statement in SQL The SELECT DISTINCT statement is used to return only unique values from a table. Inside a table, a column often contains many duplicate values, and sometimes […]
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 […]
Is Your Management Information Future Ready
Is Your Management Information Future Ready? How would you know if you are asked the question? This post outlines the questions to ask to give you a picture of future readiness Is your management Information able to grow with your business? As you grow, Is it getting harder to answer the business questions you have? […]
Double and Triple-Click in SQL Server
Double and Triple-Click in SQL Server are two very useful shortcuts to save you time and reduce errors This is one of the simplest and possibly most frequent timesavers we use in SQL Server Using Double-Click in SQL Double click is a SQL server shortcut that can save you time and effort when writing SQL […]
