Sign in  |  Register
Advanced search
Publication Cover

CITATION

Janus, Philo and Misner, Stacia. Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010. US: McGraw-Hill Osborne Media, 2011.

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010

Authors: Philo Janus and Stacia Misner

Published:  February 2011

eISBN: 9780071716741 0071716742 | ISBN: 9780071716734
Open eBook
  • Contents
  • Foreword
  • Acknowledgments
  • Introduction
  • Chapter 1 What Is Business Intelligence?
  • Business Intelligence
  • Aggregating Data
  • Cleaning Data
  • Reports
  • Ad Hoc Reporting
  • Dashboards
  • Scorecards
  • Key Performance Indicators (KPI)
  • Strategy Maps
  • Summary
  • Chapter 2 Collaboration Meets Business Intelligence
  • SQL Server
  • Business Intelligence Development Studio (BIDS)
  • SSIS
  • SSAS
  • Reporting Services
  • Master Data Services
  • Business Intelligence and Collaboration
  • SharePoint
  • Excel, Excel Services, and PowerPivot
  • PerformancePoint Services
  • Visio Services
  • Business Connectivity Services
  • Summary
  • Chapter 3 SQL Server Analysis Services
  • OLAP Technical Overview
  • Online Analytical Processing (OLAP)
  • SQL Server Analysis Services
  • Architecture
  • Administrative Tools
  • SQL Server Management Studio (SSMS)
  • Storage Modes
  • Writeback
  • SSAS Front Ends
  • Excel
  • SharePoint
  • PerformancePoint Services
  • Reporting Services
  • Report Builder
  • Code
  • Summary
  • Chapter 4 Excel and Excel Services
  • Excel as an Analysis Tool
  • Conditional Formatting
  • Pivot Tables
  • Writeback
  • Excel Services
  • Web Services
  • Excel Web Application
  • Summary
  • Chapter 5 PowerPivot
  • Introducing PowerPivot
  • PowerPivot and Excel
  • Pivot Tables from PowerPivot
  • PowerPivot for SharePoint
  • Management Dashboard
  • PowerPivot Architecture
  • Integration with Excel Services
  • PowerPivot as a Data Source
  • Summary
  • Chapter 6 Getting Data In
  • SQL Server Integration Services
  • Control Flow
  • Data Flow
  • BizTalk Server
  • InfoPath and Workflow
  • Electronic Forms
  • InfoPath for Data Entry
  • Data Connections
  • InfoPath and SharePoint
  • StreamInsight
  • SharePoint Lists
  • Summary
  • Chapter 7 SQL Server Reporting Services
  • Creating Reports in BIDS
  • Data Sources
  • Data Sets
  • Report Design
  • Tablix
  • Sparklines
  • Data Bars
  • Other Controls
  • Report Builder
  • Report Manager
  • SharePoint Integrated Mode
  • Export Formats
  • Summary
  • Chapter 8 SharePoint
  • Business Intelligence Center
  • Quick Launch
  • Document Libraries
  • Data Connections Library
  • Status Lists
  • SharePoint Dashboards
  • Dashboard Pages
  • Status List Web Parts
  • Reporting Services Web Parts
  • Chart Web Parts
  • Excel Web Access Web Parts
  • Filters
  • Summary
  • Chapter 9 Scorecards and Dashboards
  • PerformancePoint Services
  • PerformancePoint Content Types
  • Dashboard Designer
  • Building Scorecards
  • Data Sources
  • Indicators
  • KPIs
  • Scorecards
  • PerformancePoint Web Parts
  • Decomposition Tree
  • PerformancePoint Reports
  • Analytic Reports
  • Dashboard Reports
  • Scorecard Reports
  • Building Dashboards
  • Filters
  • Dashboards
  • Dashboard Deployment
  • Summary
  • Chapter 10 Charts and Graphs
  • Working with Quantitative Data
  • Time Series
  • Category Comparison
  • Ratios
  • Variance
  • Correlations
  • Distribution
  • Excel
  • Excel Data Sources
  • Excel Charts
  • Excel PivotCharts
  • SharePoint Chart Web Part
  • Chart Web Part Data Sources
  • Chart Web Part
  • Reporting Services
  • Chart Wizard
  • Charting Correlated Quantitative Values in Reporting Services
  • Custom Series Properties
  • Other Controls
  • PerformancePoint Services
  • Basic Structure
  • Filters
  • Summary
  • How to Choose a Charting Tool
  • Chapter 11 Maps
  • Introducing Maps
  • Spatial Data Types
  • Spatial Data Sources
  • Creating a Map
  • Map Elements
  • Working with Map Layers
  • Adding a Map Layer
  • Configuring Map Element Properties
  • Summary
  • Chapter 12 Data Mining
  • Introduction to Data Mining
  • What Is Data Mining?
  • Goal of Data Mining
  • Data Mining Process
  • Introducing CRISP-DM
  • Applying CRISP-DM to Microsoft BI
  • Data Mining Add-Ins
  • Architecture
  • Data Preparation Tools
  • Table Analysis Tools
  • Data Mining Tools
  • PowerPivot for Excel
  • Data Mining in Analysis Services
  • Architecture
  • Mining Model Designer
  • Summary
  • Chapter 13 Master Data Services
  • Introduction to Master Data Management
  • Master Data Preparation
  • Configuring Master Data Services
  • Creating Model Objects
  • Assigning Business Rules
  • Importing Data
  • Master Data Stewardship
  • Working with Master Data
  • Master Data Administration
  • Exporting Master Data
  • Managing Versions
  • Summary
  • Chapter 14 Publishing and Administration
  • Integration Services
  • Package Store
  • Deploy Packages
  • Secure Packages
  • Schedule Packages
  • Analysis Services
  • Deploy the Database
  • Secure the Database
  • Schedule Processing
  • Back Up the Database
  • Excel Services
  • Manage External Data Connections
  • Secure Workbooks
  • PowerPivot
  • Reporting Services
  • Deploy Reports
  • Secure Report Server Items
  • Configure Stored Credentials
  • Configure Processing Options
  • SharePoint
  • PerformancePoint Services
  • Master Data Services
  • Deploy a Model
  • Secure Master Data Services
  • Summary
  • Appendix Chart Types
  • Index