Building an E-commerce Data Warehouse with Kettle and MySQL
Business Overview
A small online retailer wants daily insight into sales performance—order volume, revenue, and payment-method splits. The operational system (MySQL schema itcast_shop) contains six transactional tables that must be moved into a dedicated analytics store (itcast_shop_bi) and then aggregated for reporting.
Operational Schema
T ...
Posted on Tue, 19 May 2026 03:36:23 +0000 by icd_lx