Delivering Business Intelligence with Microsoft SQL Server 2005
PART I: Business IntelligenceChapter 1: Equipping the Organization for Effective Decision MakingChapter 2: Making the Most of What You've Got -- Using Business IntelligenceChapter 3: Searching for 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 and Populating Data MartsChapter 7: Fill 'er up -- Using Integration Services for Populating Data MartsPART III: Analyzing Cube ContentChapter 8: Cubism -- Measures and DimensionsChapter 9: Bells and Whistles -- Special Features of OLAP CubesChapter 10: Writing a New Script -- MDX ScriptingChapter 11: Pulling It Out and Building It Up -- MDX QueriesPART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
Chapter 2: Making the Most of What You've Got -- Using Business IntelligenceChapter 3: Searching for 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 and Populating Data MartsChapter 7: Fill 'er up -- Using Integration Services for Populating Data MartsPART III: Analyzing Cube ContentChapter 8: Cubism -- Measures and DimensionsChapter 9: Bells and Whistles -- Special Features of OLAP CubesChapter 10: Writing a New Script -- MDX ScriptingChapter 11: Pulling It Out and Building It Up -- MDX QueriesPART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
Chapter 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 and Populating Data MartsChapter 7: Fill 'er up -- Using Integration Services for Populating Data MartsPART III: Analyzing Cube ContentChapter 8: Cubism -- Measures and DimensionsChapter 9: Bells and Whistles -- Special Features of OLAP CubesChapter 10: Writing a New Script -- MDX ScriptingChapter 11: Pulling It Out and Building It Up -- MDX QueriesPART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
PART II: Defining Business Intelligence StructuresChapter 6: Building Foundations -- Creating and Populating Data MartsChapter 7: Fill 'er up -- Using Integration Services for Populating Data MartsPART III: Analyzing Cube ContentChapter 8: Cubism -- Measures and DimensionsChapter 9: Bells and Whistles -- Special Features of OLAP CubesChapter 10: Writing a New Script -- MDX ScriptingChapter 11: Pulling It Out and Building It Up -- MDX QueriesPART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
Chapter 7: Fill 'er up -- Using Integration Services for Populating Data MartsPART III: Analyzing Cube ContentChapter 8: Cubism -- Measures and DimensionsChapter 9: Bells and Whistles -- Special Features of OLAP CubesChapter 10: Writing a New Script -- MDX ScriptingChapter 11: Pulling It Out and Building It Up -- MDX QueriesPART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
Chapter 8: Cubism -- Measures and DimensionsChapter 9: Bells and Whistles -- Special Features of OLAP CubesChapter 10: Writing a New Script -- MDX ScriptingChapter 11: Pulling It Out and Building It Up -- MDX QueriesPART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
Chapter 10: Writing a New Script -- MDX ScriptingChapter 11: Pulling It Out and Building It Up -- MDX QueriesPART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
PART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
Chapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
PART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
Chapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Transform disparate enterprise data into actionable business intelligence
Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here--from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.