Mantra Pharma
Pharmaceutical Industry
The objective was to centralize, automate, and secure the data architecture to support strategic decision-making.

Context, Challenges, and Objectives
Proposed solutions by Neos Group
Architecture design
Data Lake Configuration
A data lake was implemented on Azure to centralize and structure data from internal and external sources for more efficient analysis.
Automation of data ingestion
Automated ingestion pipelines were developed to process critical operational data, representing approximately 80% of recurring data. These pipelines reduced manual intervention, ensuring timely access to data while maintaining accuracy.
Data security and governance
Role-Based Access Controls (RBAC)
Access controls were implemented based on user responsibilities, ensuring only authorized individuals could access sensitive data.
Data encryption and security
Sensitive data was encrypted using the highest standards to protect confidentiality and ensure compliance with Mantra Pharma's data governance policies.
Power BI reporting automation
Dynamic report creation
Automated Power BI reports were developed to allow teams to easily access operational and sales KPIs. This included dashboards that facilitated data interpretation and enabled faster decision-making.
Monthly presentation optimization
Custom dashboards were designed to streamline monthly presentations, enabling teams to analyze inventory, sales, and order trends more efficiently.
Results achieved
AUTOMATISATION
Reduction of 50% in manual tasks for report preparation, freeing up time for strategic analyses.
FAST DECISION-MAKING
Centralized access to reliable data empowers teams to make accurate and confident decisions that enhance day-to-day operations.
ENHANCED SECURITY
Implementation of advanced access controls and security measures to protect sensitive data, ensuring compliance with Health Canada regulations.
Olivier Paquet, Vice President of Operations
Mantra Pharma
« Thanks to the work of Neos Group, we now have a centralized and automated data architecture that supports our operational needs. The security and reliability of our infrastructure allow our teams to make decisions with complete confidence and speed. »
Technologies used
Microsoft Azure
Data Lake, Azure Synapse for data storage and management.
Power BI
For creating dynamic reports and dashboards.
DevOps
For project management, deployment, and continuous integration.