O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we built a data warehouse that consolidates information from ERP systems and other sources. The data warehouse acts as a central repository that can support information-intensive business initiatives with reduced cost and complexity.

In this first phase of development, we focused on the shipments business process to provide sales and profitability analysis. We established the grain of the Shipments fact table and identified the key dimensions and attributes that will be used to analyze the information. The Product dimension has a natural hierarchy with three levels, so we used a snowflake design to make the ETL process easier and to improve performance of Analysis Services dimension loading.

The Customer and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required