September 2010
Beginner to intermediate
424 pages
12h 17m
English
book
Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis
Content preview from Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
xx
CONTENTS
Processing the Cube 181
Deploying Change 181
Try It 182
Lesson Requirements 183
Hints 183
Step-by-Step 183
sQl server seCtion iv: reporting serviCes
unDerstanDing ssrs 18lesson 21: 9
Building Your First Report 190
Putting Items on the Report 193
Previewing and Formatting the Report 193
Try It 195
Lesson Requirements 195
Hints 195
Step-by-Step 196
using report WizarD 19lesson 22: 9
Try It 202
Lesson Requirements 203
Hints 203
Step-by-Step 203
BuilDing a matriX report 20lesson 23: 7
Try It 211
Lesson Requirements 211
Hints 211
Step-by-Step 211
parameterizing your reports 21lesson 24: 5
Creating Parameters 215
Default Parameter Values 216
Parameter Available Values 217
Multi-Value Parameters 218
Altering Properties with Parameters 219
Try It 220
Lesson Requirements 220
Hints 220
Step-by-Step 221
889633ftoc.indd 20 8/16/10 9:11:04 PM
xxi
CONTENTS
BuilDing reports on your CuBe 22lesson 25: 3
Try It 226
Lesson Requirements 226
Hints 226
Step-by-Step 227
using maps in your report 22lesson 26: 9
Try It 236
Lesson Requirements 237
Hints 237
Step-by-Step 237
BuilDing a DashBoarD 23lesson 27: 9
Tables and Filters 239
Drill-Downs 242
Try It 243
Lesson Requirements 243
Hints 243
Step-by-Step 244
Deploying anD aDministering ssrs 24lesson 28: 7
Stored Credentials 250
Subscription ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.