UNIFIED E-COMMERCE ANALYTICS FRAMEWORK WITH ONPREMISES DATA INTEGRATION AND AZURE CLOUD

The rapid growth of e-commerce has led to an explosion of transactional and customer interaction data.Traditional on-premises infrastructures often struggle to manage this scale due to limited scalability, lack of real-time capabilities, and weak governance mechanisms.To address these challenges, this study presents a cloud-based analytics framework that integrates structured data from SQL Server with semi-structured clickstream logs.The data pipeline is orchestrated through Azure Data Factory and stored in Azure Data Lake Storage Gen2.Data transformation follows the Medallion Architecture in Azure Databricks, while Unity Catalog enforces governance and secure access.Power BI dashboards deliver interactive visualizations for decision-making.The proposed solution demonstrates seamless integration of heterogeneous data, improved data quality, and scalable analytics, providing organizations with a clear path to migrate from legacy systems to cloud-native platforms.