Data Warehousing basic's

Hello Experts Exchange
I have started a new job and I need to build a SQL Server data warehouse, is there a web page that will tell me the basics of building a data warehouse?

I need to know things like what type of data goes in a fact and dimension tables?


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You need to create a SQL Server data warehouse? You want to do it alone?

It is a big project to me.

you not only need to create schema for sql but also you need to create interface for user to key in data and retrieve data, print report and so on.

Furthermore, if you create a new app from scratch then testing required and testing is the most time consuming part.

I suggest you to get a customize ERP or inventory management software
Kent OlsenData Warehouse Architect / DBACommented:
Hi Searcher,

Not to be too hard on you, but you need help with this.  Not the question, but the actual work.

A data warehouse is so much different than a typical OLTP that you can't design and build one without quite a few prerequisites.  The fact that you're asking this question in a public forum indicates that you don't have that background.  You need to be comfortable with designing databases, you need to understand data warehousing models, and you need to know how the customer intends to use the data warehouse.

- How much data is there?
- What's the nature of the business/data?
- What answers (reporting) do you expect from the data warehouse?
Vikas GargBusiness Intelligence DeveloperCommented:

Brave effort and Data Warehouse is understandable if you decide to do it.

And as you have asked for a web page or site which may be helpful to you to get started with Data Warehouse then here is the link which will give you brief knowledge of Data warehouse terms.

All the best to get started

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.