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...
Improving Supplier Data for NHS Organisations: A Roadmap to Transparency and Efficiency
The National Health Service (NHS) stands as a testament to the power of public health. Its scale and reach mean it deals with an enormous volume of suppliers, each contributing 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...
The Role of Data and Analysis in Shaping the Recommendations of the Fuller Stocktake Report
The Fuller Stocktake Report, commissioned by NHS England, provides a comprehensive review of the current state of primary care integration within the UK’s healthcare system. The report’s recommendations, which are centred around...
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...