Project objective:
- Create a report to highlight key operational KPIs from different data sources in Microsoft Excel format
Client Industry: Manufacturing
Project Summary:
- Customer had certain ERP generated and manual data sources
- All these sources generated a snapshot of operational performance at a given time every day
- Expectation from us was to create a script that would combine and analyze all these different files and produce a report that could be used for summary and detailed performance reporting
Outcome
- We created a Python script that could consistently use customer’s existing Excel data from different sources
- This repetitive script helped customer solve their operational problems by highlighting problems before they became show-stoppers