Sisense > 实例探究 > Qualifa: Closing Leads Faster and Increasing Profits

Qualifa: Closing Leads Faster and Increasing Profits

Sisense Logo
公司规模
1,000+
地区
  • America
  • Asia
  • Europe
  • Pacific
国家
  • New Zealand
  • United Kingdom
产品
  • Sisense
  • Contaca
技术栈
  • SQL Server
  • Sisense
  • Intel Xeon E5-2670
实施规模
  • Enterprise-wide Deployment
影响指标
  • Customer Satisfaction
  • Digital Expertise
  • Productivity Improvements
技术
  • 分析与建模 - 预测分析
  • 分析与建模 - 实时分析
  • 功能应用 - 远程监控系统
适用行业
  • Professional Service
  • Software
适用功能
  • 商业运营
  • 销售与市场营销
用例
  • 实时定位系统 (RTLS)
  • 远程控制
服务
  • 软件设计与工程服务
  • 系统集成
关于客户
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.
挑战
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.
解决方案
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.
运营影响
  • 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.
数量效益
  • 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

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。