Analysis
Harnessing Data to Enhance Market Engagement in UK Public Procurement
Data has become a cornerstone in almost every sector, and public procurement is no exception. In the UK, public procurement is heavily regulated, with an emphasis on transparency, fairness, and efficiency. The...
Bayesian Probability Theory and Its Relevance to Public Sector Procurement in the UK
Bayesian probability is a fascinating and powerful concept within the world of statistics and decision-making. Named after the 18th-century mathematician Thomas Bayes, this theory offers a unique way of thinking about probabilities,...
Process Mining Using Power BI
Power BI is a versatile business analytics tool that can be used for process mining when combined with event logs and process mapping techniques. This guide will walk you through how to...
Modelling and Simulation: A Foundation in Discrete Events and Iterative Systems and uses in UK health procurement and supply chain
In today’s world, modelling and simulation (M&S) have become indispensable tools in a wide range of fields, including engineering, healthcare, economics, and environmental sciences. These tools allow us to create representations of...
Data Enrichment in Spend Analytics: Leveraging Machine Learning for Enhanced Product Attributes
In the era of big data, organisations are increasingly reliant on spend analytics to make informed decisions and drive efficiencies. Spend analytics involves the collection, categorisation, and analysis of expenditure data to...
PPE distribution UK 2020 – 2023
The distribution of Personal Protective Equipment (PPE) in the United Kingdom during the COVID-19 pandemic, spanning from 2020 to 2023, marked a critical component in the nation’s public health response to the...
Enhancing Data Accuracy in Public Sector Purchase Orders with Excel’s Power Query and Fuzzy Clustering
In the public sector, managing purchase order data is a critical task. With numerous descriptions, suppliers, and item codes, maintaining accuracy and consistency can be a daunting task. This is especially true...
Unleashing the Power of AI Chatbots in Data Interaction
In the rapidly evolving landscape of data analysis and management, Artificial Intelligence (AI) chatbots have carved a niche for themselves. These chatbots, equipped with Natural Language Processing (NLP), are revolutionising the way...
Utilising Chat GPT API to Analyse a Power BI Dataset with Power Automate
After a bit of tweaking and reading GPT API documentation I have created a simple process to integrate GPT into live analysis of data within PowerBI. Leveraging a fully-functioning flow that integrates...
Revolutionizing Procurement: Harnessing the Power of Data, Business Intelligence, and Emerging Technologies for Cost Savings and Efficiency
The role of data in procurement has become increasingly important in recent years, as companies seek to optimize their supply chain and reduce costs. This white paper/ article explores the process of...
Fuzzy Lookup (Excel)
The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel. Its a free excel plugin and is available to download here.
