Mohamed Elsayed
This page shows the development of the new spreadsheet.
Please Note: Data has been masked to protect data privacy
This shows how the inspections report originally looked like. Very limited insights could be extracted from such report as inspection results are in the form of text & many crucial elements are missing. Mainly used for record keeping only.
This is the dashboard of the new spreadsheet I created. It highlights the most important aspects relating to a specific product as a summary. It also includes a VBA search function to search for any product specs in the report to minimize the processing time when using normal filters due to the large volume of data.
This is the result of creating a new spreadsheet that allows for data analysis to be performed. This report that I created from the new spreadsheet I developed is the main report that is used to track this product's performance in the company. This has given management the opportunity to see how decisions they took affected product quality on a monthly basis & allowed them to compare failure rates on a monthly basis. The development of this report around mid 2020 was one of the factors that led to cutting failure rate by 50% & even 75% for some products. In this analysis, different line colours represent different product grades.