Skip navigation

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.

STIWA Group won the 2017 Pentaho Excellence Award in Embedded Analytics, a category that recognizes the successful embedding, extending or customizing of Pentaho to create a unique, value-added analytics solution.

Custom Analysis Tools Need Updating to Compete in Global Market

A global leader in product and high-performance manufacturing automation, the STIWA Group has more than 1,500 employees operating in seven plants in Austria, China, the United States and Germany.

The manufacturing industry is going through its own transformation. Traditionally a low margin and low growth business, manufacturers have been faced with increased demand for higher quality products at decreasing prices. Despite these challenges, manufacturers have an opportunity to leverage data and analytics to innovate, create a competitive advantage and drive new revenue streams.

To effectively compete in this global market, the STIWA Group provides their customers with a global view of their operations to increase the useful life of their machinery. However, STIWA was relying on 15-year-old analysis tools to provide data to their customers. Generating and reporting on analysis was cumbersome and time-consuming. It was difficult to customize reports, and customers couldn’t generate reports on their own. The analysis itself was limited to machine data only; it wasn’t flexible enough to handle product quality or other data sources. Only data from one machine could be analyzed at a time when most customers have multiple machines across multiple factories and need a single view of their environments.

Pentaho Captures New Data Sources and Integrates Seamlessly

The STIWA Group needed a new future-proof analysis tool that could integrate all technical data—including machine, plant, process, quality, and energy data—from fully or partially automated production. It needed to satisfy diverse operational and analytical reporting requirements, including self-service. It needed to be quick and easy to install and to start enhancing productivity immediately.

The STIWA Group relies on Pentaho as a unique, value-added analytics solution that automatically collects, processes, and networks all available signals and data— including machine, production, and quality data. Pentaho’s flexible cloud-ready platform was easily embedded into and integrated with the company’s analysis tool with minimal development and testing. While the out-of-the-box solution provided tremendous value, STIWA was able to easily customize it to get even more value for themselves and their customers. Pentaho’s customizations allowed STIWA to create a platform that addresses industry specific needs.

Future-proof Infrastructure in Place to Increase Productivity, Decrease Costs, and Grow Opportunities

Pentaho’s powerful analytics and extensible architecture helps the STIWA Group institute global tracking and tracing for safety-critical products and gain worldwide control of complex assembly and manufacturing processes. The ramp-up phase for new assembly machines is 30 percent shorter. Productivity for production lines has increased by 15 percent, and costs for IT interfaces have decreased by 35 percent. Creating custom reports no longer take a week of time; new reports and dashboards can be created in minutes.

The STIWA Group’s experience in machine construction and automotive supplier production is now embedded into its software offerings and available for all customers. Being able to integrate different data sources to provide self-service reporting has delighted customers and created new revenue streams—for example, the company can charge for additional analysis when customers want to compare machine data across equipment pieces. Thanks to Pentaho, the STIWA Group has a future-proof infrastructure in place to move to a real-time environment and start capturing even more data sources, such as energy data.

 

Learn more about the other 2017 Pentaho Excellence Award Winners.

Teletrac Navman won the 2017 Pentaho Excellence Award for Internet of Things (IoT), a category that recognizes organizations for leveraging data from devices to improve customer engagement, enhance operations and drive new revenue opportunities through machine learning or predictive analytics.

Fleet Management Platform Tracks Enormous Volume and Variety of Data

With 25 years of telematics experience, Teletrac Navman provides advanced data tools for location tracking, fuel monitoring, reporting, safety and compliance. Its powerful fleet management platform is used by 40,000 organizations, in six continents, and tracks more than 500,000 vehicles.

Every minute, Teletrac Navman tracks an enormous volume of data including: driver performance, safety compliance, fuel usage, and diagnostics. The company is devoted to accurately and precisely collecting data securely, by utilizing the strongest protection and controls.

Event and Segment Telematics Data Blended in Unique IoT Platform

Teletrac Navman relies on Pentaho to create a revolutionary IoT platform. It’s the first of its kind to merge two separate IoT platforms—one for event data, and one for segment data.

The Pentaho platform ingests event data which refers to specific processes such as “ignition is turned on/off” data into a single segment. Segment data is then aggregated daily and cleansed. Then it is mapped to dimensional data (by driver and by fleet) so that customers can access and view their data based on fleet and user-level access credentials.

Thanks to Pentaho’s simple drag-and-drop interface, Teletrac Navman’s customers can combine build their own reports and create a single view of data on demand. Most importantly, no developer resources are required.

Single View of IoT Data Responds to New Business Opportunities

With access to so much data, Teletrac Navman is using Pentaho’s real-time processing, predictive and prescriptive analytics to innovate and respond to new customer needs. For example, customers with multiple international operations need a single, global view of their fleet data, not just by individual geographic regions. Teletrac Navman relies on Pentaho to aggregate segments of geographic data into one holistic, global view, helping customers create benchmarks to enhance their worldwide operations.

