Overview

This project involved creating an automated operational reporting system. By integrating Pivot Tables, Power Query, and VBA, I transformed a manual 4-hour daily task into a single-click refresh process, ensuring high data integrity and efficiency.

Core Tech

The Challenge

The primary hurdle was the inconsistent formatting of raw data exported from legacy ERP systems. I utilized Power Query's transformation engine to clean, normalize, and merge these datasets before feeding them into the dynamic dashboard components.