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.
383
Index
A
Actions tab (Cube Editor), 133
ad hoc analysis, Excel, 285
ADO.NET source, 46
AdventureWorks
cube, 102
sample cube, deploying, 103–104
shared data sources, 191
AdventureWorks2008R2 sample
databases, 12
AggregateFunction property, 131
aggregation design, partitions, 183–185
Aggregation Design Wizard, 178
aggregations, 178–180
Aggregations tab (Cube Editor), 133
algorithms
Association Rules Algorithm, 163
built-in, 165
Clustering, 163
Decision Tree, 163
mining structures, 165
Time Series, 163
time series analysis, 171–174
alternate key, 70, 79
AMO (Analysis Management Object), 98
Analysis Services, 5
accounts, 106
authentication, 286
connecting to instance, 318
new connections, 345
cubes
Excel, 289–293
reporting, 223
data sources
creating, 105
datasets from, 223
Excel Services and, 353
fact tables and, 17
impersonation information, 106
KPIs, 347–352
TCP/IP and, 97–98
Unattended Service Account, 345–346
Associated Measure Group, 156
Association Rules Algorithm, 163
attribute relationships in SSAS dimensions, 99,
123–124, 127–128
data duplications, 125
Dimension Editor, 124
attributes
changing, 69
dimension columns, 97
fixed, 69
Granularity attribute, 142
types, 125–126
authentication, 106, 286
automated reports, 4
averaging data, 131, 161–162
B
BI add-on from vendor, 4
BI (Business Intelligence)
challenges, 3
integration, 5
as investment, 5
MOSS and, 331
project failure rate, 332
SharePoint, 371
users, 6
889633bindex.indd 383 8/17/10 ...
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.