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.
31
Reporting against
a Cube with Excel
This lesson focuses on getting you ready to start using Excel to perform and deliver ad hoc
analysis with data and features from your Analysis Services cubes. Excel is the most widely
used client for business intelligence and ad hoc analysis because of its powerful features, rich
formatting, and native integration with SQL Server and Analysis Services. In this lesson we
will walk through accessing your data and performing common types of analysis.
We will be working with the Data tab in the Office ribbon menu at the top of your screen in
Excel. Take a few minutes and get familiar with this tab: even if you don’t know what the but-
tons do, just read through the captions to get an idea of the kinds of things you will be doing
from here. You can connect to and retrieve data from data sources, sort and filter, implement
grouping, and even perform some “what if” analysis using your cube data.
It’s time to browse this AdventureWorks2008 cube together and see what you can do with it.
You start with an empty worksheet and connect to your cube as shown in Figures 31-1, 31-2,
31-3, and 31-4.
FIGURE 311
889633c31.indd 285 8/16/10 9:12:08 PM
286
LESSON 31 RepoRting against a Cube with exCel
When you connect to a cube using Excel, you are making an ODBC conne ...
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.