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, 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
UI/UX Design, Development
Website Development for UN Women SHEInnovates Chapter
Celebrating women entrepreneurs and innovators in Alberta
Read More
UI/UX Design, Development
Website Restructure for Transmedia Zone
The incubator for innovation in storytelling, media and the creative industries
Read More