The No. 1 problem with data is integrating data sets that have different bases. The basis for raw material is the SKU or lot numbers coming from your supplier. The basis for process settings is your SKU or run number on your machine. The basis for your machine readings is time-based. The basis for test lab results is parent roll-based. The basis for internal rejects is parent or daughter roll-based. Finally, the basis for customer complaints is, almost always, daughter roll-based.
This clip shows two ways to integrate these various sources to do troubleshooting of waste, delay and customer complaints with webs.
Web40121b - https://www.youtube.com/watch?v=g4wqU0KUmCE