Sale!

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 Office 2010 1st Edition by Philo Janus, Stacia Misner ISBN 0071716734 9780071716734

Original price was: $50.00.Current price is: $35.00.

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 Office 2010 1st Edition Philo Janus Digital Instant Download

Author(s): Philo Janus, Stacia Misner
ISBN(s): 0071716734
Edition: 1
File Details: PDF, 19.08 MB
Year: 2011
Language: english
SKU: EB-2211142 Category: Tags: ,

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 Office 2010 1st Edition by Philo Janus, Stacia Misner – Ebook PDF Instant Download/Delivery: 0071716734, 9780071716734
Full download Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 Office 2010 1st Edition after payment

Product details:

ISBN 10: 0071716734
ISBN 13: 9780071716734
Author: Philo Janus, Stacia Misner

Master Microsoft’s Business Intelligence Tools Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to take full advantage of Microsoft’s collaborative business intelligence (BI) tools. A variety of powerful, flexible technologies are covered, including SQL Server Analysis Services (SSAS), Excel, Excel Services, PowerPivot, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), SharePoint Server 2010, PerformancePoint Services, and Master Data Services. This practical guide focuses on deveoloping end-to-end BI solutions that foster informed decision making. Create a multidimensional store for aggregating business data with SSAS Maximize the analysis capabilities of Excel and Excel Services Combine data from different sources and connect data for analysis with PowerPivot Move data into the system using SSIS, InfoPath, Streamsight, and SharePoint 2010 External Lists Build and publish reports with SSRS Integrate data from disparate applications, using SharePoint 2010 BI features Create scorecards and dashboards with PerformancePoint Services Summarize large volumes of data in charts and graphs Use the SSRS map feature for complex visualizations of spatial data Uncover patterns and relationships in data using the SSAS data mining engine Handle master data management with Master Data Services Publish the components of your BI solution and perform administrative tasks

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 Office 2010 1st Table of contents:

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

People also search for Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 Office 2010 1st:

    
building integrated business intelligence solutions
    
building intelligence inc
    
building integrated services
    
building integrated services llc
    
business intelligence solutions inc

Tags: Philo Janus, Stacia Misner, Intelligence Solutions, SQL Server