Automating data input, calculations and output to reduced time spent on reoccurring reports
Data Engineering, Data Science, Data Analysis
Python, Adobe Analytics, TeamCity
- Critical Mass
- There exists multiple reports that client expects on a daily, weekly or monthly cadence which makes up 2-3 analyst's time.
- ~20 hours is spent on reoccurring reports each week.
- Implemented python scripts to handle retrieving data inputs, perform tedious calculations and provide a formatted output for reporting purposes.
- Managed existing ones and migrated them to a TeamCity implementation or centralized them on a remote desktop for easy team handoff.
- Reduced 60% of time spent on data collection, calculations and dissemination.
- Limitations on Team City limit what you can automate.
- Database management and maintenance is crucial.