Data on sales and balances in the warehouses of pharmacy chains are necessary for planning, monitoring and evaluating the effectiveness of contracts with them.

The problem is that each network provides this data in its own format. Previously it took a very long time to combine and process the data. Thus, the company could not respond quickly enough to changes and work out emerging problems. In addition, the preparation of reports took a lot of staff time, and inevitable errors could occur in the process of preparing them.

• Free internal analysts from the routine work of bringing together data from various sources into a single reporting.
• Reduce the reporting cycle and labor costs required for its preparation.
• Increase the transparency of the sales department by creating a single source of truth and setting up the calculation of additional, the most difficult to obtain, indicators.

• Automatic loading of Excel reports from retail chains into a single data warehouse was set up, and the process of processing changes in their formats was organized.
• The contractor set up the process of parsing the data and bringing it to reference directories. Now the processed data appears in the storage within 2-3 days after the report is submitted by the network.
• A single data warehouse was developed and the necessary reports were configured.
• An OLAP cube was developed, which made it possible to organize comfortable work with data for a wide range of users within the company.
• Scheduled reports in Excel were set up. These reports allow you to monitor the situation on a daily basis and are automatically updated from the storage.

• Time and labor costs for preparing reports were significantly reduced.
• The company now has a single and always up-to-date source of truth about the work of the sales department.
• It was possible to improve the efficiency of the field team resource allocation.
• Technical data processing and bringing it to reference directories are completely transferred to the contractor.