利用Pro SQL Server 2008 Analysis Services驱动商业智能与数据分析

需积分: 12 36 浏览量更新于2024-07-23 收藏 14.46MB PDF 举报

"Pro SQL Server 2008 Analysis Services是一本专为开发人员和数据库管理员设计的专业书籍，它深入讲解了SQL Server 2008中内置的商务智能功能，特别是用于数据分析和挖掘的在线分析处理（OLAP）技术。本书旨在帮助读者理解OLAP的重要性和实践应用，让业务用户能够更方便地访问和分析数据，而无需每次都依赖IT部门。作者Philo Janus和Guy Fouché以易于理解的方式，带领读者进行一次技术探索之旅，通过创建数据源视图、维度和度量，以及构建立方体，展示如何从大量数据中提取商业价值。书中详细讲解了多维表达式（MDX）的基础知识，这是一种高级分析查询语言，有助于发现隐藏的答案和洞察。除了立方体的核心功能，本书还涵盖了数据挖掘的概念，如关键绩效指标（KPIs）、视角和计算成员，这些都能提升数据分析的深度和广度。此外，书中介绍了如何通过报告服务、Excel和ProClarity等不同方式消费分析服务数据，使得数据更加易于消费和利用。对于开发者来说，这是一本实用的指南，可以帮助他们利用SQL Server的强大功能推动业务决策；而对于数据库管理员，这本书同样提供了对分析服务解决方案支持的全面指导。全书结构严谨，包括了引言、OLAP基础、立方体、维度和度量、SQL Server Analysis Services的开发者和管理员界面、数据源视图创建、维度建模、立方体构建等核心章节，以及部署、处理、管理、用户界面等多个方面。 Pro SQL Server 2008 Analysis Services是一本综合性的资源，旨在提升企业的数据驱动决策能力，使企业在激烈的市场竞争中保持竞争优势。无论你是希望深入学习数据分析还是寻求技术解决方案的实践者，这本书都是不可或缺的参考资料。"

xiv

About the Authors

 Philo Janus is a senior technology specialist with Microsoft. Over the years he has presented

Microsoft Office InfoPath to thousands of users and developers, and assisted with enterprise

implementations of InfoPath solutions. With that background, he is particularly sensitive to the

difficulties users and developers have had with InfoPath.

He graduated from the US Naval Academy with a bachelor of science in electrical engineering in

1989 to face a challenging career in the US Navy. After driving an aircraft carrier around the Pacific

Ocean and a guided-missile frigate through both the Suez and Panama Canals, and serving in the US

Embassy in Cairo, a small altercation between his bicycle and an auto indicated a change of career

(some would say that landing on his head in that accident would explain many things).

Philo’s software development career started with building a training and budgeting application in

Access 2.0 in 1995. Since then he’s worked with Oracle, Visual Basic, SQL Server, and .NET, building

applications for federal agencies, commercial firms, and conglomerates. In 2003 he joined Microsoft as a

technology specialist, evangelizing Office as a development platform.

 Guy Fouché is a business intelligence and decision support system

consultant in the Dallas, Texas area. Guy spends his evenings playing

one of his eight trumpets and expanding his composition skills by

using the current generation of music technologies. On the weekend,

he puts as many miles as he can on his bright yellow Honda F4i sport

motorcycle. Guy and his wife Jodi enjoy taking nine-day trips in their

Jeep 4×4, taking photographs and writing travelogs along the way.

You can view their photography at http://photography.fouche.ws.

xvii

Introduction

Pro SQL Server 2008 Analysis Services offers an in-depth look into the latest and greatest suite of analytic

tools from Microsoft. This book will help you create business intelligence (BI) solutions that improve

your company’s analysis and decision making by focusing on practical, solution-oriented application of

the technologies available in SQL Server 2008 Analysis Services (SSAS).

Using the examples and exercises in this book, you will further your understanding of online

analytical processing (OLAP), BI, data mining, and SSAS itself. New SSAS features are also explained,

including the Management Data Warehouse (MDW), dynamic management views (DMVs), and

Aggregation Designer. Improvements to the Cube and Dimension Designers are also covered.

Chapters 1 and 2 introduce you to OLAP, and to the key concepts that are termed cubes, dimensions,

and measures. With that foundation laid, Chapters 3 and 4 introduce you to what SQL Server provides.

You’ll get your first look at Analysis Services and its administration interface. Chapters 5 through 7 show

you how to design and build a cube for analysis. The cube is the focal point of Analysis Services. Once

you’ve created a cube, Chapter 8 shows how to deploy it for use.

After you’ve deployed a cube, it is available for you and other analyists to query. It is partly through

queries that one examines and analyzes the data at one’s disposal. To that end, Chapter 9 is devoted to

Multidimensional Expressions (MDX), which is the query language underpinning Analysis Services

solutions.

Key performance indicators (KPIs) are at the heart of every BI solution. In Chapter 10, you will learn

how to define, create, and use these metrics. Chapter 10 also introduces you to perspectives, actions,

and calculated members.

Data-mining algorithms enable you to sift through huge amounts of historical data, and create

predictions based on trends and patterns. Working through Chapter 11, you will learn how to use data

mining to create, execute, and validate a prediction model. Chapter 11 will also introduce you to

Microsoft’s Data Mining Extensions (DMX) language.

PowerPivot is an exciting set of technologies that provide powerful BI abilities to all business users.

By integrating with Office 2010, your users can perform complex analysis and data mining on their

workstations. Using SSAS language translation and automated currency conversions greatly enhances

the usability of your company’s data across the enterprise.

Finally, Chapter 13 offers important information for SSAS administrators. To effectively manage

SSAS at the server level, you need to understand processing tasks and options, the SQL Server Profiler,

the Performance Monitor, scheduling, and security.

剩余480页未读，继续阅读

yanlei521

粉丝: 0
资源: 1

利用Pro SQL Server 2008 Analysis Services驱动商业智能与数据分析

pro_sql_server_2008_analysis_services

Microsoft.SQL.Server.2008.Reporting.Services.Dec.2008

Wiley.Professional.SQL.Server.2008.Integration.Services.pdf

Pro SQL Server 2008 Analysis Services

Pro SQL Server 2008 Reporting Services.pdf

Pro SQL Server 2008 Analysis Service

Pro SQL Server 2008 Reporting Services 数据库

Pro SQL Server 2012 BI Solutions.pdf

SQLServer2012ReportingServices

Pro SQL Server 2012 BI Solutions

最新资源