Portfolio

Simon Harrison ACMA CGMA | LinkedIn

How to use drill through in Power BI This under 1 minute demo shows how quickly and easily it can be set up, allowing your report users to explore and drill into the detail behind the numbers https...

Use double click to select a single 'word' in SQL Server management studio or triple click to select the whole row https://youtu.be/yS7yxapLWxA for more SQL Tips visit our tips page https://selectd...

Bring your Power BI reports to life with custom tooltips Add graphical richness with pop up graphical tooltips which help you to explore the data Watch the video to see examples and see how it's do...

How to find and eliminate duplicate values using SQL SELECT DISTINCT This guide also shows how to use COUNT DISTINCT too SQL Tips Select Distinct https://youtu.be/aTvx5hWbPfo #SQL

How to split a column in SQL This simple example walks you through the steps involved using a column with a First and Last name and shows you how to split these into two separate columns https://yo...

How to connect Excel to SQL Server This short clip shows you how to set up Excel so it can be connected directly to a SQL database, with the ability to refresh the data A great starting point for p...

It was great to get back to on-site customer workshops with a well known consumer brand this week The 5:50 train to King's Cross was very quiet A day of Data Warehousing, Business Intelligence and ...

Celebrating the milestone of passing over 1000 views on my YouTube Channel Sharing Tips and Timesavers for SQL, PowerBI, Excel and Tableau https://www.youtube.com/channel/UC_DiGjuhpRbv6fE8cqD4QBg #...

Here is our YouTube channel where we share Hints, Tips and Timesavers for SQL, PowerBI, Tableau and Excel https://www.youtube.com/channel/UC_DiGjuhpRbv6fE8cqD4QBg If you have any you would like us ...