Business Analytics, Tips and Timesavers Blog
In our Business Analytics Blog, we talk about a wide range of topics.
From Business Analytics, to Tips and Timesavers for Microsoft Power BI. And tips and time-savers for SQL, including SQL Server Management Studio and Google Big Query. We also share practical tips for Excel.
As well as sharing our broader knowledge of Management Information, leadership, team building and mentoring
Categories
Tags
Tips and Timesavers
Our tips and time-savers are designed to share those little tricks and techniques that you wish you had known earlier.
Whether you are looking to learn about then benefits of data warehousing and what it can bring to your business. Or you are just looking for practical timesavers as an analyst, there is something for everybody
We hope you enjoy this blog, and if you have any questions or comments, please feel free to reach out!
Topic Filters
You can filter using these tags to find the content you like, newest posts will be shown first
Power BI & Azure ERP Dashboards: Agriculture Analytics
Select Distinct integrated Azure and ERP data into Power BI for an agricultural leader. We delivered real-time analytics across the supply chain, from crop yields to distribution, empowering the business with a single source of truth for enhanced operational planning and forecasting.
Power BI Reporting for Sales, Returns & Inventory
Select Distinct developed an integrated Power BI dashboard to unify sales, returns, and inventory data. We provided real-time visibility into stock health and return rates, enabling data-driven procurement and reducing waste for a more profitable, streamlined supply chain.
Subscription Analytics Dashboard: BigQuery & Looker Studio
Select Distinct helped Ultima Media transform fragmented subscription data into a central Power BI dashboard. We automated reporting, cutting manual work by 80% and delivering real-time insights into subscriber churn and engagement for faster, data-driven decisions.
Power BI Security Strategy for a Creative Marketing Agency
Select Distinct implemented a robust Power BI security strategy for a creative agency, ensuring Row-Level Security (RLS) and governance across client reports. This solution protects sensitive data while enabling secure, scalable collaboration with external stakeholders.
Power BI Sales Reporting for Prospect 365 CRM
Select Distinct transformed Prospect 365 CRM data into high-impact Power BI sales reports. By unifying customer and inventory data, we enabled real-time visibility into sales performance, customer trends, and growth opportunities, driving faster, data-backed decisions for distributors.
GA4 Reporting Rebuild: BigQuery URL Mapping & Looker Studio
Select Distinct rebuilt a global GA4 reporting suite by connecting Google BigQuery to Power BI. We overcame GA4’s API limitations to deliver high-performance, real-time dashboards that provide deeper marketing attribution and user behaviour insights for data-driven teams.
Power BI Mentoring for Learning & Development Reporting
Select Distinct delivered tailored Power BI mentoring for a social care provider, empowering their team to build custom dashboards. We focused on data literacy and KPI tracking to improve operational efficiency and care quality through sustainable, internal expertise.
Revolutionising Business Intelligence for a Global Beauty Leader
Select Distinct automated global reporting for a beauty industry leader, replacing manual Excel workflows with a scalable Power BI architecture. We delivered real-time visibility into international sales and inventory, driving operational efficiency across multiple global markets.
How To Find Duplicates in BigQuery Using WHERE, QUALIFY and HAVING
Duplicate rows can quietly break your reporting, and knowing which SQL clause to use makes all the difference. This guide walks through how WHERE, HAVING, and BigQuery’s QUALIFY each handle filtering, especially when window functions are involved. With clear examples and reusable patterns, it shows exactly how to identify, rank, and remove duplicates in a clean, modern way.
Select Distinct: Solve What Matters, Software Comes Second
At Select Distinct, we start with the real problem — not the software. Our solution‑first approach focuses on clarity, empathy, and sustainable design, creating reporting and processes that genuinely make work easier.
Grouping & Binning in Power BI
Learn how grouping and binning in Power BI help you turn raw values into clear, meaningful ranges. This guide shows how to segment data, reveal patterns, and add cumulative views for deeper insight across sales, expenses, operations, and customer behaviour.
From API to Dashboard: Create a Live Weather Report in Power BI
Build your first live data dashboard in Power BI. This guide shows you how to connect to a free weather API, shape the data, and create clean KPIs and trend visuals — no API key required.