Sisense Case Studies Qualifa: Closing Leads Faster and Increasing Profits

Edit This Case Study Record

	Qualifa: Closing Leads Faster and Increasing Profits Sisense

Qualifa: Closing Leads Faster and Increasing Profits

Sisense

Technology Category	Analytics & Modeling - Predictive Analytics Analytics & Modeling - Real Time Analytics Functional Applications - Remote Monitoring & Control Systems
Applicable Industries	Professional Service Software
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Real-Time Location System (RTLS) Remote Control
Services	Software Design & Engineering Services System Integration
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Predictive Analytics

Analytics & Modeling - Real Time Analytics

Functional Applications - Remote Monitoring & Control Systems

Applicable Industries

Professional Service

Software

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Real-Time Location System (RTLS)

Remote Control

Services

Software Design & Engineering Services

System Integration

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.

About 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.

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.

Impact #1	Using a combination of their homegrown Contaca software and Sisense dashboards, Quentin achieved significant improvements in data management and reporting. Commission reports, which previously took three days to generate, are now available in real-time. Daily activity reports, once a two-hour task, are also produced in real-time. The time required to create one-off campaign insight reports has been reduced from three days to just two hours. The integration of Sisense widgets into their custom CRM with single sign-on (SSO) has facilitated rapid adoption among users. Approximately 60 dashboards and 15 ElastiCubes have been created, providing comprehensive data insights. The ability to publish specific widgets to user homepages allows for customized data views, enhancing user experience and satisfaction. Overall, the integration of Sisense has led to happier customers and a more efficient data management process.

Impact #1

Using a combination of their homegrown Contaca software and Sisense dashboards, Quentin achieved significant improvements in data management and reporting. Commission reports, which previously took three days to generate, are now available in real-time. Daily activity reports, once a two-hour task, are also produced in real-time. The time required to create one-off campaign insight reports has been reduced from three days to just two hours. The integration of Sisense widgets into their custom CRM with single sign-on (SSO) has facilitated rapid adoption among users. Approximately 60 dashboards and 15 ElastiCubes have been created, providing comprehensive data insights. The ability to publish specific widgets to user homepages allows for customized data views, enhancing user experience and satisfaction. Overall, the integration of Sisense has led to happier customers and a more efficient data management process.

Benefit #1	43% increase in productivity
Benefit #2	Commission reports down from 3 days to real time
Benefit #3	Daily reports down from 2 hours to real time

Benefit #1

43% increase in productivity

Benefit #2

Commission reports down from 3 days to real time

Benefit #3

Daily reports down from 2 hours to real time

Download PDF Version

Overview

Qualifa: Closing Leads Faster and Increasing Profits

Operational Impact

Quantitative Benefit