# Sample Sales and Presales Data

This folder contains a small, fictional dataset for testing a Bronze to Silver to Gold pipeline.

## Files

- `accounts.csv`: customer master data
- `sales_reps.csv`: sales owner master data
- `presales_engineers.csv`: presales owner master data
- `solutions.csv`: solution catalog
- `opportunities.csv`: CRM-style opportunity export
- `presales_engagements.csv`: presales activity export
- `pocs.csv`: proof-of-concept tracking export
- `sales_activities.csv`: sales activity export
- `sales_targets.csv`: monthly sales targets

## Suggested Upload Order

1. `accounts.csv`, `sales_reps.csv`, `presales_engineers.csv`, and `solutions.csv`
2. `opportunities.csv`
3. `presales_engagements.csv`, `pocs.csv`, `sales_activities.csv`, and `sales_targets.csv`

## Pipeline Notes

- The transaction files use source-shaped columns such as `deal_value_text`, `probability_text`, `account_name`, and `sales_rep_email` to simulate a CRM or spreadsheet export.
- Resolve account, sales representative, presales engineer, and solution references during Silver processing.
- Normalize `Open`, `open`, and `OPEN` to `OPEN`; normalize `Closed Won` and `WON` to `WON`; normalize `lost` to `LOST`.
- Parse Rupiah values into decimal numbers and percentages into values between `0` and `1`.
- Empty close dates are valid for open opportunities and active engagements.
- All records are fictional and intended for demonstration only.