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 extended a data warehouse and Analysis Services database to cover new areas to support the objectives. We decided to build reports that query the cube rather than the data warehouse so that we benefited from the performance increase from Analysis Services as well as more advanced and flexible reporting features such as key performance indicators. The scorecard reports were published on a Windows SharePoint Services intranet portal, allowing employees to see how the effects of new policies in their areas lead to improvements in the key performance indicators.

We built a single Analysis Services cube containing several different fact tables with different granularities. To help the users navigate the cube, ...

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