none
New to Data Warehousing..need basic info of Dimension and fact table--very basic level information with some examples

    Question

  • New to Data Warehousing..need basic info of Dimension and fact table--very basic level information with some examples

    ilikemicrosoft

    Thursday, April 19, 2012 6:15 AM

All replies

  • Hi,

    There is msdn for developers who want to start with a perticular Microsoft technology.

    Check this link for the basics of data warehousing inclusing dimensions,facts etc.

    http://blogs.msdn.com/b/syedab/archive/2010/06/02/data-warehouse-concepts.aspx

    To give you a brief idea, I willtry to explain with a simle example.

    Suppose you have sales data of some company, and now you want to analyze it.

    Dimension: This is nothing but how you want to view/query your data. For example, you may want to see your sales based on countries/products/customers/employees etc. So these four tables work as dimensions.

    Facts: Fact tables are the  tables where the data to be aggregated lies(sales values in our case). ================================

    Plaese mark as answer if helpful.


    Thursday, April 19, 2012 6:40 AM
  • Pick any title from here http://www.kimballgroup.com/html/books.html

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Thursday, April 19, 2012 10:05 AM
  • You may find this lesson helpful, as well as some of the related ones in the same section and in the SSAS sections:

    http://msbiacademy.com/Lesson.aspx?id=2


    Rob Kerr SQL Server MVP CTO, BlueGranite

    Saturday, April 21, 2012 3:05 AM
  • Hi,

    I think the above links would definitely help. Let me give you a short example.

    Lets take the sales of a particular company, It has different

    1) Products

    2) Geographies

    3) Departments for these sales

    Suppose you need the sales of this company for a particular Product and a particular geography. The Sales data is the fact data and the product and Geography are your dimensions based on which you are measuring your sales.

    Dimensions in my above examples are DimProduct and Dimgeography and DimDepartment.

    FactSales is the table which has all the factual data + a forgiegn key relationship to the Dimensions.

    Friday, April 27, 2012 9:54 AM
  • Hi

    Here's definitely a real life example of building a data warehouse building kimball data warehouse that so far covers requirements gathering and Kimball bus matrix

    Regards

    Emil

    Monday, April 30, 2012 10:27 PM