About me

Trusted by the biggest brands to deliver real value from their data (People, Process, Technology) Accounting and Analytics #PowerBI #Tableau #SQL

QuestionsProjectsExperienceTeam

• CASE statements in SQL
• How to use Format painter in Excel
• Save time if you need to add commas to separate a list of fields in SQL

+ Show more

Projects

• Using Custom Formats in Power BIPower BI comes ready loaded with a wide range of format options But did you know that you are not limited to the pre-defined options Some organisations have specific standards for things such as date formats, these can be catered for using custom formats https://www.selectdistinct.co.uk/2023/07/20/custom-formats-in-power-bi/ #powerbi #dataviz #customformats
• Business Analytics ServicesNeed to improve your business intelligence, to become more data driven? Worried you don’t have the right tools or expertise? We can help. Whether it’s data integration, data visualization, data analysis, or data governance. Or just using it all better We can help you get what you need from your data https://www.selectdistinct.co.uk #selectdistinct #businessanalytics #data
• 1

  Automatically reformat SQL code with this great free toolAt Select Distinct we love to share tips and timesavers to help you become more efficient, and when we find great tools we love to share this knowledge (We have no affiliation to this product or site and get no commercial benefit from it) PoorSQL.com is a great free resource that we found out about from one of our clients, it takes away one of the most time intensive steps that we often come across, that is taking some badly formatted SQL and improving its formatting before you can start to un
• How to create Rolling Averages and Rolling Sums in Power BIFollow this guide to smooth out your fluctuations using DAX Rolling Averages and Rolling Sums in Power BI - Select Distinct #rollingsums #rollingaverages #powerBI #DAX
• 1

  Do you want to compare your data from the same period last year in Power BI?You can use the SAMEPERIODLASTYEAR function to do it easily and accurately. SAMEPERIODLASTYEAR returns a table of dates shifted one year back in time from the dates in your data, so you can compare the performance of your business or process over time. You can use it with other DAX functions and visuals to create various types of reports and dashboards. Check out our blog post to learn more about how to use SAMEPERIODLASTYEAR in Power BI https://www.selectdistinct.co.uk/2023/06/08/sameperio
• 2

  What are Power BI template Files (.PBIT) and how to use themDesigned to help standardise your reporting, template files can be used to promote consistency and save a lot of time https://www.selectdistinct.co.uk/2023/04/20/what-are-power-bi-template-files/ #PowerBI #PBIT #PowerBITemplates

+ View all

Work history

S
S
Head of AnalyticsSports Direct
May 2008 - May 2018Shirebrook, Mansfield, UKFull Time
I was the head of analytics and operational finance, responsible for the data analysts to support all departments of the business

Skills

• Project Management
• Data Analytics
• Data Driven
• Accounting
• Business Intelligence
• SQL
• Tableau
• Spss
• Advanced Excel

Education

C
C
CGMAChartered institue for Management Accountants (CIMA)
May 2004 - May 2008Sheffield, United Kingdom