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 100 petabytes of data to produce results...
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.
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 member of Time...