请选择 进入手机版 | 继续访问电脑版

科研迷论坛

 找回密码
 立即注册
搜索
查看: 2|回复: 0

Pro SQL Server 2008 Analysis Services (Expert's Voice in SQL Server)-[1]-[2010]-[pdf]-[Philo Janus, Guy Fouche]

[复制链接]

0

主题

1

帖子

1

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1
发表于 2020-2-10 22:19:35 | 显示全部楼层 |阅读模式
★★★如何下载★★★1、VIP学者回复帖子后可以看到下载链接,免费下载!点击这里成为VIP学者!
2、普通用户回复帖子后可以看到下载链接,回复将花费5学币点击这里获取学币!


免费下载30页预览文件

书籍信息:
书名: Pro SQL Server 2008 Analysis Services (Expert's Voice in SQL Server)
语言: English
格式: pdf
大小: 14.5M
页数: 481
年份: 2010
作者: Philo Janus, Guy Fouche
版次: 1
出版社: Apress

简介

Pro SQL Server 2008 Analysis Services is Apress’ cornerstone offering to the SQL Server Business Intelligence Market. Our recent experience at the Professional Association of SQL Server (PASS) conference points to a strong and growing interest in Analysis Services and related technologies. This book by Microsoft technology specialist Philo Janus shows readers how to exploit the full power of Analysis Services and is well-poised to ride the wave of that growing interest.


目录
Prelim......Page 1
Contents at a Glance......Page 6
Contents......Page 7
About the Authors......Page 16
About the Technical Reviewers......Page 17
Acknowledgments......Page 18
Introduction......Page 19
Introduction to OLAP......Page 21
From Pivot Tables to Dimensional Processing......Page 22
Data Warehousing......Page 24
Applications of OLAP......Page 25
History of OLAP......Page 27
SQL Server Analysis Services......Page 28
Data Mining......Page 33
Summary......Page 34
Cubes and Their Components......Page 35
Schemas......Page 38
Dimensions in Depth......Page 40
Slowly Changing Dimensions (SCD)......Page 41
Hierarchies......Page 43
Time Dimensions......Page 46
Measures......Page 47
Types of Aggregation......Page 51
Writeback......Page 52
Calculated Measures......Page 53
Actions......Page 54
XMLA......Page 55
Multidimensional Expressions (MDX)......Page 56
Data Warehouses......Page 57
Storage Modes......Page 58
Summary......Page 59
Hardware......Page 61
Virtualization......Page 63
Upgrading......Page 64
Standard or Enterprise Edition?......Page 65
The Unified Dimensional Model......Page 66
Logical Architecture......Page 69
Physical Architecture......Page 72
Storage......Page 74
Cube Structures in SSAS......Page 79
Data Source View......Page 81
The Cube Structure Itself......Page 83
Dimensions......Page 84
Management Data Warehouse......Page 85
Reliable Query Cancel......Page 87
Change Data Capture......Page 88
Dimension Design......Page 89
Aggregation / UBO Designer......Page 91
AMO Design Warnings......Page 92
Summary......Page 93
BIDS Is Visual Studio?......Page 95
Panes......Page 96
Solution Explorer......Page 99
Properties Pane......Page 100
Create a New Analysis Services Project......Page 102
Open an Existing SSAS Database......Page 104
Open an Existing SSAS Database as Part of a Project......Page 105
SQL Server Management Studio......Page 106
Data Sources......Page 107
Data Source Views......Page 108
Cubes......Page 109
Roles......Page 110
Executing MDX Queries......Page 111
PowerShell......Page 112
PowerShell for SQL Server......Page 113
PowerShell with SSAS......Page 114
Summary......Page 115
Cubes Need Data......Page 117
Data Sources......Page 118
Designer Tour......Page 125
Replacing a Table......Page 126
Named Calculations......Page 130
Named Queries......Page 132
Summary......Page 136
Dimensional Analysis......Page 137
Review of the Dimension Concept......Page 138
Star or Snowflake?......Page 139
The Advantage of Simplicity......Page 140
Creating a Dimension......Page 147
Analysis Management Objects (AMO) Warnings......Page 155
Dimension Properties......Page 156
Dimension Type......Page 157
Processing......Page 160
Storage......Page 161
Attributes......Page 168
Attribute Relationships......Page 170
Attribute Properties......Page 176
Parent-Child Dimensions......Page 177
The Time Dimension......Page 179
Summary......Page 186
Building a Cube......Page 187
Dimensions and Cubes......Page 189
Using Measure Group Tables......Page 190
Selecting Dimensions......Page 193
Defining Dimension Usage......Page 199
Measures......Page 202
Measure Groups......Page 204
Calculated Measures......Page 205
Summary......Page 213
Project Properties......Page 215
Using the Deployment Wizard......Page 218
Running the Wizard......Page 219
Input Files......Page 221
Synchronizing SSAS Databases......Page 222
Processing......Page 224
What Processing Does for Us......Page 225
How to Initiate Processing from BIDS......Page 228
Processing from SQL Server Management Studio......Page 234
Scheduling OLAP Maintenance......Page 235
Summary......Page 238
Why the Need?......Page 239
Tuples and Sets......Page 241
Notation......Page 242
Tuples......Page 243
MDX Queries......Page 248
SELECT......Page 249
WHERE......Page 252
MDX Functions......Page 253
Tree Functions......Page 259
Aggregate Functions......Page 261
Time Functions......Page 265
Summary......Page 269
Business Intelligence......Page 271
Time Intelligence......Page 272
Account Intelligence......Page 274
Unary Operators......Page 275
Custom Member Formulas......Page 276
Currency Conversion......Page 277
Calculations Tab......Page 278
Calculated Measures......Page 279
Other Cube Features......Page 282
Key Performance Indicators......Page 283
Actions......Page 285
Perspectives......Page 290
Translations......Page 292
Summary......Page 293
Why Mine Data?......Page 295
Microsoft Clustering......Page 296
Creating the Accessory Buyers Marketing Campaign......Page 297
Creating the Accessory Buyers Views in AdventureWorks......Page 298
Creating the Accessory Campaign Data Source View......Page 301
Finding Accessory Buyers by Using the AdventureWorks EDW......Page 302
Using the Data Mining Model Designer......Page 309
The Mining Structure View......Page 310
The Mining Models View......Page 311
Exploring the Decision Tree......Page 312
Using Drill-Through to View a Model’s Training Cases......Page 315
Using the Dependency Network......Page 316
The Mining Accuracy Chart View......Page 317
The Mining Model Prediction View......Page 319
Use the DMX Development Environment......Page 323
Create the Accessory Buyers Mining Structure......Page 324
Process the Accessory Buyers Campaign......Page 325
View the Accessory Buyers Mining Model......Page 326
Predict Our Accessory Buyers......Page 328
Summary......Page 330
Master Data Services......Page 331
Excel Writeback......Page 333
PowerPivot from Excel......Page 340
PowerPivot with SharePoint Server 2010......Page 346
Summary......Page 351
Processing a Cube......Page 353
Processing Options......Page 355
Processing Architecture......Page 356
Performance Monitor......Page 357
Automation......Page 359
Analysis Management Objects......Page 360
Scheduling......Page 363
SQL Server Agent......Page 364
SQL Server Integration Services......Page 365
Authentication......Page 368
Authorization......Page 369
Design......Page 372
Attribute Design......Page 373
Partitions......Page 376
Understanding Aggregations......Page 379
Creating an Aggregation......Page 380
Preparing an Aggregation for Use......Page 385
Large Number of Users......Page 387
SharePoint Server 2010......Page 389
Summary......Page 391
Excel 2007......Page 393
Data Source Connections......Page 394
Pivot Tables......Page 399
Pivot Table Task Pane......Page 400
Pivot Table Ribbons......Page 401
Formatting a Pivot Table......Page 403
Formulas Using Pivot Table Values......Page 405
Pivot Charts......Page 406
Visio 2007......Page 419
Reports......Page 421
Tablix......Page 422
Charts......Page 430
Report Builder 2.0......Page 438
MOSS 2007......Page 440
KPI Lists......Page 441
PerformancePoint......Page 443
Summary......Page 449
Setting Up Adventure Works......Page 451
Web Sites......Page 455
A......Page 457
B......Page 459
C......Page 460
D......Page 462
E......Page 466
F......Page 467
J......Page 468
L......Page 469
N......Page 471
O......Page 472
P......Page 473
R......Page 475
S......Page 476
U......Page 480
W Y......Page 481

电子书下载地址(Ebook download address)回复可见:
游客,如果您要查看本帖隐藏内容请回复

★★★学币不够看这里★★★1、每个同学都有一个独一无二的推广链接,请点击这里来获取
2、把你的推广链接告诉你的同学、同事、朋友,让他们注册,或者分享到你的微博,微信朋友圈、博客或者其他的论坛,让更多人的通过你的链接进来注册,那么你会获得非常可观的学币
3、每一个用户,通过你的链接来到论坛进行注册后,你都会获得10个学币!即便用户没有注册,他只要点击了你给的链接,浏览了科研迷论坛,你也能获得1个学币
4、通过分享资料,资料上传分享成功会获得5~10个学币!其他用户下载还会获得额外的学币哦!
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关闭

站长推荐上一条 /1 下一条

Archiver|手机版|小黑屋|科研迷论坛 ( 闽ICP备17033831号-3 ) hello xym!!

GMT+8, 2020-2-27 15:55 , Processed in 0.022977 second(s), 9 queries , Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表