Installing SSAS 2012

I don’t usually write posts like this but there have been a few substantial changes to how SSAS 2012 is...

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....

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...

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....

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...

Building the Enterprise DW/BI System with SQL Server PDW

Building the Enterprise DW/BI System with SQL Server PDW
Most readers considering a Parallel Data Warehouse already have a data warehouse...

Columnstore Indexs

Columnstore Indexes for Fast DW

The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...

SSAS Tabular Model – Query Modes

One of the most compelling features of the new SSAS Tabular Model is the ability to set the model’s Query...

MDX SSRS Parameter Values

<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...

Cartesian/Cross Join

I was once asked in a job interview if I knew what a Cartesian/Cross Join was.
A more interesting question is:...