Business Intelligence in Action
Contact Us +420 511 116 188 or


The ROSSMANN company represents a chain of drugstores and perfumeries. They have been operating in the Czech market since May 1994, when the first shop was opened in the town of Ceske Budejovice. Subsequently, additional branch offices throughout the whole country were established. By the end of 2013, ROSSMANN operated 116 stores in the Czech Republic with approximately 660 employees working for the company in the Czech Republic, including 500 at the stores and a further 160 employees at the headquarters and in logistics.

“In the cooperation with IT we have found a competent and flexible partner with whom we solve the challenges that come with running a business.”

Zbyněk Major

IT Manager

The goals of the ROSSMANN project were to unify all data sources within the company (sales, inventory, accounting, promotions, POS), to create a unified analytical and reporting tool for the management and to optimize key processes within the company. Apart from creating a valid data warehouse that consolidates disparate information systems, it was crucial to develop a completely new reporting system, which replaced the outdated and costly, outsourced solution, built on Oracle technology. The new system now serves as a comprehensive analytical and controlling system.

For the project we used:

  • Data Warehousing
  • Business Intelligence
  • OLAP analysis
  • Data Integration

For the project we have developed:

  • Sales and stock reports
  • Rating promotions
  • Intranet Applications
  • Accounting and controlling reports
  • Distribution of stock keeping data
  • Calculation of complex margins
  • Instant overview of points of sale transactions
  • Effectiveness of a loyalty program
“ Working for ROSSMANN is very diverse, the firm constantly innovates and develops. This brings about new requirements for integration and usage of the data warehouse in untypical situations. With each of these requirements, the importance of DWH is increasing and it demonstrates its usefulness.”

Radim Hampel (Technical Director)