CruxBit
Back to catalog

Hybrid Batch and Streaming Analytics for E-Commerce Events

Added Jun 2025 3 design docs

E-commerce businesses ask two kinds of questions of the same data: what is happening on the site right now, and what patterns emerge over months of orders. Answering both requires a platform that marries streaming clickstream processing with heavyweight batch analytics over transactional history, coordinated so the two views stay consistent. The intern develops this hybrid platform on the open-source big data stack. Sqoop performs batch ingestion of transaction data from relational databases while Kafka carries real-time clickstream events; Spark handles both modes, with Spark Streaming computing live metrics like active sessions and conversion funnels and batch jobs building historical aggregates. HDFS provides durable storage, Hive exposes warehouse tables over the curated data, and Presto serves fast interactive queries for analysts. Airflow orchestrates the ETL workflows end to end with scheduling and dependency management, and the intern instruments the whole system with Prometheus metrics and Grafana dashboards tracking both cluster health and pipeline throughput. Completing the platform proves the intern can reason about lambda-style architectures, operate the classic Hadoop-ecosystem toolset that large retailers still run at scale, and treat monitoring as part of the deliverable rather than an afterthought.

Related projects

You might also like