Data Warehousing basic's

Posted on 2014-07-16
Medium Priority
Last Modified: 2014-07-17
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?


Question by:SQLSearcher

Expert Comment

ID: 40198748
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
LVL 46

Expert Comment

by:Kent Olsen
ID: 40199089
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?
LVL 15

Accepted Solution

Vikas Garg earned 2000 total points
ID: 40199312

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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question