Report & Input File Automation
NielsenIQ
5 months
Automation
Colaborators
Project Overview
The manual creation of shop characteristic for each new store consumes a lot of time. Additionally, the current production process doesn't involve tracking of sign-off by each team, which makes documentation for future reference harder. This automated ETL Pipeline using Power Automate and VBA Script is built to ensure efficiency in shop characteristic creation and timely tracker update during production
Objective
Automate manual shop characteristic creation
Monitor the duration of production by the sign-off date and time
Analyse the time saved during production
Skills & Tools Used
Outcomes
Developed an automation solution using VBA scripts and Power Automate to streamline the creation of multiple store characteristics and sales validations, significantly reducing processing time while ensuring timely sign-offs through automated production email tracking.
