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

Answer 1

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.

Answer 2

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

Answer 3

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

Answer 4

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.

Answer 5

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