Project REAL Technical Overview
Read an introduction to the Project REAL system, its data models, subsystems, and deployment scenarios. This paper is the first in a series that explores various aspects of Project REAL and the best practices that it has revealed.

Project REAL: Analysis Services Technical Drilldown
Get a detailed technical discussion of designs and best practices for Analysis Services that were developed in Project REAL. This paper describes each of the different types of objects, such as data sources, data source views, dimensions, hierarchies, attributes, measure groups, and partitions in detail.

SQL Server 2005 Integration Services: Lessons from Project REAL
Learn some of the best practices and other lessons learned from the ETL portion of the first phase of Project REAL.

Business Intelligence ETL Design Practices
Download this white paper to understand ETL design decisions that were made for each scenario and implementation detail of the Project REAL effort for SQL Server 2005 Integration Services at Barnes & Noble.

Analysis Services 2005 Migration
Learn about the Migration Wizard, a fast and effective tool for moving your existing cubes to Analysis Services 2005.

Project REAL: Data Lifecycle—Partitioning
Download this white paper to get a detailed discussion on how partitioning was implemented in Project REAL, both on the relational data warehouse and in the Analysis Services cubes.

Inventory Predictive Modeling via Microsoft SQL Server 2005 Analysis Services
Discover an approach for building retail out-of-stock predictive models using SQL Server 2005 Analysis Services. When applied to Project REAL data, these models produced very accurate predictions.

Developing Custom Components in SQL Server Integration Services for Project REAL
Read about key learnings made while implementing the custom pipeline components for extracting and parsing data.

Project REAL Monitoring and Instrumentation
This paper describes the system and network instrumentation and monitoring used for Project REAL, focusing on the tools used, their installation and configuration, and the lessons learned.

Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server
This article contains step-by-step instructions for creating a Web page load test, and sample code and instructions for creating a unit test. Also, instructions are provided for setting up the load test that you use to specify load patterns.

TechNet Webcast: Real-World Experience with a Business Intelligence System on SQL Server 2005 (Part 1 of 3): Overview and Design (Level 200)

TechNet Webcast: Real-World Experience with a Business Intelligence System on SQL Server 2005 (Part 2 of 3): Data Engines (Level 300)

TechNet Webcast: Real-World Experience with a Business Intelligence System on SQL Server 2005 (Part 3 of 3): Presentation (Level 300)