ecommerceanalytics

This project is an end-to-end E-Commerce Sales Analytics solution developed using SQL, Python, and Power BI. The project demonstrates the complete data analytics lifecycle, starting from raw data import and SQL-based analysis to Python data cleaning, exploratory data analysis (EDA), and interactive dashboard development in Power BI.

Global Intelligence & Economic Transformation

The primary objective of this project is to bridge the gap between complex data sets and executive decision-making. The application serves as a Strategic Growth Simulator for e-commerce platforms | Ecommerce Sales Analytics

Engineered a custom 3-tier Data Warehouse (Bronze/Silver/Gold) using T-SQL for advanced data cleansing and dimensional modeling. Culminates in a multi-page Power BI executive dashboard—transforming complex datasets into clear, visual business narratives—to deliver deep-dive analytics across the Customer, Product, and Seller ecosystems.

End-to-End Business Analysis of Flipkart Big Billion Days (BBD) using SQL, Python & Power BI — uncovering sales trends, category performance, customer loyalty, and discount impact.

End-to-end e-commerce analytics project using PostgreSQL, SQL ETL, Excel QA, Power BI and DAX.

A big data analytics project that integrates sales data from Flipkart, Amazon, and Meesho into a unified pipeline. Data is processed with Apache Spark, stored in MySQL, and visualized using Power BI/Tableau to uncover trends, top-selling products, and customer purchase patterns. Designed to support data-driven decision-making in e-commerce.

guardian malaysia review scraping

SQL-based E-Commerce performance analysis uncovering a $30M revenue decline across 5000+ orders (2024–2025)

📥 Collect Data → 🧹 Clean & Prepare → 🔗 Model (Pivot Tables) → 🧮 Calculate KPIs → 📊 Build Dashboard → 🎛️ Add Slicers → 📈 Analyze Trends → 💡 Generate Insights → 🚀 Make Data-Driven Decisions

End-to-end PostgreSQL e-commerce analytics project featuring advanced SQL, customer segmentation, cohort analysis, business KPIs, and query performance optimization.