Report & Input File Automation
NielsenIQ
5 months
Automation
Colaborators
Project Overview
The manual creation of shop characteristic for each new stores consumes a lot of time. Additionally, the current production process dont 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 sign off date and time
Analyze 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.
