Data Warehousing and Data Science

25 November 2009

Building Cubes From Operational Systems (SQLBits Presentation)

Filed under: Analysis Services,Event — Vincent Rainardi @ 9:40 pm
Tags: ,

My presentation at SQLBits 5 last Saturday is here: Building Cubes From Operational Systems.

SQL Scripts for the DDL and DSV are here:, and the BIDS project files are here:

Any problem downloading please let me know.


  1. […] 2. CustomerKey. In the stock broker data mart (see my SQLBits presentation here for a background), in the account balance fact table we have AccountKey, OrderDateKey, […]

    Pingback by Putting Higher Grain Attributes into a Separate Dimension « Data Warehousing and Business Intelligence — 5 March 2011 @ 6:23 pm | Reply

  2. […] is an order table in a stock brokerage company (click here for a background). It has these 3 columns: Order date time, cancellation datetime, settlement date. […]

    Pingback by Datetime Columns in a Fact Table « Data Warehousing and Business Intelligence — 8 March 2011 @ 10:03 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: