Sisense > Case Studies > Qualifa: Closing Leads Faster and Increasing Profits

Qualifa: Closing Leads Faster and Increasing Profits

Sisense Logo
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
  • 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.
Quantitative Benefit
  • 43% increase in productivity
  • Commission reports down from 3 days to real time
  • Daily reports down from 2 hours to real time
  • One-off campaign insight reports from 3 days to 2 hours to produce
  • Quentin alone saves approximately 50 hours per month on standard tasks

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.