Project Real

It can be quite difficult to get your head around a data warehouse/reporting solution.

But fear not. Microsoft, together with a number of it’s technology partners, has put together a project called Project Real. This consists of a sample implementation based on SQL Server technology and a set of sample data.  This kit consists of the following:

  • A set of instructions for setting up the environment
  • Guidance on how to explore the implementation
  • A sample relational data warehouse database (a subset of the Project REAL data warehouse)
  • A sample source database (from which we pull incremental updates)
  • SSIS packages that implement the ETL operations
  • An SSAS cube definition and scripts for processing the cube from the sample warehouse
  • Sample SSRS reports
  • Sample data mining models for predicting out-of-stock conditions in stores
  • Sample client views in briefing books for the ProClarity and Panorama BI front-end tools

Project Real has been around for quite a while, and I’ve played around with it a few times. For some reason it never occurred to me to blog about it. It is well worth the effort working through this Microsoft kit as it is not often you are given the opportunity to work through a DW/BI implementation from start to finish.

Advertisements

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

%d bloggers like this: