Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Microsoft Business Intelligence and Data Warehousing

Garrett Edmondson, Independent Consultant MCITP & MCTS: 10+ years experience with BI stack.

Archives: January 2012

Tabular Model

One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The Tabular model along with the multidimensional model comprise the Business Intelligence Symantec Model (BISM).

To be honest when the Tabular Model and the BISM where introduced along with DAX I… Read more

0 comments, 1,880 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 31 January 2012

Master Data Services 2012

As I mentioned in a pervious post Master Data Services for SQL 2012 is a huge improvement over the SQL Server 2008 R2 version. The biggest difference is the ability for users to manage entities directly in Excel!

This is important because now Data Stewards can perform most of their… Read more

2 comments, 2,293 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 19 January 2012

SSIS ETL Frameworks

In my years as a BI Professional I have seen many ETL Frameworks. They range from homegrown internal solution to out-of-the-box solutions developed by small and large consulting companies and other various providers.

There are many similarities and differences between, but they are all designed to address two general requirements: Read more

2 comments, 3,804 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 4 January 2012