The “Delta” Case: New AWS Data Platform Implementation

Nowadays consolidated data insights is an essential competitive advantage for companies. As Delta embarked on an ambitious growth strategy to establish itself as Italy's premier pharmacy network, consolidated data insights became essential to effectively scale operations across 300 locations without compromising quality of care or service. However, in the current common scenario data collection remained siloed within separate Microsoft Business Central instances, hindering strategic planning efforts. To overcome these constraints, Delta has decided to enlist PwC consultants to modernize its reporting infrastructure. The project lasted 6 months and it has been divided into different phases. The first part of the project consisted of an initial assessment. PwC consultants commissioned a thought highlighting the critical need to centralize information to facilitate data-driven management. Consultants contracted a thorough audit of existing systems, tools, and datasets to understand collection points and information needs. In-deep interviews with the company’s leadership illuminated essential metrics and performance indicators required for executive-level reporting and decision-making. PwC then mapped data flows and linkages between internal departments like procurement, finance, inventory, and customer service to establish an optimal organizational schema. During the first phase of the project, consultants merged isolated Business Central platforms into an integrated AWS Redshift data lake. This unified environment organized raw operational data into a common business framework. The data was meticulously modelled, creating a well-defined structure that served as a connection point. This enabled the extraction of valuable insights and information tailored specifically to meet the customer's needs. Through careful analysis and organization, the data became a powerful resource, empowering the customer with actionable knowledge. By harnessing the potential of data modelling, a comprehensive framework was established, facilitating the efficient exploration of information, and yielding valuable outcomes for the customer. Data quality checks validated accuracy and completeness. This empowered analysts with comprehensive, consistently updated information for advanced analytics. This meticulous approach ensured that the extracted information was not only relevant but also maximized the value derived from the data, resulting in an enhanced experience for the customer. Subsequent work centered on building an intuitive decision support layer. Power BI visualized insights through tailored reports, interactive dashboards, and data exploration tools. Pharmacists, store managers, and executives now access personalized views directly relevant to their roles from a single portal. As a result, Delta leadership gains enterprise-wide transparency into all facets of pharmacy operations spanning financial performance to inventory levels. Consolidated indicators replace assumptions, facilitating network-wide optimization to improve patient care and experience uniformly across their pharmacies. Empowered by data, Delta can sustain its rapid growth trajectory while retaining a community-centric focus.