Translation Services Company Drives Decisions with Data Goldmine

One Hour Translation (OHT) is a leading professional translation service provider, serving thousands of business customers across the globe. OHT provides professional translation, proofreading, and transcription services in 75 languages and 3,000 language pairs, thanks to a community of over 15,000 certified translators from more than 100 countries. Reporting was manual and piecemeal, with inaccuracies and many needs left unmet. OHT President, Lior Libman, was looking for a way to easily track and analyze key business metrics, such as revenue channels and customer segments, and to generate detailed operational performance reports. After installing Sisense, Lior can now monitor all areas of his business in real-time and quickly take advantage of new opportunities as they arise.

The operational data at OHT consists of over 20-million records in a 100GB MySQL database. Lior knew that they were collecting all the information he needed to get insights, but he simply couldn’t get to it. Transaction data was coming in pretty fast and, in order to continue to be an industry leader, he needed a way to get a 360 degree view of his business as fast as possible. Lior had various ad-hoc and separate solutions running to try and achieve the reporting and analytics the company needed, including manual analysis and home-grown software. He would often rely on someone from R&D to extract reports or would end up manually doing reporting in Excel, which would take weeks. These efforts were taking significant resources, both human and computer, to try and get the reports that were needed. Many of their analytics requirements were not being met at all, which was leading to a lot of frustration within the company.

Lior initially explored the possibility of expanding development of their in-house analytics software development, but deemed it too expensive and time-consuming to make it worth the effort to create and maintain. He then went on to evaluate BI solutions from several leading BI software vendors before finding Sisense. During an early web demo, Lior was able to implement Sisense running on top of the live OHT data running on a standard desktop PC. Seeing this made purchasing Sisense a quick decision for Lior and he sent his team for training. The result was a live, fully-functional BI solution in three weeks from the initial demo. It took just three hours of planning and ten hours of implementation to be up and running with all the initial reports that Lior required. OHT uses Sisense in three major areas across their company. Their first basic use of Sisense was a high level management dashboard that allows them to look at overall sales, number of projects, number of customers, and number of repeating customers. From there they built dashboards for their sales managers, which allows them to see everything regarding their salespeople and customers. They can look at their team as a whole or select a specific salesperson and their associated customers in order to see top customers, which customers need a little more attention, and which customers should be taken out of the sales process because their potential is not high enough. Finally, they created a dashboard for their translation team, which allows monitoring of project quality according to 30 different parameters and can alert them when a translator’s quality drops below a certain point.

• The in-house team was able to easily create, maintain, and modify their Sisense reports and analytic applications without the need for expensive consulting and support services, thereby keeping all that knowledge in-house and keeping turnaround fast.
• Lior was amazed at the agility of the Sisense software to answer current and future questions in a very simple and efficient way.
• He was able to continue to do rapid analysis on their large databases using inexpensive hardware, just as in the demo.
• Not having surprise expenses after implementation was definitely a welcome outcome.
• Lior now has his management team enjoying the benefits of a comprehensive dashboard which presents live transaction and project data, as well as drill-down views into specific customer, transaction, and translation project data.

• OHT's operational data consists of over 20-million records in a 100GB MySQL database.
• The implementation of Sisense took just three hours of planning and ten hours of implementation.
• The result was a live, fully-functional BI solution in three weeks from the initial demo.