Problem Statement:

The Customer Insights and Marketing team struggled with fragmented data sources and inefficient reporting processes, making accessing and analyzing critical sales and purchase order information difficult. This project aimed to streamline data integration and reporting by developing ETL/ELT pipelines in Azure Synapse, enabling timely and accurate insights to support better decision-making.

Tools and Technologies:

Azure Synapse Analytics, Customer Insights, and D365 F&O

Summary:

Master pipeline & Customer Insights Marketing: