01 / HEALTHCAREHealthcare
Patient-visit analytics lake
Combine synthetic appointment, visit and hospital reference data; standardize identifiers and dates, check duplicates and build visit/utilization tables.
Claims processing pipeline
Join synthetic claims, provider and policy data; track rejected records, reconciliation totals and processing status.
SQLPythonS3GlueAthena
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.
02 / BANKING & FINANCIAL SERVICESBanking & financial services
Transaction reconciliation
Ingest sample account and transaction feeds, remove duplicates and reconcile opening balance, movements and closing balance.
Payment-event monitoring
Process simulated payment events, handle late arrivals and produce time-windowed transaction summaries.
PythonSQLKafka or KinesisRedshift
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.
03 / RETAIL & E-COMMERCERetail & e-commerce
Sales and inventory warehouse
Combine orders, returns, product and stock feeds; build sales facts and product/store dimensions for inventory reporting.
Clickstream-to-order funnel
Process browsing and checkout events; connect sessions with orders and create conversion-ready datasets.
PySparkdbtSnowflakeAirflow
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.
04 / LOGISTICS & SUPPLY CHAINLogistics & supply chain
Shipment tracking pipeline
Combine dispatch, scan and delivery events; deduplicate scans and calculate delivery time and delayed-shipment datasets.
Fleet telemetry lake
Ingest simulated vehicle location and sensor events, validate timestamps and aggregate route and vehicle activity.
Event HubsADLS Gen2DatabricksSQL
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.
05 / MANUFACTURING & IOTManufacturing & IoT
Equipment telemetry processing
Transform sample sensor readings into machine-level time series, flag missing readings and prepare monitoring tables.
Production and quality data mart
Join production batches, inspection results and downtime logs to build traceable yield and defect summaries.
PySparkDelta LakeAzure Data Factory
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.
06 / TELECOMMUNICATIONSTelecommunications
Usage and billing reconciliation
Process sample call/usage records and plan data, validate usage totals and create subscriber-level billing summaries.
Network-event aggregation
Group simulated network events by location and time window; handle duplicate events and delayed delivery.
KafkaPySparkSQLAirflow
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.
07 / INSURANCEInsurance
Policy and premium warehouse
Model sample policies, customers and premium schedules; preserve policy changes and build renewal reporting tables.
Claims lifecycle analytics
Track synthetic claim submissions and status changes to produce processing-time and outstanding-claim datasets.
PythonSQLS3Snowflake
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.
08 / MEDIA & DIGITAL PRODUCTSMedia & digital products
Subscription activity pipeline
Join sample subscription, payment and usage events to create active-user and renewal datasets.
Content engagement lakehouse
Transform simulated viewing events into session and content-level engagement tables with late-event handling.
PySparkDatabricksDelta LakeAirflow
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.
09 / EDUCATION & LEARNING PLATFORMSEducation & learning platforms
Learner progress warehouse
Combine synthetic course, enrollment and assessment data to build completion and progress datasets.
Learning-event streaming
Process sample lesson events, validate ordering and build daily participation summaries.
PythonSQLAzure Data FactorySynapse
Deliver: source contract, working pipeline, quality checks, analytical tables and an architecture walkthrough.