Before: Clyde Quality Team & Process Engineering Team used to spend 30 minutes daily looking at excel spread sheet to prioritize and make the Pareto of the Quality Escapes to be able to put an action in Place for ICA and PCA.
After: We created a Power BI report that is connected directly to the New Incident Log Share Point, this report automatically updates in a daily basis and provides charts, paretos and already analyzed data, so the QEs and Process Engineers only have to look at the report and establish the ICA or PCA without taking more time trying to find the data.
This saves around 7.5 hours a week, 390 hours a year, saving $15K using salary average rate.