Archive of ‘Data Warehouse’ category

Microsoft Big Data Solution

What is Big Data? It is a popular term used to describe growth of structured and unstructured information. This post discusses the Trends driving the “Big Data” and Microsoft Big Data Solution. There are vendors in market which provide Hadoop deployments but most operate outside central IT operations. Microsoft Big Data solution can analyze over […]

Building a CUBE in SQL Server 2008

Creating the Project
To create a cube, we need to create a Analysis Services Project in Visual Studio. Start Visual Studio, select File, New Project. In project dialogue box, select Business Intelligence Projects from Project Types and select Analysis Services Project from right in the dialogue box.

Related Posts:Creating an Analysis Services Project in Visual […]

Data Warehouse terms

This post describes the different useful Data Warehouse terms which are closely associated with Kimbal Data Warehousing approach.

Measure It is a numeric value in reporting and analysis. Example: Price,Balance or Inventory. Measures come from data sources. Measure is characterized by grain.
Dimension A dimension is a collection of related values called members. example: 2008 is a […]