MIS (Management Information System) for R-Pharm. Analytical reporting on the effectiveness of business operations

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 solution is deployed on-premise across platforms:

• Microsoft SQL Server Enterprise Edition

• Power BI Report Server

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

1. 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.

2. Phased development of UX and UI - to solve the main issues of managers in 3-4 clicks.

3. Rapid implementation of a prototype based on a high-level approach in order to quickly put it into operation /

4. Iterative refinement and refinement of accounting and analytics methods to achieve the required level of accuracy in subsequent stages of the project.

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.