Delivering Business Intelligence with Microsoft SQL Server 2008

  • Authors:
  • Brian Larson

  • Affiliations:
  • -

  • Venue:
  • Delivering Business Intelligence with Microsoft SQL Server 2008
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008Manage, 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 ControlTable of contentsPart I: Business IntelligenceChapter 1. Equipping the Organization for Effective Decision MakingChapter 2. Making the Most of What You've Got--Using Business IntelligenceChapter 3. Seeking the Source--The Source of Business IntelligenceChapter 4. One-Stop Shopping--The Unified Dimensional ModelChapter 5. First Steps--Beginning the Development of Business IntelligencePart II: Defining Business Intelligence StructuresChapter 6. Building Foundations--Creating Data MartsChapter 7. Transformers--Integration Services Structure and Components Chapter 8. Fill'er Up - Using Integration Services for Populating Data MartsPart III: Analyzing Cube ContentChapter 9. Cubism--Measures and DimensionsChapter 10. Bells and Whistles--Special Features of OLAP CubesChapter 11. Writing a New Script--MDX ScriptingChapter 12. Pulling It Out and Building It Up--MDX QueriesPart IV: MiningChapter 13. Panning for Gold--Introduction to Data MiningChapter 14. Building the Mine--Working with the Data Mining ModelChapter 15. Spelunking--Exploration Using Data MiningPart V: DeliveringChapter 16. On Report--Delivering Business Intelligence with Reporting SystemsChapter 17. Falling into Place--Managing Reporting Systems ReportsChapter 18. Let's Get Together--Excel Pivot Tables and Pivot ChartsIndex