Nextel: Data Wrangling
Problem-Solving in Action
Problem:
I frequently worked with large datasets from multiple sources including data from the point of sale (POS) systems of 750+ retail stores, and financial and inventory data from Oracle. Data reports often came in different file formats with inconsistent headers and spacing, making manual data cleaning time-consuming.
Solution:
I developed VBA macros to automate repetitive tasks in the processes of preparing data for analysis. This ensured accuracy and consistency across reports and allowed for faster decision-making and better insights into store operations.
VBA Macro Automation:
Cleaned up imported data by removing duplicate headers and unnecessary spacing.
Split data into columns using Excel’s Text to Columns feature.
Merged the cleaned data from different sources into a unified financial model.
Split data into columns using Excel’s Text to Columns feature.