QuickCheck's Transformation of Unbanked Financial Services Using ClickHouse
Technology Category
- Analytics & Modeling - Machine Learning
- Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
- Buildings
- Finance & Insurance
Use Cases
- Fraud Detection
Services
- Data Science Services
About The Customer
QuickCheck is a fast-growing Fintech startup based in Lagos, Nigeria, with a team of over 150 people located between Nigeria and Portugal. The company's mission is to provide financial services to underserved consumers, particularly the over 60 million Nigerian adults who are excluded from banking services and 100 million who lack access to credit. QuickCheck leverages artificial intelligence to offer app-based neo-banking products. Their mobile app has been downloaded by more than 2 million people and has processed over 4.5 million micro-credit applications.
The Challenge
QuickCheck, a Fintech startup based in Lagos, Nigeria, is on a mission to provide financial services to over 60 million Nigerian adults who are excluded from banking services and 100 million who do not have access to credit. The QuickCheck mobile app, which has been downloaded by more than 2 million people and has processed over 4.5 million micro-credit applications, leverages artificial intelligence to offer app-based neo-banking products. However, the company faced challenges in analyzing the vast amount of financial data, fraud analysis, and monitoring data. They needed a solution that could handle hundreds of thousands of rows of data loaded daily for portfolio risk analysis and financial metrics building.
The Solution
QuickCheck adopted ClickHouse, a column-oriented database, two years ago to address their data analysis needs. ClickHouse is used for multiple purposes including financial data analysis, fraud analysis, and monitoring data. The application analyzes the entire history of a customer’s loans data, using daily snapshots. Hundreds of thousands of rows of data are loaded into ClickHouse daily. On top of this data, portfolio risk analysis is performed and the financial metrics needed for portfolio analysis are built. ClickHouse is also used for operational dashboards, aggregating data from different services. The fraud team uses ClickHouse to collect data for their scoring models, processing tens of thousands of data points from customers’ phones and other traditional sources.
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
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Real-time In-vehicle Monitoring
The telematic solution provides this vital premium-adjusting information. The solution also helps detect and deter vehicle or trailer theft – as soon as a theft occurs, monitoring personnel can alert the appropriate authorities, providing an exact location.“With more and more insurance companies and major fleet operators interested in monitoring driver behaviour on the grounds of road safety, efficient logistics and costs, the market for this type of device and associated e-business services is growing rapidly within Italy and the rest of Europe,” says Franco.“The insurance companies are especially interested in the pay-per-use and pay-as-you-drive applications while other organisations employ the technology for road user charging.”“One million vehicles in Italy currently carry such devices and forecasts indicate that the European market will increase tenfold by 2014.However, for our technology to work effectively, we needed a highly reliable wireless data network to carry the information between the vehicles and monitoring stations.”
Case Study
Protecting a Stadium from Hazardous Materials Using IoT2cell's Mobility Platform
There was a need for higher security at the AT&T Stadium during the NFL draft. There was a need to ensure that nuclear radiation material was not smuggled inside the stadium. Hazmat materials could often be missed in a standard checkpoint when gaining entry into a stadium.
