Jonathan Shafer

The TIMELAB Foundation relies on Pentaho for managing, integrating, securing and archiving all of its horological certifications since 1886  

Blog Post created by Jonathan Shafer Employee on May 25, 2018

Created in 1886, the TIMELAB Foundation provides two of the most prestigious horological (relating to timepieces such as clocks and watches) certifications: the Poinçon de Genève and the Observatoire Chronométrique +.

 

In maintaining their mission of full independence and neutrality, their laboratory offers horology industry expertise, testing, investigations and services for movement and watch specifications. These measurements need to comply with standard requirements (ISO, NIHS, etc.) or meet specific customer requests during the homologation phase, which includes the production and quality control processes.

 

Challenges

TIMELAB’s expertise, testing, analysis and certification activities generate large data volumes that became too difficult to manage manually. This is further complicated by the fact their data spans over an entire century from the first written records in 1886. As a result, they lacked a complete and immediate access to their data to automatically verify, integrate and archive for traceability needs.

 

It became clear that TIMELAB could benefit from a centralized, automated and expandable system with modern and powerful analytical functionality. In order to comply with their independence and neutrality commitment, TIMELAB was searching for a solution that would retain all of its testing and certification data in its original format without allowing users to alter its contents.

 

Solution

TIMELAB’s choice for the Pentaho Data Integration and Business Analytics solution allowed them to replace a manually maintained Microsoft Excel based system that was managed by the Laboratory Manager and the Certification Manager. An automated data management process has resulted in significant time savings for data collection and verification. This new system provides an automated comparison of diverse measurement results for greater productivity and rapid compliance checking. Once the results are recorded by an authorized member of the TIMELAB laboratory, user defined access is administered via Pentaho’s user console in order to maintain high data integrity and comply the neutrality requirements mandated by the certification process.

 

Additionally, Pentaho’s self-service data integration capabilities provide other watch factories with the ability to import their testing results while upholding the integrity of their data.

 

“Thanks to Pentaho we benefit from a fully integrated view of our data that our laboratory teams can now access in a self-service fashion. Furthermore, we can quickly generate certificates following successful testing procedures, produce the certification history on demand, and associate a part with all of its attributes, » said Anne-Sophie Guerra – TIMELAB’s Managing Director. “Pentaho’s platform leverages our expertise to make it easier to meet the requirements of quality and autonomy.”

 

In collaboration with Pentaho partner Linalis, who specializes in delivering business intelligence and web solutions, TIMELAB has now integrated their Excel based system into its centralized database. Following the import of every file created since 2012, they will leverage Pentaho to gradually incorporate all of the handwritten registries into the system. Linalis has also provided support for interface personalization and ISO compliance testing.

Benefits                                                                                   
By relying on Pentaho’s modern and flexible end-to-end platform, TIMELAB has been able to deliver a wide range of certification management and analysis functionality for enhancing the team’s performance. Dashboards and reporting provide completed testing results; and full visibility on all of the watch parts and calibration details.

“Pentaho allows us to visualize the environmental factors impacting the work in our laboratory. For instance, our charts highlight measurements trending towards a lower or higher tolerance or even changing conditions during the day. This allows us to detect easier non-compliant parts so it does not impact our certification process,” explained Guerra.

Pentaho ingests temperature and atmospheric data in the laboratory to ensure testing is not impacted by changing environmental factors. In the event temperatures or particles are recorded above the pre-defined threshold, an email alert is sent to the appropriate recipients within the laboratory to give them time to react before being out of tolerance.

 

At the conclusion of the testing process, a part certification number is automatically generated by TIMELAB. thanks to a peering system combining a unique movement number with a unique watch case. In the event a movement already is associated with another case, it will automatically update This automated management system also continuously validates tests, certificate recordings, entry mistakes and omissions from the process. Pentaho enables easy search functionality to verify a watch’s authenticity.

 

Today TIMELAB is advocating for other laboratories to adopt Pentaho’s platform in order to build the industry’s most comprehensive horological certification and archiving system.

Outcomes