Star schema design feedback

Question

I work for an OTC company.

Here is the background on the workflow. Taker (Buyer) --> Requests a quote on derivatives --> Maker(Quoter) responds with quotes (bid/ask) ---> Taker either buys/sells ( traded) or takes no action on the quote. The quote can be sent and received from multiple makers.

Let me know if my star schema is correct.

I am thinking of takers, makers as dimension tables. Requests as one fact table and quotes as another fact table. Is this approach correct?

Answer 1

So you’ve started to identify your measures, once you’ve identified them all the next steps are:

1. Define the grain if each measure; measures with the same grain can exist in the sane fact table; measures with different grains need to be in different fact tables
2. For each fact table, identify the entities you need to filter or aggregate the facts; this gives you your dimensions