question

LMBUX avatar image
LMBUX asked

A datawarehouse without measures

Am I doing this correctly? There's no measure so this is throwing me off a bit...... Please diagram attached.![alt text][1] [1]: /storage/temp/3768-db-design.png
database-designdata-warehousedatabase-diagramsdiagrams
db-design.png (21.3 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
GPO avatar image
GPO answered
To answer this, you need to do some "business analysis". What are the questions the business needs to answer? Often this will include money. Almost always there will be a date/time/calendar aspect. I note you've called your fact table FactResearcher. The sks in that table seem to be more describing the research than the researcher. So what are some facts about the research that the business might want to know? How many research projects were published last year? By whom? How long did they run for on average? How much did they cost? What proportion ran over budget?
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.