Modern data warehouse
as a foundation for reliable customer care

Project goal

In collaboration with the internal Data Analytics team at Dr. Max, we are working on a project focused on comprehensive analytical coverage of the (post-)order process in online business. The goal is to improve internal processes and ensure key metrics that are fully comparable across the entire group.

Dr. Max Group, one of the largest and fastest-growing pharmacy chains in Europe, is investing in technological development through a new Business & Data Center in Prague. At intecs, we are a key partner in this growth – we design and deliver a data platform that ensures data integration, reporting, and support for strategic decision-making across six countries. Our solution forms a solid foundation for data-driven growth and digital transformation of the entire group.

1x

reporting

10+

data products

700+

users

5

years of collaboration

The goal of the collaboration with Dr. Max was to streamline these processes by building a modern data warehouse (DWH) and developing Power BI reports.

We focused primarily on processing online order data from the Dr. Max e-shop with more than 30,000 products. The objective was to cover the entire order lifecycle with a strong focus on the supply chain, which is critical from a customer perspective. Dr. Max aims to connect in-store and online shopping and offer customers a seamless and unified way to take care of their health. The company emphasizes innovation and customer-centric solutions and continuously adapts to changing healthcare needs.

To efficiently process online order data and develop reporting, building the data warehouse from scratch was essential. This project allowed us to design a custom DWH tailored to e-commerce processes and the client’s specific requirements.

The new data warehouse processes the complete flow of order information, where each order generates a dataset that is updated with every status change – from order creation, warehouse assignment, and packaging to shipment and delivery. Regular tracking of these changes enables detailed analysis of the entire process and precise monitoring of the order journey to the end customer.

Thanks to the data warehouse, we now map the entire order process in detail – from creation to delivery. Every step is carefully monitored, allowing us to quickly identify delays or issues and resolve them effectively.

The newly implemented monitoring of canceled orders provides insight into issues related to payment, warehouse processing, or customer non-collection. This data helps identify recurring problems and implement preventive measures to improve the overall process and customer satisfaction.

We also implemented visualizations of logistics processes, tracking the entire delivery chain – who delivers the orders, how quickly they deliver to different locations, and where shipments are dispatched from.

Technologies used
Industry solutions
Solutions


“During our long-term collaboration with Dr. Max, we have successfully worked on many interesting projects. Processing e-commerce data from the beginning presented a huge opportunity to create significant added value for the client, which strongly motivated us and continues to drive us forward. As a team, we are grateful for the opportunity to demonstrate every day what we can do and what can be achieved with Dr. Max’s data flows.”

~ Niels Verschatse, Senior BI Consultant | intecs

“Working with the Dr. Max team gave us a unique opportunity to look behind the scenes of orders that deliver what matters most every day – health. Joint workshops and regular consultations allowed us to plan next steps effectively, share expertise, and tackle various challenges together. This approach helped us better understand their needs and deliver solutions tailored to their expectations.”

~ Júlia Peňáková, BI Data Engineer | intecs

Satisfied client

“Dr. Max is rapidly expanding across Europe, especially in the online space, which makes it crucial for us to have comparable data and metrics across countries. We therefore decided to build a comprehensive analytical solution to effectively compare e-commerce performance and support our ambition to become a European leader.

Collaboration with intecs helped us better define our goals and expectations in the early stages, which significantly influenced the positive direction of the project. We appreciate their enthusiasm, willingness to understand our needs, and overall customer-focused approach.

Today, we have a functional solution that we continue to develop, helping us build a data-driven culture across the entire Dr. Max Group.”

Jiří Šnajdr

Business & Marketing Data Lead, Dr. Max BDC