El Bruno

Buenas

mientras sigo esperando que deje de llover escribiendo un poco sobre mis nuevas experiencias en el fabuloso mundo de Business Intelligence; no puedo dejar de recomendar a todas aquellas personas que utilicen Microsoft SQL Server 2005; que revisen los documentos de Project REAL.

¿En qué consiste el Project REAL?, pues es una implementación de referencia para un projecto casi real de Business Intelligence; donde se explican paso a paso las experiencias y lecciones aprendidas durante el mismo; y también se desprenden algunas Best Practices a tener en cuenta en este tipo de proyectos.

Un detalle, este proyecto no es una demo (como por ejemplo la base de datos AdventureWorks), y para asegurar la calidad del mismo han participado partners como: Apollo Data Technologies, EMC, Intellinet, Panorama, Proclarity, Scalability Experts, y Unisys.

Si tu proyecto no es de BI, pero utilizas ETLs por ejemplo, puedes darle un vistazo a la seccion de Integration Services ya que aporta conceptos y experiencias muy interesantes; lo mismo aplica para aquellas personas que utilicen Reporting Services.

He aquí los links de acceso a la información principal del Proyect REAL:

• Project REAL
• Download Reference Implementation
• 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.
• 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.

Nuevamente les recomiendo invertir un poco de tiempo en leer este excelente material de referencia.

Saludos

El Bruno