Leveraged Azure Synapse and Power BI to established bulk data processing and custom report generation systems
About the client
The client is a medical nutrition company offering a higher standard of enteral formulas. Their plant-based formula serves thousands of patients suffering from severe, chronic diseases to less serious medical issues.
- The client needed to streamline and automate their operations, particularly regarding the integration of Salesforce CRM and the McKesson system.
- They required a solution for generating monthly reports from their Enterprise Data Warehouse using Azure Integrations.
- Other major pain points were the manual processing of Sample Request orders, inefficient tracking of samples at various stages, and the limitations of their current integration with Jitterbit, which did not align with their specific needs.