Rittman Mead - Delivered Intelligence

One of our clients that I worked at recently had a rather tricky report that
they wanted me to help with. At present, the report was put together using
Excel, and looked something like this:

The report consisted of two sections, the top section being the actual,
budget and variance figures for a department, and the bottom section being […]

Ingredients:
1 data source
1 database to store the data warehouse
1 reporting layer (optional)

Method:
Add data source to database, mix well. Decorate with optional reporting layer.
Sounds simple, and not a Kimball or Inmon in sight! But as with all great recipes it’s the quality of the ingredients that counts.
The database: I only “cook” with Oracle. Not because it […]

I’m still alive, but away from home most of the time at the moment so unable
to update the site or reply to emails. My rittman.net mail account is *still*
playing up, so if you need to get in contact (please, no technical questions for
the time being) you can contact me at mark.rittman at gmail.com. If you
followed […]

Of all dimensions, time is perhaps the most common. In fact I would be hard pressed to think of a data warehouse that did not encompass time. Inventory, sales, phone calls, web click-throughs, energy usage or whatever, they all hold measures (quantities) along a time line. So you’d think that time series aggregates (such as […]

I’m having a few issues with my email server at the moment. If you need to get in contact with me over the next few days, or you’ve mailed me recently and not heard back, drop me a line at mark.rittman at gmail.com and I’ll pick it up from there.