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
UI/UX Design, Development
Website Development for UN Women SHEInnovates Chapter
Celebrating women entrepreneurs and innovators in Alberta
Read More
Data Engineering, Data Science, Data Analysis
Performance Forecasting
An annual deliverable to predict website traffic and set performance targets
Read More
Data Analysis
Data Science for a Non-Profit Organization
Volunteering as Manager of Analytics & Insights at Chic Geek
Read More