About me

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

PostsProjectsExperienceTeam

• 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

• What is Microsoft Fabric - a guide by Select DistinctLaunched in 2023, Microsoft Fabric integrates data engineering, data science, data warehousing, real-time analytics, and business intelligence into a single platform. Key components include: - Power BI: Advanced data visualization - Data Factory: Seamless dataflows and pipelines - Synapse Data Engineering: Large-scale data transformation - Synapse Data Science: Machine learning model deployment - OneLake: Industry-leading SQL performance and scalability Learn more about Microsoft Fabric and al
• Data Warehouse OverviewWhat is it? Why you need it? How to choose one About the different technologies, and how we can help you https://www.selectdistinct.co.uk/business-intelligence-expert-services/data-warehouse/ #datawarehouse #analytics #businessintelligence
• 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

+ View all

Work history

DirectorSelect Distinct Limited
Aug 2021Sheffield, United KingdomFull Time
Founder and Director of Select Distinct Limited A Business Intelligence Agency working with some great brands
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