Select Distinct Limited
Business Analytics Simplified
- Location
- Sheffield, United Kingdom
- Website
- https://www.selectdistinct.co.uk
Projects credited in
- Show Values in Rows in a Power BI MatrixThe Matrix visual in Power BI is similar to a Pivot Table in Excel, but not quite as intuitive, which can lead to many users being frustrated by an apparent lack of a way to do something which is straight forward in Excel This quick guide shows y...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with Show Values in Rows in a Power BI Matrix
Required- Simon Harrison Analytics Director
- LEAD and LAG functions in SQLLead and Lag functions are essential tools for data analysis with SQL. These window functions allow users to compare and analyse data points between rows in a specified window Great for Inventory Opening and Closing Stock Calculations #SQL #SQ...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with LEAD and LAG functions in SQL
Required- Simon Harrison Analytics Director
- Change the Data Source in Power BIHow to easily change the data source in Power BI from a CSV to a SQL connection This quick guide shows you have to change the connection without breaking existing visuals, calculations and measures https://www.selectdistinct.co.uk/2023/02/13/ch...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with Change the Data Source in Power BI
Required- Simon Harrison Analytics Director
- Calculate Running Totals in SQL ServerCalculate Running Totals in SQL Server A running total calculation is a powerful technique to show what the balance was at at the time of a transaction This quick guide shows you how https://www.selectdistinct.co.uk/2023/02/06/calculate-running...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with Calculate Running Totals in SQL Server
Required- Simon Harrison Analytics Director
- How to Filter in ExcelFilters are a powerful tool in Excel that can help you quickly organize and analyse large data sets Use filters to quickly home in on the data you need to see https://www.selectdistinct.co.uk/2023/02/06/how-to-filter-in-excel/ #excel #excelfilt...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with How to Filter in Excel
Required- Simon Harrison Analytics Director
- Remove Carriage Returns in SQL SSMSIf you're like most people, you probably spend a lot of time editing your SQL code in Microsoft SQL Server Management Studio Did you know that you can use find and replace functionality to speed up the process? Here's how https://selectdistinct...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with Remove Carriage Returns in SQL SSMS
Required- Simon Harrison Analytics Director
- How to Create Pivot Tables in ExcelPivot tables are an incredibly powerful tool in Microsoft Excel This quick guide shows you how to get started https://www.selectdistinct.co.uk/2023/01/26/how-to-create-pivot-tables-in-excel/ #excel #pivottables #dataanalysis
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with How to Create Pivot Tables in Excel
Required- Simon Harrison Analytics Director
- How to sort dates correctly in Power BIYou can sort one column by the values of another column in Power BI This is really useful when you want to show month names but in chronological order, just sort the month name column by the month number This quick guide shows you how https://...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with How to sort dates correctly in Power BI
Required- Simon Harrison Analytics Director
- How and Why to use line numbers in SQLHow and why to use line numbers in SQL Server Management Studio Showing Line Numbers in SQL is very easy, just set the option once and it will keep the settings, continuing to help you find your way quickly around SQL code https://www.selectdi...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with How and Why to use line numbers in SQL
Required- Simon Harrison Analytics Director
- Connect Excel to SQL ServerLooking for a way to connect Excel to your SQL Server and refresh your data in real-time? Look no further! With the right groundwork in place, you can create an SQL dashboard that will make it easy to identify trends, make data-informed decision...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with Connect Excel to SQL Server
Required- Simon Harrison Analytics Director
- Make your Power BI Reports POP with Visual TooltipsWant to add some extra visual flair to your Power BI reports? Try using visual tooltips! By hovering over a data point, you can add a tooltip that displays additional information or even a different visual. It's a great way to add more context and...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with Make your Power BI Reports POP with Visual Tooltips
Required- Simon Harrison Analytics Director
- Our top 5 Power BI time saver videos of 2022Our top 5 Power BI time saver videos of 2022 https://selectdistinct.co.uk/2022/12/27/top-5-power-bi-timesavers-2022/ Ranked by most watched on YouTube with Data Visualisation best practice being our top video of 2022 #powerbi #datavisualization
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with Our top 5 Power BI time saver videos of 2022
Required- Simon Harrison Analytics Director
- Conditional Format a line chart in Power BIThis is a workaround to show you how you can conditional format a line chart in Power BI. Power BI does not at first seem to have an option to add conditional formatting to a line chart, but, there is a way to make it work, although it takes a fe...
Join our Pro Plan to create your first list
Lists are an easy way to organise the talent and inspiration that you’ll find on The Dots. Find and save people to as many lists as you want and then manage them all in one place.
If you’d like to start creating lists, simply join our Recruiter Pro Plan.
Create new list with Conditional Format a line chart in Power BI
Required- Simon Harrison Analytics Director
About
We are experts in business analytics and business intelligence solutions to help you spark change, and achieve results quickly and easily Business Analytics Simplified by focusing on what matters and sharing our expert knowledge with your team We help you to turn your data into actionable insights. Financial Planning and Analysis, Data Management and Business Intelligence.