Chapter 5. Core Components of SQL Server 2008

In Chapter 4, we walked through the development of our executive KPI dashboard using SQL Server 2008 with a focus on SSRS. The combination of SQL Server's database services and SSRS is the technical foundation for the basic level of our analytics platform as described in our analytics pyramid, shown again for reference in Figure 5-1.

The analytics pyramid

Figure 5.1. The analytics pyramid

This chapter will cover these core components in greater depth, and weave in examples from our fictional company, Dyno Technologies, to show these components in action. In our deep dive into SQL Server 2008, we will focus on both a set of ...

Get Pro SQL Server 2008 Analytics: Delivering Sales and Marketing Dashboards now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.