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 an Analysis Services database using the data warehouse as the source. The key goals were to support flexible analysis of the profitability of various customer groups and products, and to support the company’s On-Time Delivery improvement initiative. The Analysis Services database can be directly accessed by the users using tools such as Excel, reducing some of the pressure on IT to deliver standard reports.

We extended the fact table views in the data warehouse to provide the information in the best format for Analysis Services, such as transforming logic about which shipments were on time into an additive OnTime column with a 0 or 1 value. We also used the various dates in the fact table to calculate ...

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