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: April 2012

Enterprise Data Warehouse Architecture Options

Enterprise Data Warehouse Architecture Options

Of course, your architecture depends on your business requirements along with technical, historical, and political factors. While business requirements are usually business-specific, we can start with a list of broad requirements, or architecture goals, that most organizations would support:

1. Excellent query performance for users Read more

0 comments, 1,467 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 25 April 2012

Massively Parallel Processing and the Parallel Data Warehouse

Data growth is related to Moore’s law. As computers get faster and more powerful, we are using them to process more data in more complex applications. Traditional sources such as ERP systems are processing more transactions as our organizations grow. Newer sources such as web browsing activity, mobile devices, and… Read more

0 comments, 3,029 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 15 April 2012

The Kimball Approach

The Kimball Approach

There are a lot of misconceptions about dimensional modeling and the Kimball approach to building a DW/BI system. It’s worth reading this section even if you are already familiar with the Kimball approach; you might be surprised at what you learn. The Kimball approach to creating an… Read more

4 comments, 9,217 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 8 April 2012

Parallel Data Warehouse – Slowly Changing Dimension

Most of my day-to-day work is currently centered around Microsoft’s Massively Parallel Processing Appliance call PDW (Parallel Data Warehouse).  Many of the same techniques common to SMP (Symmetric Multiprocessing)systems such as Kimball method Slowly Changing Dimension (SCD) are still very important.

Identifing the deltas between an incoming dataset… Read more