SQL Server Date Handling
Working with dates in sql is one of the most challenging parts of data manipulation. In this blog we aim to describe some of the complexities of date handling in SQL Server. Data Types Prior to Microsoft SQL Server 2008 the only data types available were datetime or the smalldatetime. With the launch of SQL […]
How and Why to Modernise Your Data Reporting
This blog aims to discuss the how to modernise your data reporting from legacy reports. By legacy reporting we are referring businesses functioning with multiple disparate Excel reports. What are the benefits of moving? How do you go about moving? Why move from Legacy Reports? 1. Improved Efficiency: Over our years of experience, we have seen many […]
Navigating Power BI Data Alerts
Introduction Whilst reporting is a key component of any business, how do you respond to key changes. How do you ensure actions are generated when the data changes beyond the limits you set. As part of our Business Support Expert Services this can be a really efficient way to set up reports to monitor values […]
What is Microsoft Fabric? A Guide by Select Distinct Limited
Introduction Microsoft Fabric, the unified environment launched in 2023 is now central to Microsoft’s data strategy. What is the Microsoft Fabric Offering? Who are Microsoft’s competition to this software? What other unified environments are available. This blog aims to demystify some of these areas. What is the Microsoft Fabric Offering? Microsoft Fabric brings together multiple […]
Overview of Robotic Process Automation (RPA)
Introduction Robotic Process Automation (RPA) is a software technology that automates repetitive tasks using software robots. RPA is sometimes referred to as software robotics and is a form of business process automation. The purpose of RPA is to streamline workflows, reduce the time and effort required to complete manual tasks, and improve accuracy. In this […]
ETL vs. ELT: What’s the Difference?
Introduction We often get asked both these questions. What is ETL? and what is ELT? ETLs and ELTs are two data integration processes. Both are used to extract, transform, and load data from one or more sources into a target system. The target could include a database, data warehouse or data lake. ETL stands for […]
Difference between a Data Lake and a Data Warehouse
Data Lakes v Data Warehouses Data lakes and data warehouses store and manage data. They differ in their architecture, usage, and capabilities. In this blog, we will explore the key differences between a Data Lake and a Data Warehouse. To help you choose the one that best fits your needs. What is a Data Lake? […]
Components of the Business Analytics Stack
Introduction: In the dynamic landscape of modern business, data has become the cornerstone of informed decision-making. The ability to transform raw data into actionable insights has given rise to the indispensable Business Analytics Stack. This integrated framework plays a pivotal role in unravelling patterns, trends, and opportunities buried within the vast sea of information, empowering […]
How to use a CTE in SQL
Introduction – What is a CTE in SQL? CTEs in SQL are a way to simplify code by creating a temporary dataset, giving it a name, then referencing that dataset later in your query You can use Common Table Expressions (CTEs) as temporary named result sets within a SELECT, INSERT, UPDATE, or DELETE statement. You […]
Business Analytics Process
Introduction Business analytics involves utilizing data, methodologies, and tools to derive insights that assist organizations in reaching their objectives. It is crucial for organizations as it enables them to: – Comprehend their present performance and pinpoint areas for enhancement. – Forecast upcoming results and trends to make informed preparations. – Streamline their operations and resources […]
