Delivering Business Intelligence With Microsoft Sql Server 2008

A practical guide to maximizing the Business Intelligence tools in the new SQL Server release

With help from this fully updated bestselling book, database professionals will be able to transform disparate enterprise data into actionable Business Intelligence. Covering all the new and improved BI features available in SQL Server 2008, the book shows you how to put timely, mission-critical information in the hands of employees across the organization.

Delivering Business Intelligence with Microsoft SQL Server 2008 begins with a discussion of BI, defining what it is and why it is important in todayAnd#39;s business environment. After laying this foundation, the book works through the entire BI lifecycle: defining the analysis database; analyzing the data; mining the data; and delivering BI. Several analysis databases will be built and used for examples throughout the book.

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from 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 analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.Understand the goals and benefits of business intelligenceDesign and create relational data marts and OLAP cubesManage Analysis Services databases using BI Development StudioCleanse data and populate data marts with SQL Server Integration ServicesTake advantage of the flexibility of the Unified Dimensional ModelManipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clusteringDevelop and distribute interactive reports with SQL Server 2008 Reporting ServicesIntegrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control