Analizing the Data after Stramlining The Process

N^o 2 About Project

I approached my Operations Manager with an Idea. This idea was the goal of reducing his average time for quoting projects from a two day turn around time to a more reasonable same day process.

[This is an image of the original Quote Tool.]

[This is an image of the Proof-of-concept Calculator.]

We discussed the process of quoting that was currently used throughout the company and the tool that he himself had created. While the tool helped, it was still cumbersome and required a lot of manual input to produce an acceptable result. This tool minimized a 1 to 7 hour quote process that was prone to errors and relied heavily on "Tribal Knowledge", to a more documented and systematized process that failed to addressed the more systemic issues while shaving very little time off of the original quote turnaround timeline. Simply put, the tool needed help.

For the full Article Click Here: Furniture Operations - Streamlining the Process

N^o 3 Gathering the Data

Five and a half years has passed since we put the calculator into production...

The first step in this process, was to gather all of the information that was generated by the tool and begin organizing it for cleaning and exploration. As the tool was created in Microsoft Access, it was easy enough to export the tables of data as excel spreadsheets and save them into a repository. I set up a Github repository in order to track the progress of the project and allow for version control.

Click Here to Visit the Repo: OHMS Data Analysis Capstone

N^o 4 Cleaning the Data

The Data set was small and manageable. The tool that I selected for the cleaning process was MS Excel.

Admittedly, the documentation of the step-by-step cleaning process is going to need to be recreated at a later time. The process was kept to removing records that were incomplete, due to missing data that was caused by the programming. the error was caught during the beginning of the beta phase testing and has held up for the 5 years that we had been using the calculator. Continuing with the cleaning, I descovered filling in the needed Manufacturer information, that was supposed to be part of the quote process, had been skipped by the end user to save time. The next version of the tool will need to have this process automated or made as a required step. I made the decision to complete the Product analysis of the data in Jupyter Notebooks for project documentation and my own education of Python for Data Analysis.

N^o 5 Analyzing the Data

This is the Executive summary of the various elements contributing to the findings and overview.

The environment needed to be setup and documented. I am using Anaconda for my version of Python and I created a Virtual Environment in order to maintain the integrety of the project. I documented the versions of the software in the project environment.yml file.

For the IDE, I am using VS Code with Jupyter Notebooks. This, being the standard for general Data Analysis. The details of the analysis will be available at my repository. So, continuing with the analysis, I have decided to spererate How I complete each of the various tasks as follows:

Please Note that I am still in the process of completing this Capstone project and will update this page with information and links as the project moves to completion.

N^o 6 Tools

• MS Excel
• Jupyter Notebook
• VS Code
• Github

• Python (Anaconda)
• Pandas
• numpy
• matplotlib

N^o 7 Github Repo

OHMS Data Analysis Capstone