McGraw-Hill - Delivering Business Intelligence with MS SQL Server 2005 (2006).pdf - MS SQL 2005 Server - darekisap

Delivering Business Intelligence with Microsoft SQL Server 2005

byBrian Larson

McGraw-Hill/Osborne 2006 (792 pages)

ISBN:0072260904

Illustrating all of the integration, analysis, and reporting capabilities of SQL Server 2005, this unique

resource shows you, step-by-step, how to author, customize, and distribute information that will give

your company the competitive edge.

Table of Contents

Delivering Business Intelligence with Microsoft SQL Server 2005

Part I - Business Intelligence

Chapter 1 - Equipping the Organization for Effective Decision Making

Chapter 2 - Making the Most of What You've Got—Using Business Intelligence

Chapter 3 - Searching for the Source—The Source of Business Intelligence

Chapter 4 - One-Stop Shopping—The Unified Dimensional Model

Chapter 5 - First Steps—Beginning the Development of Business Intelligence

Part II - Defining Business Intelligence Structures

Chapter 6 - Building Foundations—Creating and Populating Data Marts

Chapter 7 - Fill'er Up—Using Integration Services for Populating Data Marts

Part III - Analyzing Cube Content

Chapter 8 - Cubism—Measures and Dimensions

Chapter 9 - Bells and Whistles—Special Features of OLAP Cubes

Chapter 10 - Writing a New Script—MDX Scripting

Chapter 11 - Pulling It Out and Building It Up—MDX Queries

Part IV - Mining

Chapter 12 - Panning for Gold—Introduction to Data Mining

Chapter 13 - Building the Mine—Working with the Data Mining Model

Chapter 14 - Spelunking—Exploration Using Data Mining

Part V - Delivering

Chapter 15 - On Report—Delivering Business Intelligence with Reporting Services

Chapter 16 - Let's Get Together—Integrating Olap with Your Applications

Chapter 17 - Another Point of View—Excel Pivot Tables and Pivot Charts

Index

List of Figures

List of Tables

Delivering Business Intelligence with Microsoft SQL Server 2005

byBrian Larson

McGraw-Hill/Osborne 2006 (792 pages)

ISBN:0072260904

Illustrating all of the integration, analysis, and reporting capabilities of SQL Server 2005, this unique

resource shows you, step-by-step, how to author, customize, and distribute information that will give

your company the competitive edge.

Table of Contents

Delivering Business Intelligence with Microsoft SQL Server 2005

Part I - Business Intelligence

Chapter 1 - Equipping the Organization for Effective Decision Making

Chapter 2 - Making the Most of What You've Got—Using Business Intelligence

Chapter 3 - Searching for the Source—The Source of Business Intelligence

Chapter 4 - One-Stop Shopping—The Unified Dimensional Model

Chapter 5 - First Steps—Beginning the Development of Business Intelligence

Part II - Defining Business Intelligence Structures

Chapter 6 - Building Foundations—Creating and Populating Data Marts

Chapter 7 - Fill'er Up—Using Integration Services for Populating Data Marts

Part III - Analyzing Cube Content

Chapter 8 - Cubism—Measures and Dimensions

Chapter 9 - Bells and Whistles—Special Features of OLAP Cubes

Chapter 10 - Writing a New Script—MDX Scripting

Chapter 11 - Pulling It Out and Building It Up—MDX Queries

Part IV - Mining

Chapter 12 - Panning for Gold—Introduction to Data Mining

Chapter 13 - Building the Mine—Working with the Data Mining Model

Chapter 14 - Spelunking—Exploration Using Data Mining

Part V - Delivering

Chapter 15 - On Report—Delivering Business Intelligence with Reporting Services

Chapter 16 - Let's Get Together—Integrating Olap with Your Applications

Chapter 17 - Another Point of View—Excel Pivot Tables and Pivot Charts

Index

List of Figures

List of Tables

Back Cover

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.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS

UNREGISTERED VERSION OF CHM TO PDF CONVERTER By THETA-SOFTWARE

Manage Analysis Services databases using BI Development Studio

Improve performance and decrease latency using proactive caching

Create interactive reports using SQL Server 2005 Reporting Services

Enable ad hoc reporting using Report Models and Report Builder

Integrate with applications using ADOMD.NET and the Report Viewer Control

Design and create relational data marts and OLAP cubes

Perform powerful data analysis using MDX queries and scripts

Perform complex operations with Integration Services

Uncover behavior patterns and proclivities using data mining

About the Author

Brian Larson is a Phi Beta Kappa graduate of Luther College in Decorah, Iowa, with degrees in Physics and

Computer Science. He has 20 years of experience in the computer industry and 16 years of experience as a

consultant creating custom database applications. Brian is currently the Chief of Technology for Superior

Consulting Services in Minneapolis, Minnesota, a Microsoft Consulting Partner for Reporting Services. He is a

Microsoft Certified Solution Developer (MCSD) and a Microsoft Certified Database Administrator (MCDBA).

Brian served as a member of the Reporting Services development team as a consultant to Microsoft. In that role,

he contributed to the original code base of Reporting Services.

Brian has presented seminars and provided training and mentoring on Reporting Services across the country. He

is a contributor and columnist for SQL Server magazine and is currently writing the B.I. Powers column appearing

on the SQL Server magazine website. In addition to this book, Brian is the author of Microsoft SQL Server 2005

Reporting Services, also from McGraw-Hill/Osborne.

UNREGISTERED VERSION OF CHM TO PDF CONVERTER By THETA-SOFTWARE

Understand the goals and benefits of business intelligence

