Rittman Mead - Delivered Intelligence

In a prior blog entry here, i had shown the advantages of using the MODEL clause. I also showed how the MODEL clause can be used to visualize the relational data in a multi-dimensional format. In most cases, using the MODEL clause alone can be sufficient. Just to recap, the MODEL clause divides your resultant […]

The data warehouse continues to be one of the most organizationally complex and technically interesting projects in Information Technology. Rittman Mead are proud to announce this unique data warehousing training opportunity, in collaboration with Kimball University and Quest For Knowledge.
Learn from Margy Ross and Warren Thornthwaite, co-authors with Ralph Kimball of the popular The Data […]

A few days ago, Farooq posted some comments on an old post of mine. The final comment in our exchange concerned storing activities in our data warehouse by time (actual hour and minute). This is quite a common requirement, especially where the performance of customer service agents is being measured (as in Farooq’s question)
I would […]

Curiously I am working on two very similar data architecture projects at the moment, both small scale data warehouses, and both in similar subject domains. Most of the data warehouses I get involved in the are effectively a series of snapshots of a set of measures for discrete time slices be it average stock holding […]

The other day a colleague invited me to sit in on workshop session with a customer to discuss changes to an attribute of product. On the face of it it sounds a bit of overkill to spend two hours discussing the meaning of just one attribute, but when that attribute is cost and the impact […]