Bookshelf Project
Dec 2025 - Jan 2026
Category: Work Project
Python Used in 4 projects
pip Used in 3 projects
Power BI Used in 5 projects
VBA Used in 4 projects
Excel Used in 5 projects
VS Code Used in 22 projects
Description
This project was built for a vehicle program that was paused where the customer wanted the progress and data saved for possible use again in the future.
My implemented solution used a VBA script to loop through mapped SharePoint sites and generate a CSV of the sites structure, storing folder and file meta data.
The CSVs were then passed through a Python script, which used fuzzy matching to generate a set of tags for the files and clean any data ready for the Power BI report.
A Power BI report was then built to display the various SharePoint data, using filters for site location, tags and file types to allow the user to sift through the data. Users could search the database of folders and files using their own search text and could follow the URL links to the specific item.
My implemented solution used a VBA script to loop through mapped SharePoint sites and generate a CSV of the sites structure, storing folder and file meta data.
The CSVs were then passed through a Python script, which used fuzzy matching to generate a set of tags for the files and clean any data ready for the Power BI report.
A Power BI report was then built to display the various SharePoint data, using filters for site location, tags and file types to allow the user to sift through the data. Users could search the database of folders and files using their own search text and could follow the URL links to the specific item.
Lessons Learned
This project taught me how to use fuzzy matching with the correct fine tuning to extract usable tags from a list of data.
It also helped me improve my Power BI skills, ensuring I set up the project from start to finish rather than modifying an existing report as had previously been the case.
It also helped me improve my Power BI skills, ensuring I set up the project from start to finish rather than modifying an existing report as had previously been the case.