Office Scripts and Power Automate in Microsoft 365 automate a daily Excel sales report, saving email attachments to OneDrive at midnight.
Turn Excel into a lightweight data-science tool for cleaning datasets, standardizing dates, visualizing clusters, and analyzing keywords.
This project implements an end-to-end stock data pipeline that fetches stock data from an external API, processes and transforms it using Python, stores it in a MySQL database, exposes the data ...
Abstract: Brunei Darussalam’s annual labour-force census has historically required months of manual cleaning across ~150,000 records and 60 fields. We developed an Excel-native automation that ...