MIS (Management Information System) for R-Pharm. Analytical reporting on the effectiveness of business operations
- Customer
- R-Pharm
- Project manager on the customer side
- IT Provider
- Navicon
- Year of project completion
- 2021
- Project timeline
- January, 2021 - November, 2021
- Project scope
- 18500 man-hours
- Goals
-
The main goal of the project for the development and implementation of an analytical reporting information system for evaluating the effectiveness of business operations (hereinafter referred to as MIS) is to ensure transparency and traceability of expenses and income related to business areas, products, territories. The imperative for most project decisions is the simplicity and clarity of the logic of calculation, reporting and analytics for business leaders.
The need to provide shareholders and top management of the company with operational information about the effectiveness of all major business processes and operations at once. The goal was achieved with the help of convenient mobile and desktop analytical tools (dashboards), reflecting operational information with a minimum delay from the moment it is stored in source systems.
In order to eliminate management errors, it was necessary to implement a fully automatic solution for data quality control based on business rules.
It was important to provide shareholders and top management of the company with visual analytical tools to access all information 24/7 from anywhere in the world from any available device.
The uniqueness of the project
The uniqueness lies in the fact that the project has created not only a technological platform, but also a business practice of operational business analysis, as well as the possibility of communication integration of departments using a mobile analytical platform.
At the same time, a light mobile interactive interface, a powerful data quality management system and an automated comparison system for management and accounting were developed. This approach made it possible to provide a convenient communication basis for business management, and the necessary transparency of the origin of data, which created confidence in the new management system.
This approach made it possible to immediately provide shareholders and top management with a comprehensive picture of the state of the enterprise. At the same time, the data model can subsequently be detailed, providing tools to other levels of company management.
The developed solution allowed the company's management to obtain information on the commercial effectiveness of all business operations within the framework of a plan / factual analysis with allocation to various levels of analytics (CFD, products, transactions, etc.) based on information from management P&L, management and accounting records.
- Used software
-
The solution is deployed on-premise across platforms:
-
Microsoft SQL Server Enterprise Edition
-
Power BI Report Server
-
- Difficulty of implementation
-
The key complexity of the project lies at the intersection of technological, organizational and methodological issues. Development was carried out in an agile approach.
Coverage of all major business processes of the holding required
-
An initial comprehensive analysis of the methodology for analyzing and accounting for an enterprise in order to develop a unified view of the analytics of the effectiveness of business operations.
-
Phased development of UX and UI - to solve the main issues of managers in 3-4 clicks.
-
Rapid implementation of a prototype based on a high-level approach in order to quickly put it into operation /
- Iterative refinement and refinement of accounting and analytics methods to achieve the required level of accuracy in subsequent stages of the project.
-
- Project Description
-
The R-Pharm group of companies is one of the leaders in the Russian pharmaceutical market. Field of activity: development, research, production, market launch of a wide range of medicines. The company operates throughout the Russian Federation and the CIS countries, the USA, Germany, Japan and India.
The main results of the project:
-
Business leaders received a mobile tool for analyzing the effectiveness of the main types of business with details to any operation;
-
Managers received a set of information panels with the ability to answer basic questions about dynamics, marginality, forecast of the implementation of plans - on the main performance indicators of departments in a wide range of analytics;
-
The company received a single point of access to obtain the necessary data on management accounting and commercial indicators;
-
A specially developed methodology for accounting for actual results provided the management with transparency of activities and prompt decision-making.
The architectural system is
-
QCD, including the entire historical dataset of management and accounting, functional data marts,
-
Data quality control subsystem
-
Controlling subsystem
-
Data management tools
-
Visualization tools and detailed analytics.
As a result of the project, the system was put into operation and allowed management at all levels to get a tool that provides a comprehensive and detailed view of the company's commercial performance at any time. At the same time, the implemented methodology is not limited to management, accounting, or only P&L of the company, but represents the most effective set of these data.
-
- Project geography
- Russia
Summer is coming to an end, but life in the analytics field is bustling. New vendor announcements, promising projects, and the pervasive penetration of AI into all areas of our lives are paving the way for the upcoming business season.
Maksim Karankevich, Director of Data and Digital Transformation, Ultramar, in his presentation shared his experience of implementing a cellular-based industrial radio network.
The home goods retailer has long been committed to digital innovation, not only in product design but also in transforming operational strategies.
Kuat Sandalov, Chief Data Officer at Kazakhtelecom tells about how data governance maximizes the value of data for strategic initiatives and decision-making while ensuring sustainability and adaptability to future needs.
In terms of its importance and impact on humanity, AI has been compared to the advent of the Internet and smartphones. While AI is rapidly developing and penetrating all spheres, people are increasingly thinking about ethical issues and sharing concerns about its uncontrolled use. How did we get to this point and what will happen next?