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.