Delivering Business Intelligence with Microsoft SQL

Server 2005

Brian Larson

McGraw-Hill/Osborne

New York, Chicago, San Francisco, Lisbon, London, Madrid, Mexico City, Milan, New Delhi, San Juan,

Seoul, Singapore, Sydney, Toronto

McGraw-Hill/Osborne

2100 Powell Street, 10th Floor

Emeryville, California 94608

U.S.A.

To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact

McGraw-Hill /Osborne at the above address.

of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or

stored in a database or retrieval system, without the prior written permission of publisher, with the

exception that the program listings may be entered, stored, and executed in a computer system, but they

may not be reproduced for publication.

1234567890 DOC DOC 019876

ISBN 0-07-226090-4

Acquisitions Editor

Wendy Rinaldi

Project Editor

Patty Mon

Acquisitions Coordinator

Alex McDonald

Technical Editor

Cheryl Stepney

Copy Editor

Marcia Baker

Proofreader

Paul Tyler

Indexer

Rebecca Plunkett

Composition

G&S Book Services

Illustration

G&S Book Services

Series Designer

Peter F. Hancik

Cover Series Designer

Pattie Lee

This book was composed with Adobe® InDesign® CS.

Information has been obtained by McGraw-Hill /Osborne from sources believed to be reliable. However,

because of the possibility of human or mechanical error by our sources, McGraw-Hill /Osborne, or others,

McGraw-Hill /Osborne does not guarantee the accuracy, adequacy, or completeness of any information

and is not responsible for any errors or omissions or the results obtained from the use of such information.

This book is dedicated to my parents. To my father, Robert, who, even after 40-plus years as a junior high

mathematics teacher and computer instructor, has a love of teaching. He has shown me a real

commitment to sharing knowledge with others. To my mother Beverly, who was my first editor, coaching

me through elementary school papaers on this state or that president. She taught me the value of

stricking with a job and seeing it through to the end. I owe them both a debt of love, caring and support

that can never be adequately repaid.

About the Author

Brian Larson is a Phi Beta Kappa graduate of Luther College in Decorah, Iowa, with degrees in Physics

and Computer Science. He has 20 years of experience in the computer industry and 16 years of

experience as a consultant creating custom database applications. Brian is currently the Chief of

Technology for Superior Consulting Services in Minneapolis, Minnesota, a Microsoft Consulting Partner for

Reporting Services. He is a Microsoft Certified Solution Developer (MCSD) and a Microsoft Certified

Database Administrator (MCDBA).

Brian served as a member of the Reporting Services development team as a consultant to Microsoft. In

that role, he contributed to the original code base of Reporting Services.

Brian has presented seminars and provided training and mentoring on Reporting Services across the

country. He is a contributor and columnist for SQL Server magazine and is currently writing the B.I.

Powers column appearing on the SQL Server magazine website. In addition to this book, Brian is the

author of Microsoft SQL Server 2005 Reporting Services , also from McGraw-Hill/Osborne.

Brian and his wife Pam have been married for 20 years. Pam will tell you that their first date took place at

the campus computer center. If that doesn't qualify someone to write a computer book, then 1 don't know

what does. Brian and Pam have two children, Jessica and Corey.

About the Technical Editor

Cheryl Stepney has been on the leading edge of technology for over 30 years. Working for AT&T, she

was on the team to promote UNIX into the commercial world.

Cheryl was one of the first users in the nation of both Focus and Informix. She joined Oracle Corporation

in 1985 and held various positions to bring Relational Databases to the marketplace. After the growth of

Oracle, Cheryl joined another startup firm—Macromedia—bringing multimedia and interactivity to

applications and the Internet. She was CEO of Empowerment Associates for over eight years, designing

and architecting some of the first and largest data warehouses in the world—decision support redefined.

Cheryl joined Microsoft in 2000 to evangelize SQL Server 2000 in the North Central area of the country,

growing the marketplace for Business Intelligence in her near six-year tenure.

Acknowledgments

No project of this size is the work of a single person. I need to thank a number of people for their

assistance, professionalism, dedication, and support. So, a gianormous thank you …

To Wendi Rinaldi, who allowed me to lean on her as part editor, part coach, part literary agent, and part

psychoanalyst. Her professionalism, humor, understanding, and faith truly made this project possible.

UNREGISTERED VERSION OF CHM TO PDF CONVERTER By THETA-SOFTWARE

To Alex McDonald, who kept me on track and organized through two simultaneous book projects.

To Cheryl Stepney, who encouraged exploration of Microsoft tools, imparted her wisdom on Business

Intelligence, and insured it all made sense.

To Patty Mon, who saw it through to the end and made sure there really was a book when all was said and

done.

To Marcia Baker, who would be a rich woman if she were paid a nickel for every unnecessary "that" and

"of" she removed from my text.

To John Miller, who founded Superior Consulting Services as a place where people can grow and learn,

produce solid technology solutions, serve customers, and have a good time to boot.

To Jessica and Corey, my children, who allowed me time to pursue this passion.

To my wife, Pam, who continues to be gracious in her understanding of my affliction with the writing bug.

She has given generously of her time to proof and review this book, and its Learn By Doing exercises. Her

incredible attention to detail has made this a better product.

Last, but certainly not least, to you, the reader, who plunked down your hard-earned cash for this

purchase. I hope you view this as a helpful and informative guide to all of the truly exciting Business

Intelligence features in SQL Server 2005.

All the best,

Brian Larson

blarson@teamscs.com

McGraw-Hill - Delivering Business Intelligence with MS SQL Server 2005 (2006).pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: