Overview
The original WARLAB project — a complete people analytics pipeline demonstrating how AI-assisted development can build production-grade data infrastructure. The project takes simulated Workday HR data through a three-layer architecture (Landing → Source → Star Schema) on AWS Redshift, culminating in an interactive ECharts dashboard for workforce analytics.
Architecture
The pipeline follows a classic three-layer data warehouse pattern:
Layer 1 (Landing): Raw CSV feeds loaded from S3 via COPY commands
Layer 3 Source: Cleaned and conformed staging tables
Layer 3 Star: Dimensional model with fact and dimension tables optimized for analytics
AWS services include S3 for storage, Glue for ETL orchestration, Redshift Serverless for the data warehouse, Lambda for dashboard data extraction, and CloudFront for dashboard hosting.
Tools & Technologies
Key Artifacts
Governance Notes
This project uses only synthetically generated HR data. No real employee records, proprietary schemas, or employer-specific data were used at any point. The simulated data generator produces realistic patterns for demonstration purposes only.