Change the data source in Power BI

Sometimes you need to change the data source in Power BI from a static data source such as a CSV file to a SQL connection Here is an efficient way to do it to save you time and headaches This guide shows you a quick and easy way to make the change without having to […]

Running Totals in SQL Server

This blog post explains how to calculate running totals in SQL Server, why you would use them and provides a breakdown of the syntax What is a running total? A running total is a cumulative sum that takes all the values of a sequence and adds them together. It is also called a cumulative sum […]

How to filter in Excel

Filters are a powerful tool in Excel that can help you quickly organize and analyze large data sets. With filters, you can easily find the information you need without having to manually search through thousands of rows of data. In this blog post, we’ll discuss how to filter in Excel so that you can take […]

Remove Carriage Returns in SQL Server SSMS

How to Remove Carriage Returns in SQL Server Management Studio? It is a fairly common task, a lot of people manually select and remove carriage returns and new lines, which can take time and is error prone But you can use find and replace functionality built into SSMS to make the task more efficient This step […]

How to create Pivot Tables in Excel

This quick guide shows you how to create pivot tables in Excel What is a Pivot Table? Pivot tables are an incredibly powerful tool in Microsoft Excel, providing a dynamic and intuitive way to analyse, summarize, and manipulate large amounts of data. By using a drag-and-drop interface, users can quickly and easily create summaries from […]

How to sort dates in Power BI

Working with dates can sometimes be a little challenging, this quick guide shows you how to sort dates in Power BI Its not always obvious how to do simple things like sort months in calendar or chronological order Here we show some simple tips using a date dimension table If you want to know how […]

How to show line numbers in SQL Server Management Studio

Using Line Numbers in SQL (SSMS) Showing line numbers in SQL Server Management Studio is a simple tip that can really help users to quickly debug and find their away around  large SQL scripts Why use line numbers in SQL Server? The primary benefits from enabling line numbers in SQL Server Management Studio are Finding […]

How to Connect Excel to SQL Server

Connecting Excel to SQL Server is important because it allows you to have access to up-to-date information. You can connect many spreadsheets to a single trusted data source in SQL Server. Then you can use Excel to refresh the data to be kept in sync. Excel has powerful but simple features that can help you […]

Power BI Tooltips

Advanced Power BI Tooltips     Power BI by default gives you basic tooltips, which present you with the values included in your visual These are limited initially to the fields and values that have been used in creating that visual Add other fields into the tooltips You can easily add other fields by dragging […]

Drag and Drop Field Names in SQL (SSMS)

Drag and drop is a common and convenient way to move data and objects in SQL Server Management Studio (SSMS). With the object explorer, you can easily drag field names from a table.  Then drop them into a query window to quickly create a SELECT statement. How to drag and drop field names in SQL […]