2011 Public MDX Classes

May 5-6: Seattle, Portland or remote  click here

Aug 11-12: Seattle, Portland or remote (link forthcoming)

Words of Wisdom Concerning the Idiocy Known as NoSQL

Words of wisdom culled from the internet concerning NoSQL, the grab bag of technologies dredged from the trash heap of decades past:

I can't wait for NoSQL to die

It's painful to watch a hierarchical data model being touted as if it were something new

Brian Aker's hilarious presentation

MDX Course Oct 21-22

Two day course which can be attended in Seattle (Bellevue), Portland (Beaverton), or remotely. Go here for details.

MDX Course, Aug 12-13

This is a two day course which can be attended in Seattle (Bellevue), Portland (Beaverton), or remotely. Go here for details.

Performance Point 2010

In Performance Point 2010, Microsoft has corrected some of the fatal shortcomings that exist in the 2007 version.

Click to read more ...

Many-to-Many Dimensions, How Scalable?

SSAS introduced the concept of many-to-many relationships between dimensions, an outstanding development that partially overcomes the rigidity of strict star/snowflake schemas. But with this feature came all sorts of warnings from Microsoft.

Click to read more ...

Data Warehousing Not So Best Practices

Certain rules of database design are commonly discarded in data warehouses, not necessarily for the good.

Click to read more ...

Performance Point, Ugh

Performance Point 2007 is one of the most abysmal pieces of BI-related software I've had the misfortune of working with. In short:

• Analytic Grids/Charts, which otherwise have some nice features, provide what is beyond a doubt the drabbest UI I've seen since the advent of the GUI.
• Scorecards can be made to look decent, but are so lacking in functionality as to be nearly useless.
• Planning Server is so dysfunctional that it's a joke.