Start Learning DataWareHousing

Question

Post reply

Start Learning DataWareHousing

azhar.iqbal499

SSCrazy

Points: 2812
More actions
November 10, 2011 at 10:18 pm

#259842

My boss has given me task of "Create DataWareHouse". Please suggest me basic level tutorials to start with.
What are the requirements to create DataWareHousing in SQL SERVER 2008R2.
Thanks
Azhar Iqbal

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

Adventure Works Sample Data Warehouse

http://msdn.microsoft.com/en-us/library/ms124623.aspx

Microsoft SQL Server Community Projects & Samples

http://sqlserversamples.codeplex.com/

JonFox SSCrazy Points: 2157 More actions · Answer 2

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

http://www.amazon.com/Microsoft-Data-Warehouse-Toolkit-Intelligence/dp/0470640383/ref=sr_1_1?ie=UTF8&qid=1321019458&sr=8-1

azhar.iqbal499 SSCrazy Points: 2812 More actions · Answer 3

What should I learn before to start Warehousing.

Thanks

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

First of all, read the Data Warehouse Toolkit by Ralph Kimball.

Practically an industry-standard, and a must read for everyone who starts in data warehousing.

The book suggested by JonFox is an adapted version specifically for the Microsoft products.

If you finished the books, learn more about SSIS, SSAS and SSRS.

In total, this is about 1 month of classroom training, just so that you know what you're up against.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 5

First of all, read the Data Warehouse Toolkit by Ralph Kimball.Practically an industry-standard, and a must read for everyone who starts in data warehousing.

And not to forget Bill Inmon's Corporate Information Factory. You would be biased, if you read Kimball and ignore Inmon.

Corporate Information Factory

http://www.inmoncif.com/home/

If you finished the books, learn more about SSIS, SSAS and SSRS.
In total, this is about 1 month of classroom training, just so that you know what you're up against.

I am in DW Design for many years. I still believe I don't know anything about it. 😉

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

Dev (11/14/2011)
First of all, read the Data Warehouse Toolkit by Ralph Kimball.Practically an industry-standard, and a must read for everyone who starts in data warehousing.
And not to forget Bill Inmon's Corporate Information Factory. You would be biased, if you read Kimball and ignore Inmon.
Corporate Information Factory
http://www.inmoncif.com/home/

I haven't read it (yet), so I am completely biased 😀

Dev (11/14/2011)

If you finished the books, learn more about SSIS, SSAS and SSRS.
In total, this is about 1 month of classroom training, just so that you know what you're up against.
I am in DW Design for many years. I still believe I don't know anything about it. 😉

Indeed. The 1 month training was just an indication that this should not be taken so lightly.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

RonKyle SSC-Dedicated Points: 31556 More actions · Answer 7

Your boss will need to give you a lot of extra time. If there is any complexity to your business, and the assumption is that it would be, this is not a side-project.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 8

RonKyle (11/15/2011)
Your boss will need to give you a lot of extra time. If there is any complexity to your business, and the assumption is that it would be, this is not a side-project.

Or hire a Consultant (like me) 😉

mthurber Mr or Mrs. 500 Points: 523 More actions · Answer 9

Try this:

http://msdn.microsoft.com/en-us/SQL10R2BYFBI-TrainingCourse

andersg98 SSCertifiable Points: 5180 More actions · Answer 10

andersg98

SSCertifiable

Points: 5180

November 15, 2011 at 2:26 pm

#1408177

http://www.kimballgroup.com/

Eric M Russell SSC Guru Points: 125560 More actions · Answer 11

azhar.iqbal499 (11/10/2011)
My boss has given me task of "Create DataWareHouse". Please suggest me basic level tutorials to start with.
What are the requirements to create DataWareHousing in SQL SERVER 2008R2.
Thanks
Azhar Iqbal

For Week #1, do nothing but interview people in your business and IT department, asking them what enterprise data needs they have. What do these people want to get out of a datawarehouse?

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 12

And just as importantly, don't try to do it all at once. By interviewing the business community you should be able to identify key aspects, questions that need answering, and target those first. Build the data warehouse incrementally with useable rollouts every 60 to 90 days.