Manage, analyze, and distribute business data with the help of this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analytics solutions.
Real-world examples illustrate all the powerful BI capabilities of SQL Server 2008. This is your comprehensive guide to transforming disparate data into actionable insights for users throughout your organization.
Understand the goals and benefits of business intelligence
Design and build relational data marts and OLAP cubes
Manage Analysis Services databases with BI Development Studio
Clean data and populate data marts with SQL Server Integration Services
Take advantage of the flexibility of the unified dimensional model
Manipulate and analyze data using scripts and MDX queries
Use data mining to identify data patterns, correlations, and clusters
Develop and distribute interactive reports with SQL Server 2008 Reporting Services
Integrate business intelligence into business applications using ADOMD.NET and the Report Viewer Control