Knights Microsoft Business Intelligence 24 Hour Trainer

Knight's Microsoft Business Intelligence 24-Hour Trainer......Page 1
Contents at a Glance......Page 3
Copyright......Page 8
Dedications......Page 9
About the Authors......Page 11
About the Technical Editor......Page 12
Credits......Page 13
Acknowledgments......Page 15
Contents......Page 17
How This Book Is Structured......Page 27
Instructional Videos on DVD......Page 28
Supporting Packages and Code......Page 29
p2p.wrox.com......Page 30
Section I: Data Warehousing and Business Intelligence......Page 35
Lesson 1: Why Business Intelligence?......Page 37
How Intelligent Is Your Organization?......Page 38
Try It......Page 41
Lesson 2: Dimensional Modeling......Page 43
How Does Dimensional Modeling Work?......Page 46
Try It......Page 48
Lesson 3: Fact Table Modeling......Page 51
Try It......Page 52
Section II: SQL Server Integration Services......Page 55
Business Intelligence Development Studio (BIDS)......Page 57
Solution Explorer......Page 58
SSIS Designer......Page 59
SSIS Architecture......Page 60
Try It......Page 62
Control Flow Containers......Page 69
Control Flow Tasks......Page 70
Connection Manager......Page 71
Control Flow Designer......Page 72
Try It......Page 73
Lesson 6: Using the Data Flow......Page 79
Data Flow Sources (Extracting Data)......Page 80
Data Flow Transformations......Page 82
Data Flow Designer......Page 84
Try It......Page 85
Lesson 7: Solving Common SSIS Scenarios......Page 93
Try It......Page 96
Lesson 8: Loading Dimensions......Page 103
Using the Slowly Changing Dimension Task......Page 104
Try It......Page 107
Try It......Page 113
Deploying a Single Package Using SSMS......Page 121
Creating a Deployment Utility Using BIDS......Page 122
Try It......Page 123
Section III: SQL Server Analysis Services......Page 129
SSAS Architecture......Page 131
Cubes......Page 132
MDX......Page 133
BIDS for SSAS......Page 134
Try It......Page 136
Creating a Data Source......Page 139
Creating a Data Source View......Page 140
Try It......Page 143
Lesson 13: Using the Cube Wizard......Page 149
Try It......Page 151
Dimension Editor......Page 155
Attribute Relationships......Page 157
Key Columns......Page 158
Dimension and Attribute Types......Page 159
Try It......Page 160
Cube Editor Tour......Page 163
Browsing the Cube......Page 168
Try It......Page 169
Adding a Measure Group and Measures......Page 171
Adding a Dimension......Page 173
Try It......Page 178
Anatomy of Basic MDX......Page 181
Navigation Functions......Page 185
Try It......Page 187
Calculation Basics......Page 189
Named Sets......Page 191
More Advanced Calculations......Page 192
Try It......Page 195
Introduction to Data Mining......Page 197
Data-Mining Process......Page 198
Creating a Mining Model......Page 199
Exploring the Model......Page 202
Evaluating the Model......Page 203
Querying the Model......Page 204
Try It......Page 205
Securing the Database......Page 209
Partitioning the Data......Page 211
Aggregations......Page 212
Usage-Based Optimization......Page 213
Deploying Change......Page 215
Try It......Page 216
Section IV: SQL Server Reporting Services......Page 221
Lesson 21: Understanding SSRS......Page 223
Building Your First Report......Page 224
Try It......Page 229
Lesson 22: Using Report Wizard......Page 233
Try It......Page 236
Lesson 23: Building a Matrix Report......Page 241
Try It......Page 245
Creating Parameters......Page 249
Default Parameter Values......Page 250
Parameter Available Values......Page 251
 Multi-Value Parameters......Page 252
Altering Properties with Parameters......Page 253
Try It......Page 254
Lesson 25: Building Reports on Your Cube......Page 257
Try It......Page 260
Lesson 26: Using Maps in Your Report......Page 263
Try It......Page 270
Tables and Filters......Page 273
Drill-Downs......Page 276
Try It......Page 277
Lesson 28: Deploying and Administering SSRS......Page 281
Stored Credentials......Page 284
Subscriptions......Page 285
Shared Schedules......Page 286
Security......Page 287
Datasets and Caching......Page 289
Report Builder 3.0......Page 290
Report Parts......Page 291
Viewing Reports......Page 292
Try It......Page 293
Adding Sparklines......Page 297
Using Data Bars......Page 298
Configuring Indicators......Page 299
Try It......Page 300
Opening Report Builder......Page 307
Working with the Table, Matrix, or Chart Wizard......Page 308
Report Parts......Page 310
Shared Datasets......Page 311
Try It......Page 312
Section V: Containers......Page 317
Lesson 31: Reporting against a Cube with Excel......Page 319
Try It......Page 323
What Is PowerPivot?......Page 329
Try It......Page 335
Components of a PowerPivot Report......Page 337
Building the Report......Page 338
Adding Bells and Whistles......Page 340
Try It......Page 342
Getting Ready for Excel Data Mining......Page 347
Exploring the Data Mining Add-Ins......Page 351
Analyzing Key Influencers in Excel......Page 354
Try It......Page 357
Section VI: SharePoint......Page 363
Lesson 35: Understanding SharePoint for Business Intelligence......Page 365
Try It......Page 368
Lesson 36: Deploying and Using Reporting Services in SharePoint 2010......Page 369
Try It......Page 373
Lesson 37: Building PerformancePoint Dashboards in SharePoint 2010......Page 377
Try It......Page 381
Lesson 38: Deploying and Using Excel Services......Page 387
Try It......Page 390
Lesson 39: Deploying and Using PowerPivot in SharePoint......Page 395
Try It......Page 398
Lesson 40: Managing SharePoint Business Intelligence......Page 405
Try It......Page 407
System Requirements......Page 411
Troubleshooting......Page 412
Customer Care......Page 413
Index......Page 417
Wiley Publishing, Inc. End-User License Agreement......Page 434