In this presentation I’ll cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then we will use SQL Server Reporting Services (SSRS) to report detail on that data. After that we will use SQL Server Analysis Services (SSAS) to create a KPI. Finally we’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.