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

Development, Research
Human-Robot Collaboration
A wizard-of-oz experiment that incorporates the drama exercise, mirror game, to observe human-robot collaboration
Read More
Development, Data Analysis, Research
Wearable Technology for Ride Safety Evaluation
Developing a set of wearables to record g-force exerted on a ride participant exposed to 8 degrees of freedom
Read More
Data Analysis
Data Science for a Non-Profit Organization
Volunteering as Manager of Analytics & Insights at Chic Geek
Read More