Nick Barclay: BI-Lingual

A colleague of mine put together a hilarious PeepzMovie that was inspired by some frustrating projects. If you're a BI pro, do yourse...

Full disclosure: The authors of this book provided me with a free review copy. Time to dust off this blog and post something. Wow, has it ...

While I was creating the recent series of walkthrough posts on I put together a diagram of the major objects that make up an MDS model. I f...

In homage to the Thanksgiving celebration about to take place in the USA I thought I’d place a bet on what I think will be the most overused...

OK, so we’ve created the objects and loaded data into them. Now we can have a closer look at what has happened to the MDS database. What h...

There are two kinds of Hierarchy that can be created within MDS: Derived and Explicit . We’re only going to deal with derived hierarchies ...

Now that we’ve defined some basic structures we can add some data. Through MDS' web based management interface we can manually add indiv...

Attributes are defined within entities. An attribute contains values that help to describe the member they’re related to. For example our P...

One or more Entities can be defined within a model. Entities are the foundational objects within an individual model and serve as the conta...

Models are the highest level container within an instance of MDS. Models are created to manage groups of similar data. In BI-speak it’s not...

Like many other geeks out there I learn by doing. One of the things on my todo list has been to get familiar with MDS. During my experimenta...

Many of you may know Don Dodge - he’s a start up and technology evangelist who, up until a day ago, worked for Microsoft. Apparently Don was...

‘member what happened when Microsoft said “Hey, let’s bundle a reporting engine into the SQL Server license”, “Hey let’s bundle an OLAP e...