DIEGO MELENDEZ
Back to Projects

Reporting TV

2025
Context

For a media agency.

Problem

A monthly TV-audience report required ~2 hours of repetitive manual work.

Solution

A full automation that detects the source files, normalizes them, populates the report, applies a business reclassification rule, and applies filters and sorting. Runs from a keyboard shortcut.

Result

From ~2 h to 15 min per month (-87%), delivered in under 10 days.

Role

Data & AI Project Manager / end-to-end development.

Tech stack
  • Power Automate Desktop
  • Excel