A robust near real-time retail data warehouse system leveraging Java, MySQL, and MeshJoin for efficient ETL, star schema design, and actionable OLAP insights.
Central fact table for sales data and dimension tables for products, stores, suppliers, and customers.
Efficiently integrates transactional and dimensional data for enriched analysis.
Advanced analysis for revenue trends, product affinity, seasonal patterns, and supplier contributions.
- Java
- MySQL
- JDBC
- Eclipse IDE