Identifying the fact table in data warehouse design -

i'm trying design first data mart star schema excel sheet containing informations desk service calls, sheet contains 33 fields including different informations , can't identify fact table because want reporting later based on different kpi's. want know how identify fact table measures , have question : can fact table contain foreign keys of dimensions , no measures? in advance guys , sorry bad english.

1. you can have more 1 fact table.

2. a fact table represents event or process want analyze.

3. the structure of fact tables depend on process or event trying analyze.

4. you need tell events or processes want analyze before can further.

can fact table contain foreign keys of dimensions , no measures?

yes. called factless fact table.

---

let's want basic analysis of calls:

your full table might this

call_id start_date duration agent_name agent_tenure    (how long worked company) customer_name customer_tenure (how long customer) product_name    (the product customer calling about) resolved 

you turn fact table this:

call_id start_date_key agent_key customer_key product_key duration       (measure) resolved       (quasi-measure) 

and have date dimension table, agent dimension table, customer dimension table , product dimension table.

agile data warehouse design book, ones kimball.