Delivering Business Intelligence with Microsoft SQL Server 2005

Brian Larson

776 pages, parution le 15/03/2006

Ajouter à une liste

Indisponible

Résumé

Data warehouse administrators, Business Intelligence (BI) solution developers, and BI analysts will find out how to get the most out of Microsoft's powerful BI tools which are included free in SQL Server 2005. This practical, start-to-finish guide explains how to develop a comprehensive, secure, integrated, and highly available BI solution. Readers will learn to set up the database, mine and analyze data, and deliver the results.

Provides a complete understanding of the BI lifecycle and the Microsoft tools designed to handle each step in that lifecycle
Features real-world example scenarios so readers can apply their knowledge
All code will be available free for download

Key Features

Step-by-step, start-to-finish instructions that lead readers through the creation of complete processes and solutions
Provides a complete understanding of the business intelligence lifestyle and the Microsoft tools designed to handle each step in that lifestyle.
Example scenarios that place the business intelligence concepts and Microsoft tools in a real-world context and assists the reader in applying this knowledge to their particular business situations.
All code available for download

Sommaire

Business Intelligence
- Equipping the Organization for Effective Decision Making
- Making the Most of What You've Got -- Using Business Intelligence
- Searching for the Source -- The Source of Business Intelligence
- One-Stop Shopping -- The Unified Dimensional Model
- First Steps -- Beginning the Development of Business Intelligence
Defining Business Intelligence Structures
- Building Foundations -- Creating and Populating Data Marts
- Fill 'er up -- Using Integration Services for Populating Data Marts
Analyzing Cube Content
- Cubism -- Measures and Dimensions
- Bells and Whistles -- Special Features of OLAP Cubes
- Writing a New Script -- MDX Scripting
- Pulling It Out and Building It Up -- MDX Queries
Mining
- Panning for Gold -- Introduction to Data Mining
- Building the Mine -- Working with the Data Mining Model
- Spelunking -- Exploration Using Data Mining
Delivering
- On Report -- Delivering Business Intelligence with Reporting Services
- Let's Get Together -- Integrating OLAP with Your Applications
- Another Point of View -- Excel Pivot Tables and Pivot Charts

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Mc Graw Hill
Auteur(s)	Brian Larson
Parution	15/03/2006
Nb. de pages	776
Format	19 x 23
Couverture	Broché
Poids	1375g
Intérieur	Noir et Blanc
EAN13	9780072260908
ISBN13	978-0-07-226090-8