Tell me more ×
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. It's 100% free, no registration required.
up vote 0 down vote favorite

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
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 at 14:33
Ok, fair enough. – Mike81 Jan 10 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 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 at 0:15

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

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined in the FAQ. 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 closed questions here.

1 Answer

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 at 23:42
Thanks, started reading already. – Mike81 Jan 10 at 6:58

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