Customer Company Size
Large Corporate
Product
- Sisense
Tech Stack
- MySQL
- Sisense
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Customer Satisfaction
- Productivity Improvements
- Digital Expertise
Technology Category
- Analytics & Modeling - Real Time Analytics
- Analytics & Modeling - Predictive Analytics
- Application Infrastructure & Middleware - Data Visualization
Applicable Industries
- Professional Service
Applicable Functions
- Business Operation
- Quality Assurance
- Sales & Marketing
Services
- Training
- System Integration
About The Customer
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 Challenge
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.
The Solution
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.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
SET Creative Ditches Google Vault for Datto Backupify
When Kienholz first started at SET, the staff was using Microsoft Outlook for email with no form of data backup. It became apparent that something needed to change as the staff was often burdened with trying to recover emails from departed employees. Kienholz transitioned the team to Google’s Gmail and implemented Google Vault for backup purposes. While SET employees quickly adjusted to Gmail, which many use for personal email, the same could not be said for Google Vault. “Unlike most Google products, Vault was not user friendly at all. It’s very hard to search for items. We never really figured out how to do a restore either,” explained Kienholz. Due to SET’s work with high-profile brands, projects often go through many rounds of revisions right down to the eleventh hour. This means that every bit of information - especially data living in project managers’ emails - is crucial to delivering clients a polished design at deadline.
Case Study
Infosys achieves a 5–7 percent effort reduction across projects
Infosys, a global leader in consulting, technology, and outsourcing solutions, was facing significant challenges in application development and maintenance due to its distributed teams, changing business priorities and the need to stay in alignment with customer needs. The company used a mix of open source, home-grown and third-party applications to support application development projects. However, challenges resulting from distributed teams using manual processes increased as the company grew. It became more and more important for Infosys to execute its projects efficiently, so they could improve quality, reduce defects and minimize delays.
Case Study
Arctic Wolf Envelops Teamworks with 24x7 Cybersecurity Protection and Comprehensive Visibility
Teamworks, a leading athlete engagement platform, faced rising cyberthreats and needed enhanced visibility into its network, servers, and laptops. With software developers connecting from all over the world, the company sought to improve its security posture and position itself for future growth. The company had a secure platform but recognized the need for a more proactive solution to identify gaps within its technology infrastructure. Data exfiltration and malicious access were top concerns, prompting the need for a comprehensive security upgrade.
Case Study
Sawback IT and Datto Save Client From a Costly Mistake
Ballistic Echo, a software development house, faced a critical challenge when human error led to the deletion of thousands of lines of unique code. This incident occurred before the code was pushed to source control, resulting in significant loss of time, revenue, and work. The previous file-level backup solution they used was slow and inefficient, making it nearly impossible to manually recreate the lost work. The need for a more reliable and efficient business continuity solution became evident to avoid such disasters in the future.
Case Study
Opal Helps Customers Shine Thanks to Datto
SP Flooring & Design Center faced a ransomware attack that encrypted and locked their files. The attack was initiated through a compromised service account set up by an outside vendor. The ransomware infection was isolated quickly, but there was a concern about the extent of the data at risk. The company had backups in place but was unsure of how much information was compromised. The situation required immediate action to prevent further damage and restore the affected data.
Case Study
Pipeline Insight Case Study: YARCDATA
YarcData faced challenges in determining the conversion rates of prospects into customers through various marketing efforts and identifying the source of its leads. They wanted to know the percentage of opportunities in the sales pipeline that came from different marketing events, web downloads, or self-sourced sales opportunities. Additionally, they needed the ability to drill down into the data to guide where to allocate more marketing dollars based on the success of previous efforts. Previously, YarcData relied heavily on spreadsheets and Salesforce.com reports, which made it difficult to extract the exact information they needed. This reliance on spreadsheets represented about 70% of their data presentation.