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:
- Develop ad hoc reporting solutions for the Customer Insights and Marketing Team.
- Create ETL/ELT pipelines using pipelines in Azure Synapse.
- Manage the Data Warehouse and reconcile Sales and Purchase Orders from F&O within Azure Synapse.
- Collaborate with stakeholders to identify requirements and recommend data solutions to meet business needs.
Master pipeline & Customer Insights Marketing: