Year: 2025
Type: article
Abstract: 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.
Language: English
Subfield: Management Information Systems
Domain: Social Sciences
Open Access status: bronze
OpenAlex ID: W4413845923