Create centralized, automated reports from several sources and various types of data

The Problem:  Creating a report with key metrics across different teams requires gathering several different reports from different sources and manually converting and combining elements into a new report. This manual process is inefficient and delays team members’ ability to analyze the results to make more informed decisions.

The Solution: A custom-made Python program that can be run centrally, allowing the user to choose what period and for what team(s) to run. The program either consumes pre existing reports from each team or queries the data directly from the appropriate databases. The program automatically combines and transforms the data, and the organized results are placed in a pre-formatted deliverable for each team – all within minutes. This allows for more informed decisions to be made faster.

Practical Example