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
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
WUN Systems Case Study
WUN Systems, a provider of an end-to-end Workspace Management Platform, wanted to offer a highly reliable and scalable VoIP service that would easily integrate into their platform. They were looking for an enterprise-grade, solid platform that would enable their customers to communicate seamlessly, whether they were working from their HQ, regional office or a remote location. WUN Systems was looking for an innovative, reliable and experienced communications vendor.
Case Study
Engine Informática offers SAP software as a service with IBM
Engine Informática, a Brazil-based company specializing in the implementation of SAP ERP solutions, identified a gap in the market for small and medium-sized companies. The company realized that the fixed infrastructure investment needed to run SAP 24/7, such as data centers, hardware, and support, meant that the per-user cost could be perceived as too high for smaller companies. The challenge was to reduce or eliminate the capital expenditures and implementation costs as much as possible to help reduce the barriers to entry for these smaller companies.
Case Study
Wittmann EDV-Systeme launches IT monitoring services
Small and medium-sized businesses often lack the know-how and resources required for thorough IT system monitoring. Wittmann EDV-Systeme wanted to launch a solution to plug the gap – enabling it to improve its own competitiveness and that of its customers. IT landscapes are becoming ever more complex and outsourcing is gaining popularity, IT systems must nonetheless remain easy-to-use and extremely reliable at all times. Automated, round-the-clock system monitoring therefore represents an immensely valuable proposition for companies: downtime for business-critical applications can be avoided, and IT systems remain available at all times.
Case Study
Delivering modern data protection with cloud scale backup from Cobalt Iron and IBM
Organizations are struggling to modernize their legacy data protection environments in the face of growing demands around new infrastructure, new applications, and budget consolidation. Virtualization and modern application development processes have significantly outgrown legacy backup architectures. In response, infrastructure teams have created multiple backup solution types to handle the varying SLAs (performance, scale, cost) required by their business sponsors. However, the sheer number and variety of solutions in this uncontrolled expansion creates huge amounts of work, threatening to overwhelm the IT team in many organizations. Today, developers may add new applications and virtual server instances by the hundreds per day without accounting for the restrictions of the existing backup infrastructure. They leverage the cloud for immediate compute and storage resources, yet rarely communicate succinctly with corporate IT to ensure that the appropriate data protection services are in place.
Case Study
IBM social business software connects and empowers employees for competitive advantage
Superior Group, a company providing workforce productivity solutions, found that its employees worldwide felt disconnected from headquarters, regional offices and each other due to outdated internal communication and collaboration tools. The company's intranet had become a top-down affair with little staff involvement, and employees lacked effective tools for anywhere/anytime communications. Those working remotely had limited access to co-workers and company apps. The main method of collaboration was inefficient email, challenging IT staff to manage a growing store of attachments. These factors inhibited the company from achieving its productivity goals.