Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Looking for good books/resources for SQL 2k8 data warehouse Expand / Collapse
Author
Message
Posted Sunday, September 16, 2012 9:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:24 AM
Points: 128, Visits: 490
All,

** I think this is the appropriate forum but please let me know if not and I'll move it **

My company is beginning to discuss setting up a data warehouse so we can do reporting from our numerous sources. Since I'd like to get a head start, I figured I'd ask if anyone had a good book or resource for this.

We'll be using SQL 2k8 R2 pulling data from the production databases to the BI/DW/whatever-its-called server where the reports will run.

Thanks,
Mark



Post #1359893
Posted Sunday, September 16, 2012 10:12 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 3:27 PM
Points: 481, Visits: 782
If you are not already aware of it, a good read on the subject of ETL can be found in the "Stairway" section on this website. Look for "Stairway to SSIS" and so forth.

And don't forget to check Books Online.
Post #1359898
Posted Sunday, September 16, 2012 8:12 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:19 PM
Points: 37,075, Visits: 31,636
Mark Eckeard (9/16/2012)
All,

** I think this is the appropriate forum but please let me know if not and I'll move it **

My company is beginning to discuss setting up a data warehouse so we can do reporting from our numerous sources. Since I'd like to get a head start, I figured I'd ask if anyone had a good book or resource for this.

We'll be using SQL 2k8 R2 pulling data from the production databases to the BI/DW/whatever-its-called server where the reports will run.

Thanks,
Mark


Depending on the condition of the database, you might not need to go through the rigors of setting up a a data warehouse. Just write some good reporting code.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1359947
Posted Monday, September 17, 2012 4:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:31 AM
Points: 876, Visits: 2,392
If you're new to data warehousing then books by Ralph Kimball (Data Warehousing Toolkit series by Wiley) and Bill inmon are good reads, though a little dry, but good for general design principles, as well as planning the implementation

One of the best books I've read was : "Building a Data Warehouse With Examples In SQL Server" by Vincent Rainardi (Apress Publication) is worth picking up, its not as dry as the Kimball/Inmon books, and delves more in to the architecture side of DW's.

For the ETL (extract Transform and Load) side of Joy Mundy does a good book which is part of the Data warehouse toolkit series.

Hope this helps.


_________________________________________________________________________
SSC Guide to Posting and Best Practices
Post #1360083
Posted Tuesday, September 18, 2012 3:15 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 12:36 AM
Points: 178, Visits: 574
so we can do reporting from our numerous sources


Consider whether you just want a more convenient place to perform system specific operational reporting, or whether you want to match and conform data across different systems, and thereby derive more enlightening KPI's (i.e. Department Cost from your Finance System / headcount from your HR system)

This might flush out some more specific requirements, and your data warehouse should be driven primarily by business requirements.
Post #1360636
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse