September 3, 2011 at 9:55 am
So our company is going to start building a data warehouse.
We are looking at hiring an outside consulting firm to come in because none of us have any solid data warehouse experience.
However, I want to study up on this so I can be better educated when working with the consultants.
Any suggestions on a good place to start?
Good books, etc..?
I love Microsoft's TechNet videos as I can watch those when I'm cooking, doing house chores, etc... but I haven't been able to find any that talk about actually building a warehouse and the base level concepts, dimension, fact, snowflake design theory, etc...
Just looking for some help in where to start, thanks!
September 3, 2011 at 12:34 pm
Start here:
http://www.amazon.com/Building-Data-Warehouse-W-Inmon/dp/0764599445
Is it really just a Data Warehouse you want, or do you actually want an end-to-end Business Intelligence solution? A Data Warehouse is one aspect of a BI strategy but you also need to work on the bigger picture: data governance, management and admin, information delivery, presentation and reporting toolset.
September 3, 2011 at 3:21 pm
this too
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com
September 3, 2011 at 3:24 pm
For this I just need to know about the warehouse structure. They are using Microstrategy so that will be our reporting tool. SSIS for the etl I expect.
September 5, 2011 at 3:16 pm
Thanks!
I placed an order for the Kimball one, it appeared to be a more introductory approach to start with.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply