Script Automation
Automating data input, calculations and output to reduced time spent on reoccurring reports
Status:
Categories:
Data Engineering, Data Science, Data Analysis
Technology:
Python, Adobe Analytics, TeamCity
Links:
TEAM:
- Critical Mass
Overview
- 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.
Solution
- 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.
Results
- Reduced 60% of time spent on data collection, calculations and dissemination.
Learnings
- Limitations on Team City limit what you can automate.
- Database management and maintenance is crucial.
You might Also Like
Data Engineering, Data Science, Data Analysis
Performance Forecasting
An annual deliverable to predict website traffic and set performance targets
Read More
UI/UX Design, Development
Website Restructure for Transmedia Zone
The incubator for innovation in storytelling, media and the creative industries
Read More
UI/UX Design, Data Analytics, Research
Digital Media for an Energy Utility Company
Social media management to enhance brand identity
Read More