Customer Company Size
Large Corporate
Region
- America
- Asia
- Europe
- Pacific
Country
- New Zealand
- United Kingdom
Product
- Sisense
- Contaca
Tech Stack
- SQL Server
- Sisense
- Intel Xeon E5-2670
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Customer Satisfaction
- Digital Expertise
Technology Category
- Analytics & Modeling - Real Time Analytics
- Analytics & Modeling - Predictive Analytics
- Functional Applications - Remote Monitoring & Control Systems
Applicable Industries
- Software
- Professional Service
Applicable Functions
- Business Operation
- Sales & Marketing
Use Cases
- Real-Time Location System (RTLS)
- Remote Control
Services
- System Integration
- Software Design & Engineering Services
About The Customer
Qualifa is a B2B lead generation company specializing in telephone and email marketing for the technology sector. Operating globally from call centers in the UK and New Zealand, they serve clients such as Cisco, HP, Dell, Symantec, and McAfee. Known for their superior results and aggressive pricing, Qualifa has experienced explosive growth since its founding. The company uses a homegrown application called 'Contaca' to manage internal processing and client data, supporting 150-200 concurrent users. Their technical environment includes an Intel Xeon E5-2670 processor, 30 GB of RAM, and a SQL Server with 160 tables and 45 million rows of data, totaling 11.5GB.
The Challenge
Quentin Villon, a non-technical data analyst at Qualifa, faced significant challenges in managing and utilizing the vast amount of data collected by the company. Internally, he relied on Excel to manually build activity reports, a process that took two hours daily and resulted in a cumbersome 20MB spreadsheet. This method was prone to errors, with broken formulas and other issues, making it a nightmare to manage. The reports were also delayed, going out a day after the activity took place, which meant they could only acknowledge performance rather than influence it. Generating commission reports was even more time-consuming, taking two days each month. Externally, creating campaign insight reports for potential clients was a labor-intensive process that required several days of manual effort. These reports were crucial for client acquisition but were not reusable, adding to the inefficiency.
The Solution
Quentin explored various data visualization tools like QlikView, Tableau, and Gooddata but found them too technical for his non-IT background. A friend recommended Sisense, which he quickly downloaded, installed, and configured. Within hours, Quentin was able to produce useful dashboards on top of a complex data model. The process flow starts with a 'Big Table' where all calculations at the lowest level occur. This table feeds into other tables for further calculations based on required results, such as daily and monthly team performance. By making all calculations in the cube rather than the web application, they achieved faster processing times. The data feeding into BigTable comes from views, allowing them to import only the necessary data, significantly reducing update times and enabling real-time statistics. Quentin embedded Sisense widgets and dashboards into their Contaca software, allowing specific roles to access relevant data. This integration facilitated rapid adoption among their 200 users, providing near real-time data and instant responses from a single average server.
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
Zapier Aggregates Multiple Analytics in a Single Dashboard with the New Relic Platform
Zapier, a company that enables non-technical users to push data between hundreds of web applications, was facing a challenge in automating and provisioning servers for optimal performance. The company's environment consisted of 50 Linux servers on the Amazon Elastic Compute Cloud (EC2), a Django application split across several servers, and a backend consisting of a dynamic number of celery task workers fed by messages published to a RabbitMQ cluster. They also maintained a number of internal web services on nginx in front of Gunicorn and Node.js processes. Redis handled simple key and value stores, with logging handled by Graylog2 and ElasticSearch. However, they realized that no level of automation would be sufficient without an effective monitoring solution in place. They needed a tool that could provide immediate alerts when something was breaking and could be easily implemented into their environment.