# Data Dictionary

## fact_sales
Grain: one product line within a customer order.

- line_id: unique sales line
- order_id: customer order
- order_date: transaction date
- customer_id: customer foreign key
- product_id: product foreign key
- salesperson_id: salesperson foreign key
- quantity: units sold
- unit_price: list price before discount
- discount_pct: line discount
- gross_sales: quantity x unit price
- net_sales: gross sales after discount
- cogs: cost of goods sold
- gross_profit: net sales minus COGS

## Dimensions
`dim_product`: SKU, product, category, brand and base economics.

`dim_customer`: customer, channel, region, city and account segment.

`dim_salesperson`: representative and assigned region.

`dim_date`: calendar attributes for time intelligence.

`budget_monthly`: monthly revenue target at YearMonth x Region x Category grain.

## Limitation
Every company, customer, product, transaction and result in this project is synthetic.