Data Engineering and Predictive Analytics –
E-commerce company
Technologies used
Azure Data Factory
Snowflake
Python
SQL Server
PowerBI
Challenges
Delays in accessing centralized information
Identifying proper marketing channel to get more sales conversion
Analyzing incremental revenue by marketing campaign/efforts
Inventory out of stock situations
Solutions
Built analytics solutions which integrates information from different sources using data virtualization tool
Implemented Self Service BI tool
Built predictive analytics solution for customer segmentation, marketing channel effectiveness
Benefits
100% information availability in near real time.
Increased conversion by 15% in Catalog and Email Channel using predictive analytics