What are the opening hours?

Monday 9am - 5pm Tuesday 9am - 5pm Wednesday 9am - 5pm Thursday 9am - 5pm Friday 9am - 5pm

Select Distinct Limited

Name: Select Distinct Limited
Address: Worksop Turbine Innovation Centre, Triangle Business Park, Shireoaks, S818AP, GB
Telephone: +441909512187

Home
United Kingdom
Shireoaks
Select Distinct Limited

Management Accounting, Data Analytics and Business Intelligence. SQL, PowerBI, Excel, Tableau

30/04/2026

Mapping the UK Data Job Market

We built a Power BI dashboard to analyse 1,726 active vacancies from reed.co.uk to identify the latest trends in the UK data industry.

What the data reveals:
The Remote Premium: Impact of working patterns on market compensation.
Regional Strategy: Career stability in high-growth hubs outside London.
Salary Benchmarks: Pay scales from entry-level through to senior management.
High-Demand Sectors: Leading industries for Data Analytics and Engineering hiring.
Actionable Data: Using "Drill Through" features to find live job leads from market trends.
Explore the interactive dashboard:👉
https://www.selectdistinct.co.uk/2026/04/30/uk-data-job-market-power-bi-analysis/

View the full job adverts and apply directly on reed.co.uk by clicking through from the dashboard!

16/04/2026

Ever felt the pain of a Power BI map "teleporting" your data across the globe? ✈️🌍

We recently tackled a project where UK job locations were popping up in Melbourne, Australia instead of Melbourne, Derbyshire. Not exactly the "insights" our client was looking for!

We solved the geographic chaos using a two-pronged approach:

1️⃣ AI Classification: Using Vertex AI to strip away "data noise" and categorize locations into City, County, and Region.

2️⃣ The DAX "Anchor": Building a robust geographic hierarchy that forces Power BI to look at the full context, ensuring every point stays exactly where it belongs.

The result? 100% Map Accuracy and a much cleaner user experience. 🎯

Check out the full technical breakdown and grab the DAX code for your own reports here:

👇

https://www.selectdistinct.co.uk/2026/04/15/fix-power-bi-map-errors/

02/04/2026

If you’ve ever tried to pull Outlook mailbox data into Excel, you know how messy it can get! 😅
I’ve put together a quick, easy‑to‑follow guide showing how to export your mailbox using Power Query and turn it into clean, structured data you can actually analyse.
Perfect for reporting, dashboards, or just making sense of your emails.
Take a look 👇
🔗 Read the full guide:
https://www.selectdistinct.co.uk/2026/03/31/export-outlook-mailbox-to-excel-power-query/

19/03/2026

🧬 Data Intelligence + Family History = Data Genealogy?
Most days, I’m deep in SQL and Power BI, solving complex data lineage problems for businesses. But recently, I decided to point those same professional lenses toward something closer to home: my family history in Sheffield.
I’m calling it "Data Genealogy."
It’s been a fascinating exercise in treating 19th-century historical records as unstructured data—applying the same rigour we use in business intelligence to map out the family history.
The principles are identical: ✅ Accuracy over assumption ✅ Verification of the "Source of Truth" ✅ Visualising the connection points
I’ve just shared the first look into this project. If you're into data, Sheffield history, or just a good detective story, have a read! 👇
Link: https://www.selectdistinct.co.uk/2026/03/18/harrison-archive-data-genealogy-sheffield/

12/02/2026

BigQuery: Find Duplicates Using WHERE, QUALIFY and HAVING

We’ve all run into duplicate records that skew metrics and make SQL models harder to maintain. I’ve put together a clear walkthrough on how to clean them up in BigQuery using WHERE, HAVING and the QUALIFY clause — a much cleaner way to filter window functions without subqueries.
If you work with analytics, BI or dbt, this guide gives you simple patterns for finding duplicates, keeping the latest record, and writing cleaner SQL.
Read the full post here:

https://www.selectdistinct.co.uk/2026/02/12/finding-duplicates-using-where-having-qualify/

05/02/2026

Power BI Tip: Grouping & Binning Made Simple
We’ve just shared a quick guide on how Grouping and Binning can make your Power BI visuals clearer and easier to understand.
If you’re working with long category lists, detailed visuals, or numeric fields that would benefit from tidy ranges, these tools can help you present insights in a more intuitive way.
Read the full walkthrough here:

https://www.selectdistinct.co.uk/2026/02/05/grouping-and-binning-in-power-bi/

22/01/2026

New Power BI Tutorial: Build a Live Weather Dashboard
We’ve put together a beginner‑friendly guide showing how to build a live weather dashboard in Power BI using the free Open‑Meteo API — no API key needed.
It walks through the full process:
• Connecting Power BI to a live JSON API
• Using simple M code to shape the data
• Creating KPI cards and hourly trend charts
• Adding a Time‑of‑Day slicer
• Designing a clean, modern dashboard layout
If you’re learning Power BI or want a practical project to build your skills, this is a great place to start.
Read the full guide on our blog:

12/01/2026

New on the blog: Understanding Power BI Filters

If you’re building dashboards in Power BI, knowing how filters work is essential. Our latest guide breaks down the three key filter types — visual‑level, page‑level, and report‑level — with simple explanations to help you choose the right one every time.

Perfect for beginners, trainers, and anyone creating consistent, reliable reports.
👉 Read the full guide:
https://www.selectdistinct.co.uk/2026/01/08/power-bi-filters-explained-visual-page-report-level/

10/11/2025

🧠 New from Select Distinct: The Power BI Glossary is live!
If you’ve ever felt lost in Power BI terminology, this is for you. We’ve created a modular, visual glossary that breaks down key terms into clear definitions—with dashboard-ready examples and commentary blocks you can actually use.
✅ Easy to navigate
✅ Built for analysts, creators & learners, beginner friendly
📘 Explore the full glossary here:

selectdistinct.co.uk/2025/11/10/introducing-our-new-power-bi-glossary

💬 Got a term you’d like added? Drop it in the comments or message us directly.

30/10/2025

Power BI tip for smoother dashboards!
Ever had your table columns jump around when switching slicers? That’s auto column width at work — and it’s breaking your layout.
In this quick tutorial, we show you how to disable auto column width so your visuals stay consistent, branded, and client-ready.
✨ Perfect for: • Financial dashboards
• SME reporting packs
• Branded commentary blocks
📌 Read the full post:
https://www.selectdistinct.co.uk/2025/10/29/how-to-disable-auto-column-width-in-power-bi/

Save this for your next dashboard build!

Address

Worksop Turbine Innovation Centre, Triangle Business Park
Shireoaks
S818AP

Opening Hours

Monday	9am - 5pm
Tuesday	9am - 5pm
Wednesday	9am - 5pm
Thursday	9am - 5pm
Friday	9am - 5pm

Telephone

+441909512187

Website

https://www.selectdistinct.co.uk/

Alerts

Be the first to know and let us send you an email when Select Distinct Limited posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Select Distinct Limited:

Shortcuts

Address
Telephone
Opening Hours
Alerts
Contact The Business
Claim ownership or report listing

Want your business to be the top-listed Business in Shireoaks?