Data Warehousing basic's

Posted on 2014-07-16
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
    LVL 7

    Expert Comment

    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 45

    Expert Comment

    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 14

    Accepted Solution


    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now