We solve complex problems of data modeling and develop tools and solutions to let business perform best through data analysis.

Complex challenges made simple

SQLBI is a consulting firm with a strong and unique experience in Business Intelligence, centered around Microsoft technologies – SQL Server and SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).


We help companies make sense of the information they have available so that they can take strategic informed decisions that deliver better results and performance. 

Publications

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

The real-world guide to designing cubes with Analysis Services 2008 written by Chris Webb, Alberto Ferrari and Marco Russo.

The SQLBI Methodology

Here you can find the papers about the SQLBI Methodology. The first one contains the introduction to the SQLBI Methodology architecture, comparing it to InMon and Kimball methodologies. In the second one you will find a complete data model and ETL of data coming from the well known "AdventureWorks"

The many-to-many revolution

A set of design patterns to build solutions based on many-to-many dimension relationships with Analysis Services 2005.

This area is almost unexplored and at the same time is full of opportunity. The paper is the synthesis of more than one year of experience on Analysis Services 2005, but it is only the beginning. More study and experience is needed, especially in performance evaluation.