Amid Adversity, Let Digitization Assist In Increasing Business Profits

Industry Background

In 2022, the business volume of the global shipping and logistics industry reached a value of USD 261.5 Billion. It will reach a value of USD 570.9 Billion by 2030 at a CAGR (Compound Annual Growth Rate) of 11.8% over the forecast period 2023-2030(Vantage Market Research). Over five years, China's express industry has experienced a tenfold growth, escalating from 1.3 billion to over 14 billion USD. The fierce competition in China's express logistics industry lies between customer experience and cost control, which can only be improved with digitalization and modernization.

A leading Chinese logistics company provides a wide range of solutions, including Less-Than-Truckload (LTL) transportation, Full Truck Load (FTL) transportation, delivery services, and warehousing management. With a 339.89% growth profit report card in 2022, this company makes everyone realize that digitalization can assist enterprises in creating tangible value. As digital transformation continues to deepen, from optimizing and upgrading enterprise digitalization and business systems to the entire flow process of each express delivery receipt, transfer, delivery, and after-sale, all are closely related to data.

This leading Chinese logistics company can reach 700w+ per day during the peak period of holidays, and the daily increase of waybill data can reach 500w+ per day during the peak period. Facing the massive data of waybills and orders, the client company chose Kyligence Enterprise OLAP (multi-dimensional analysis) products to provide a stable and reliable engine for data analysis of business departments, effectively alleviating the problems of data silos, low resource utilization, and complex operation and maintenance, and helping to reduce costs and increase efficiency in warehousing, transportation and distribution.

Pain Point Analysis

The scenarios related to waybill and order analysis generally include revenue analysis, proper delivery analysis, customer satisfaction analysis, and more. Initially, the client company used Apache Kylin to ensure the query speed under large data volumes and to meet the demand for multi-dimensional analysis. However, with the rapid growth of business volume, the open source product requires advanced developers to maintain a large number of components, lacks enterprise-level assurance, and has higher security risks, which brings new problems to the enterprise:

High labor and time costs: data model design relies on manual, Cube design and tuning requires high technical skills and a certain amount of labor; data model updates are inflexible, and when business requirements lead to Schema changes, it needs to be re-modeled, and the whole chain is time-consuming;

Limited support scenarios and high operation and maintenance costs: the early version of Apache Kylin 2 uses HBase as the storage engine, which is complex and prone to compatibility problems, and after the number of Cube reaches a certain level, it is difficult to maintain, and there are problems such as data redundancy; at the same time, the integration with the BI platform is not perfect and requires investment in R&D to interface and support;

Low resource utilization makes it difficult to empower more departments: As the business volume continues to grow, the system load increases, and when the performance reaches the bottleneck, the performance improvement brought by the expansion of resources is not proportional to the resource investment under certain circumstances, and the system optimization requires high technical ability, so it cannot be extended to more business lines and product lines.

Solution

The Kyligence Enterprise OLAP product has access to billions of orders/bill data of the leading Chinese logistics company, supporting order analysis, job cost analysis, delivery analysis, revenue analysis, and more. Kyligence intelligent tiered storage can interface with the unified semantic layer to manage data and seamlessly interface with mainstream business BI tools and Excel, empowering business personnel to perform multi-dimensional self-service analysis and create fixed dashboards:

Unified Data Services: Build a unified business semantic layer with Kyligence Enterprise for multidimensional data modeling. Through JDBC and Restful API, it integrates with FineBI and a web-based self-reporting system so that users can flexibly perform self-service analysis and kanban creation to meet various OLAP scenarios, such as booking/waybill revenue analysis and customer experience satisfaction analysis;

Intelligent tiered storage: build a tiered storage mechanism including distributed storage, MPP engine, and distributed cache, and intelligently select the best storage engine according to the frequency of use, data characteristics, and other factors to improve the efficiency of the query engine and save storage costs on the premise of providing unified metadata and query interface to the outside world;

Resource/permission isolation planning: to meet the client's demand, computing resource isolation, and access permission isolation are performed for different projects, providing a more refined management capability to meet the security control of enterprise users.

Key Results

Kyligence Enterprise OLAP product provides unified data services within the leading Chinese logistics company, meeting the needs of business analysis for thousands of front-line users, helping the company achieve refined revenue and expense management and drive marketing and sales efforts through order volume, shipment receipt status, complaint details, claims, profits, effectively reducing overall costs and helping profits continue to rise.

Analysis and mining of massive data, refinement of income and expenditure management: through the fine data refined to each waybill, it helps business users quickly understand the data of shipment delivery, shipment breakage, claims, cost and profit, complaint details, work situation of field stations, and more, timely adjusting and optimizing strategies to manage costs of supplies precisely

Reduces overall costs and saves profits: it effectively reduces learning curve costs, IT development, and hardware costs. Kyligence seamlessly connects to existing terminal applications to accelerate the efficiency of data insights, achieving a reduction in overall costs and management costs and contributing to a sustainable increase in profits;

Meet the needs of frontline users and provide enterprise-grade security: With distributed caching and AI intelligent engine optimization, Kyligence efficiently responds to the query needs of thousands of frontline users; meanwhile, Kyligence provides end-to-end data encryption, rank-level data permission control, data backup/restoration, and other security policies to safeguard enterprise data assets.

Kyligence Enterprise provides diverse solutions based on on-premise, public cloud, and private cloud, helping enterprises of any size to simplify multidimensional analysis based on massive amounts of data according to their business needs.​

Learn more about Kyligence Enterprise and Book a Demo today!