Knight's Microsoft Business Intelligence 24-Hour Trainer, Wrox Press
[ Pobierz całość w formacie PDF ]
Knight’s Microsoft® Business intelligence
24-hour trainer
introduction............................................................
xxv
⊲
section
i data Warehousing and Business intelligence
lesson 1
Why Business Intelligence? ................................... 3
lesson 2
Dimensional Modeling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
lesson 3
Fact Table Modeling .........................................17
⊲
section i
i sQl server integration services
lesson 4
Understanding SSIS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
lesson 5
Using the Control Flow......................................35
lesson 6
Using the Data Flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45
lesson 7
Solving Common SSIS Scenarios.............................59
lesson 8
Loading Dimensions ........................................69
lesson 9
Loading a Fact Table........................................79
lesson 10
Deploying SSIS Packages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87
⊲
section ii
i sQl server analysis services
lesson 11
Understanding SSAS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97
lesson 12
Coniguring a Data Source and Data Source View ............. 105
lesson 13
Using the Cube Wizard......................................115
lesson 14
Editing Your Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121
lesson 15
Editing Your Cube . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129
lesson 16
Adding New Dimensions and Measure Groups.................137
lesson 17
Using MDX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .147
lesson 18
Creating Calculations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155
lesson 19
Data Mining............................................... 163
lesson 20
Administering the SSAS Instance............................ 175
⊲
section iv sQl server reporting service
s
lesson 21
Understanding SSRS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189
lesson 22
Using Report Wizard....................................... 199
lesson 23
Building a Matrix Report....................................207
lesson 24
Parameterizing Your Reports................................ 215
lesson 25
Building Reports on Your Cube . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223
lesson 26
Using Maps in Your Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 229
lesson 27
Building a Dashboard ......................................239
lesson 28
Deploying and Administering SSRS..........................247
lesson 29
New Reporting Services Visualizations — Sparklines,
Data Bars, and Indicators...................................263
lesson 30
Using Report Builder.......................................273
⊲
section v container
s
lesson 31
Reporting against a Cube with Excel.........................285
lesson 32
Loading Data into a PowerPivot Workbook . . . . . . . . . . . . . . . . . . . 295
lesson 33
Creating a PowerPivot Report...............................303
lesson 34
Data Mining in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313
⊲
section
vi sharepoint
lesson 35
Understanding SharePoint for Business Intelligence ........... 331
lesson 36
Deploying and Using Reporting Services in SharePoint 2010 . . . 335
lesson 37
Building PerformancePoint Dashboards in SharePoint 2010 . . . . 343
lesson 38
Deploying and Using Excel Services.........................353
lesson 39
Deploying and Using PowerPivot in SharePoint . . . . . . . . . . . . . . . 361
lesson 40
Managing SharePoint Business Intelligence . . . . . . . . . . . . . . . . . . .371
appendiX
What’s on the DVD? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 375
indeX......................................................................
381
Knight’s Microsoft® Business intelligence
24-hour trainer
[ Pobierz całość w formacie PDF ]