Project REAL—Business Intelligence in Practice

https://www.microsoft.com/sqlserver/2005/en/us/project-real.aspx#documentation

Project REAL Documentation

The Project REAL team has provided content to help explain the parameters of the project. The following is a list of the documents available for Project REAL:

• 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.
• 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.
• 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.
• Project REAL: Enterprise Class Hardware Tuning for Microsoft Analysis Services
  This paper describes best practices for hardware optimization for a multi-terabyte SQL Server 2005 data warehouse and cube. It describes hardware testing and tuning exercises conducted with large-scale Analysis Services cubes.