下载PDF
Sisense > 实例探究 > Qualifa: Closing Leads Faster and Increasing Profits
Sisense Logo

Qualifa: Closing Leads Faster and Increasing Profits

技术
  • 分析与建模 - 实时分析
  • 分析与建模 - 预测分析
  • 功能应用 - 远程监控系统
适用行业
  • Software
  • Professional Service
适用功能
  • 商业运营
  • 销售与市场营销
用例
  • 实时定位系统 (RTLS)
  • 远程控制
服务
  • 系统集成
  • 软件设计与工程服务
挑战
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.
关于客户
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 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

相关案例.

联系我们

欢迎与我们交流!

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

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