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 new data warehouse focused initially on the key areas of the professional services business, with data loaded from the timesheets system and forecasting spreadsheets, and provided the information to users through a set of Web-based reports. The business operations team now gets reports delivered to them weekly rather than spending time using spreadsheets to manually produce information from various sources. Project managers and consultants use the Report Manager Web-based application so that they have easy access to reports that show the current situation; they can also print the reports or export them in formats such as Excel or PDF.

We decided to build a data warehouse instead of reporting directly ...

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