Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are a SaaS startup offering purchase & procurement solutions. The data model for operational transactions has been created (relational DB). We also want to offer analytics on those transactions to decision makers but using ad hoc queries to get this data out of the existing tables would be inefficient. What resources are out there on data modelling for business intelligence / data warehousing?

share|improve this question

closed as off topic by Jon Seigel, Mark Storey-Smith, jcolebrand Jan 8 '13 at 14:33

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

What have you found already? By the terms of our faq, this feels like a highly subjective question, unless you can define all the key metrics you need your database to perform to. Chatty, open-ended questions diminish the usefulness of our site and push other questions off the front page. Because you have a good answer below that really helps cut to the heart of figuring out what you need, I'm going to close this question in lieu of needing better requirements. – jcolebrand Jan 8 '13 at 14:33
Ok, fair enough. – Mike81 Jan 10 '13 at 6:58
Feel free to edit the question itself, then @me in a comment and I'll reevaluate and give pointers. – jcolebrand Jan 10 '13 at 14:52
Thanks. I'm completely new to the topic of data modelling for business intelligence and I was just looking for a resource that covers the basics, such as the one suggested below. Hence, at this point, I cannot be anymore specific. I might revisit the question once I have read the suggested book. – Mike81 Jan 11 '13 at 0:15
up vote 4 down vote accepted

I recommend the Data Warehousing Toolkit by Ralph Kimball. This is a solid book on dimensional modeling and provides many "soup to nuts" case studies.

share|improve this answer
+1. Still a great place to start. – Mitch Wheat Jan 7 '13 at 23:42
Thanks, started reading already. – Mike81 Jan 10 '13 at 6:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.