Transition from reporting, tracking, and managing Purchase Orders from an Excel workbook into an open-source Database with robust BI reporting capabilities. We have multiple customers, multiple distribution centers, different packaging requirements and all of this feeds into the product demand which we can then determine how many batches are needed for the week in question.

Understanding business requirements

Creating database architecture, tables and logic

Leveraging BI tools to retrieve data and present information in an easily usable format

Allow for manual updating of PO status and changes

Optional: Integration with QuickBooks online to populate the DB fields

Provide business requirements and current Excel spreadsheet being used

Provide guidance and direction on DB design and reporting

Dedicate team members to assist in the development and interface

Perform QA on the iterations to confirm usability