← Back to Projects

Excel-Macro Automated Reporting Tool

End-to-end automation solution that streamlines data cleaning, validation, SQL job execution, and report generation with automated email notifications.

Key Features

  • Python watchdog script that monitors folders for new source files
  • Automated data validation and cleaning with pandas DataFrame
  • BigQuery SQL execution for data extraction and SLA evaluation
  • User-friendly Excel UI for non-technical users
  • Automated email delivery with error handling

Technologies Used

Excel VBA
Python
pandas
SQL (BigQuery)
Automation

Results

  • Reduced manual workload by 40%
  • Improved data delivery consistency
  • Eliminated manual cleanup, renaming, and emailing tasks
  • Now used by operations teams with no coding required
Project Overview

Project Overview

User Interface

UI & Entry Point

File Sweep

Automated File Sweep

Python Script

Validation Script

SQL Logic 1

SQL Classification Pt 1

SQL Logic 2

SQL Classification Pt 2

Email

Email Automation

Takeaways

Project Takeaways