Python: Daily Operating Report to prevent problems from becoming show-stoppers

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