This issue marks the second phase of our Pikoda BI project, where we will showcase our solutions through management challenges, application objectives, deployment architecture, and key application scenarios. Demonstrating our product and service capabilities, Pikoda Data is committed to creating an all-in-one enterprise-level BI visualization analysis platform for businesses.
Company Profile
Runhua Group is a comprehensive large-scale joint-stock enterprise group that is primarily engaged in the automotive service industry, diversifying into strategic industries such as property management and participating in the financial sector. The company has over 15,000 employees, with total assets exceeding 14 billion yuan and operating income over 18 billion yuan. It is designated as a key service industry enterprise by the Shandong Provincial Government and is the leading enterprise in the Shandong automotive service industry.
Ronghua Auto Holding Co., Ltd. is a leading provider of multi-functional automotive services, the largest passenger vehicle service group in Shandong Province, with 72 authorized 4S car dealerships and 29 service chain stores, serving over 1 million customers annually.
Ronghua Auto Holding Co., Ltd. manages the operations of 20 leading car brands, primarily focusing on luxury brands such as Audi, BMW, Mercedes-Benz, Lexus, Cadillac, and mainstream mid-to-high-end passenger cars like General Motors, Volkswagen, Toyota, and Chrysler. This has established a "mid-to-high-end + luxury" brand structure, positioning the company as one of China's top 100 auto dealerships.
Management Challenges
The Runhua Group has been using NC for many years, with the system operating smoothly and stably. Additionally, the company also employs a well-functioning CRM system and after-sales system.
Executives aim to scientifically analyze the accumulated data across all systems to assist in informed management and decision-making. Establishing a comprehensive data analytics platform integrating whole vehicle sales, insurance operations, customer relations, after-sales service, and financial management will enable the company to more precisely grasp market trends.
The group has a multitude of systems, necessitating a comprehensive display of accumulated data.
The system is running smoothly and has accumulated considerable data, but the data is all contained within individual systems. Consequently, there is an inevitable reliance on manual data compilation and reporting at each level, making it challenging to conduct comprehensive analysis of the multi-system, multi-format data.
Lack of a unified data management platform, hindering the group's ability to leverage its data analytics management strengths.
A comprehensive, multi-dimensional, and panoramic supervision of all aspects of automotive sales, including logistics distribution, finance, sales, inventory, after-sales service, and insurance, is necessary to obtain effective and reliable data support. This ensures effective risk prevention and cost reduction.
Addressing the Target
Achieve information sharing and construct an intelligent analysis platform
Transitioning from the traditional manual hierarchical reporting model to an information-based data management system, with the goal of enhancing work efficiency and simplifying operations in system development.
Information interconnectivity breaks down existing information silos, building a comprehensive integrated analysis and decision-making management platform.
Covering the group's financial, sales, inventory, after-sales, and insurance data, it achieves comprehensive and timely monitoring of information.
Establish an intelligent analysis platform
We are developing a multi-level analytical decision-making management platform for various roles including top-level leaders, subordinate units, business departments, and leaders at all levels. The platform aims to achieve scientific decision-making by ensuring accurate and timely information sharing.
Application Deployment Architecture
Key Application Scenarios
Finance Topic
Analyze and present financial data in a clear and readable manner, enabling leaders to intuitively understand the financial status and key performance indicators, facilitating more informed decision-making.
Sales Theme
The overall marketing resource status, sales performance of each company, completion of sales plans, collection statistics, debt statistics, marketing expense investment, and sales trend analysis are all included. Highly graphical analyses are presented to senior management and the marketing department for intuitive review.
Mobile App and Large Screen
We meticulously track all customer business processes in-store, offering direct comparisons and early warnings on purchasing, after-sales, and maintenance. This enhances monitoring and forecasting efficiency, providing precise data support for inventory and sales. With the mobile app, real-time business data can be accessed anytime, anywhere, while senior leadership can oversee overall data through large screens, facilitating effective decision-making.
Applicative Value
System Value
Established a unified data sharing platform, built a comprehensive analysis and presentation platform for the group's financial, sales, and after-sales data, integrated with the group's information system, and established a mobile information portal platform for comprehensive decision-making information systems. Implemented online sales reporting and WeChat push care to enhance customer loyalty, and smoothly migrated the existing report analysis tool system to the new system through self-service portals.
Management Value
Enhanced and optimized data governance across all business endpoints, improving data quality to lay a foundation for data analysis in enterprise early warning, forecasting, and decision support. Amoeba Management: single vehicle cost accounting, automated and standardized; Integrating finance and operations: drilling down layer by layer, turning numbers into data, and data into information; Establishing risk control models, issuing early warnings on key risk indicators; Facilitating convenient and quick data management support for the group leadership in both internal and external data.
Automotive Sales Sector