Gift and Prepaid Card Supplier Sees 48x Speed Improvement in Reporting

Download PDF

improvement in report generation speed

venues across 20 cities in China

half a terabyte
of data that needs to be ingested

Executive Summary

KargoCard is a leading China-based service provider and distributor of gift cards and prepaid cards, running one of the largest platforms for physical distribution of gift cards in China. KargoCard partners with some of the world’s leading retailers, including Amazon and Lawson. The company has data coming in from a multitude of sources, the bulk of which is generated by transactional systems, including point-of-sale transaction data, online shopping carts, mobile shopping carts, and third-party platforms delivering content. They needed to track sales through thousands of sales points, perform inventory management, and provide real-time external reporting to their partners. When Co-founder and CTO, Ashmit Bhattacharya, decided it was time to implement a BI tool, he went straight to Sisense from his previous positive experience at another company. KargoCard was able to meet their objectives with Sisense and realize a 48x speed improvement in report generation from their previous system.

Using Sisense’s built-in capabilities and with some internal coding, we were able to build a lightweight, high-transaction, high-turnaround system that is purpose-built for what we need.

The Opportunity: Finding Growth

In addition to their online presence, KargoCard’s “KargoMalls” are gift card walls that are placed in convenience and retails stores and service over 550 venues across 20 cities in China. With all that volume and activity, Ashmit needed a BI solution to track internal metrics, optimize sales efforts and generate reports for potential and existing partners.

The Challenge: Unearth Hidden Insights

On top of all of the sales channel data, there was also inventory management of the physical cards that needed to be handled. Often times parter data was coming in as Excel or CSV files, adding up to a half terabyte of data that needed to be ingested. With no data team, management meetings were carried out without key metrics due to the sheer effort involved in putting those reports together. Ashmit was looking to achieve three types of goals for their BI implementation:

  • Internal reporting and analysis: Giving management a ‘big picture’ of the business by tracking sales efforts across thousands of physical sales points, as well as online and mobile platforms.
  • Supply chain management (SCM): As a small startup with a relatively simple sales model, Ashmit wanted a solution that would allow it to manage its gift card inventory.
  • External reporting: Provide real-time data to its business partners, so they could see, in real time, the value that KargoCard brought.

The Search is on

Ashmit already knew he wanted Sisense from his positive experience at his previous company. With his small technology team, Ashmit seamlessly pulled all of those data sources into their first Elasticube with no additional technology required. They built their executive dashboards for internal use and white-labeled external dashboards for their partners.

Creating an SCM System in Sisense

Rather than purchasing an SCM, which was problematic for a startup that was still defining its market, Ashmit set out to handle their inventory exclusively via Sisense. KargoCard eliminated the need for an SCM tool by fully understanding its business needs and making optimal use of Sisense. The company now tracks inventory possession across its entire network of stores within the Sisense environment. This allows them to see which brands of cards are out of stock and act accordingly.

At its simplest form, if you’re able to reduce the complexity of your business, then a big part of supply chain management ends up being real-time data processing.

Hero Moment

Sisense enables KargoCard to optimize its sales efforts throughout China by creating a schematic of which cards are placed at a store, as well as the layout of the cards in the KargoMalls, allowing them to do real-time A/B testing on their retail model. This has increased revenues for the company by making more effective merchandising decisions: restocking the stores, rearranging the shelves, and reordering the cards in the shelf- are all expensive measures to undertake. Using the data they pulled into the system, the company can now make sure it makes most efficient decision based on data.

Ashmit’s vision for data analytics at KargoCard is to utilize the mobile BI capabilities of Sisense and to turn the store clerks into end users themselves. “My true customers are going to be the clerks in the stores. I have enough data to prove that if I have an efficient clerk, he will outperform any in-store promotion. To run an efficient clerk incentive program, I have to be able to present near real-time data that will show how that clerk’s store is performing. If that data can be delivered through a mobile device, I can build next-generation, data-driven, gamified applications that incentivize my clerks to sell more gift cards. This could create whole new product opportunities.”