Data Warehousing and Business Intelligence

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: SQLScripts.zip, and the BIDS project files are here: Broker5.zip.

Any problem downloading please let me know.

Advertisements

2 Comments »

  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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: