Analysis
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.