Check out this story from SiliconANGLE to learn more about Teletrac. Learn more about the other 2017 Pentaho Excellence Award Winners.

LAZIOcrea won the 2017 Pentaho Excellence Award in ROI, a category that recognizes the use of Pentaho to make a positive impact on business, society and the planet.

RISING HEALTHCARE COSTS PROMPTS ONE-OF-A-KIND DATA INTEGRATION PROJECT

LAZIOcrea supports Regione Lazio, the large region in central Italy that includes Rome and more than 6 million citizens. They have administrative and technical infrastructure services for government programs co-funded by the European Union.

Healthcare costs make up the majority of the regional government’s expenditures. In 2016, Regione Lazio kicked off a groundbreaking project—the first and only project of its kind in Europe—designed to monitor and reduce pharmaceutical drug costs. The region needed to determine which doctors wrote the most prescriptions, the cost associated with these prescriptions and how often the same prescriptions were written.

SINGLE VIEW OF DATA DRIVES NEW INSIGHTS AND INNOVATION

LAZIOcrea was tasked with creating a single view of data from patients, doctors and pharmacies. There are enormous volumes and varieties of data to be collected and digitized. Each month, 5.5 million prescriptions are written and 11 million prescription barcodes are recorded from 25,000 doctors, 10 health systems, eight hospitals and 1,500 pharmacies.

Working with implementation partner BNova, LAZIOcrea built a Medical Prescription Analysis System using Pentaho Enterprise Edition for the entire data pipeline—from ingestion to blending to visualization. Data can now be extracted easily and viewed and analyzed in new and innovative ways. Future uses for the single view of data include a data lake, machine learning algorithms, and doctor scorecards.

PUBLIC HEALTH AND BUDGETS BENEFIT FROM SINGLE DATA VIEW

The region now knows, with greater accuracy, the type and frequency of medicine prescribed. There are fewer unnecessary prescriptions—the kinds that often lead to drug abuse. And there is an adequate supply of medicine in emergencies, such as the devastating earthquake that struck the region in 2016.

Not only has pharmaceutical policy improved, costs have decreased dramatically. Prescription drug expenses have shrunk from €162 to €154.8 per citizen since 2014, for a total savings of €43 million. The region now has confidence funds will be in place to cover healthcare expenses for its citizens.

 

Learn more about the other 2017 Pentaho Excellence Award Winners.

This year we recognized six customers for their innovative use of Pentaho Data Integration and Business Analytics to achieve data-driven business outcomes. This blog will recognize ZeniMax Media - the winner in the Big Data category.

The Big Data category recognizes organizations for leveraging Big Data technologies like Hadoop, NoSQL or Spark to overcome their data challenges and create business value.

BIG DEMANDS ON BIG DATA IN HIGHLY COMPETITIVE GAMING INDUSTRY

ZeniMax Media publishes original interactive entertainment content for gaming consoles, computers and handheld/wireless devices. The company operates some of the world’s most acclaimed development studios and creates award-winning video games, including The Elder Scrolls, Fallout, Dishonored, DOOM, QUAKE, Wolfenstein, Prey, The Evil Within and RAGE.

ZeniMax wanted to harness the power of its massive data volumes to gain insights about its customers and improve its operations. But it lacked a single view of its data environment to understand user behavior across games.

MASSIVE DATA VOLUMES SCATTERED ACROSS A COMPLEX DATA ENVIRONMENT

Huge quantities of data—roughly 30 to 40 GB of new data generated every 5 minutes, plus 5 years of legacy data—were managed in various silos, including two e-commerce platforms and multiple data repositories across its game studios. The company uses Redshift for data warehousing and a combination of Cloudera in its data centers and Databricks in AWS.

Data from these disparate and fragmented sources had to be manually stitched together to generate a single view needed for data-driven decision making. This cumbersome process consumed too many resources and resulted in fragmented metrics and KPIs.

SINGLE VIEW OF DATA USED TO MINE INSIGHTS INTO PLAYER BEHAVIORS, PREFERENCES

In 2014, ZeniMax embarked on a mission to create a single view of their data. The company needed a data integration solution that provided flexibility in a complex data environment.

They found that solution in Pentaho Data Integration. The Data Engineering team first created a single view of their data warehouse by populating it with key game and business-focused metrics. The team then established KPIs and created common definitions across all games. Automating SQL workloads freed up data scientists’ time considerably.

ZeniMax now has a better understanding of player behavior and preferences, such why a player stops playing a certain game, which features they prefer, and when and why a player spends money. Ultimately, the company plans to leverage this data to segment players and incentivize them with custom promotional offers which will drive user engagement, improve revenue and greater participation.

Learn more about the other 2017 Pentaho Excellence Award Winners.