Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Activity Profile

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Presentation: Self-Service Analysis Fundamentals with SQL Server 2008 R2

Posted: Apr 20, 2011 at 10:29 AM
By: Roger Doherty
Avg Rating: 0
2,660 Views
2 Comments
reddit

Tweet

14 minutes, 48 seconds

format
< > embed
+ queue

Sign In first to access your queue.
Close

Sorry, video was not added to the queue, an error occurred. Please Contact Us and let us know.
Close

Embed code for this video

Copy the code above to embed our video on your website/blog.

Video format

Option selected may change based on video formats available and browser capability.

Auto
Use our suggested format for this video.
Smooth Streaming
Adaptive bitrate streaming - little buffering but lower video quality at times of low bandwidth. Silverlight 5 required
Progressive
Traditional buffered video format. Silverlight 5 required
HTML5
For browsers that support H.264 MP4 or WebM video playback such as:
IE9+, Firefox 4+, Chrome 5+, or Safari 4+.
Flash
For browsers that have the Adobe Flash Player plugin installed.

Download

Right click “Save as…”

High Quality WMV (PC, Xbox, MCE)

File size
15.6 MB
MP3 (Audio only)

File size
6.8 MB
Mid Quality WMV (Lo-band, Mobile)

File size
26.7 MB
High Quality MP4 (iPad, PC)

File size
27.7 MB
MP4 (iPod, Zune HD)

File size
12.2 MB

This presentation introduces the concept of self-service analysis and the business scenarios it addresses, and discussions how SQL Server 2008 R2 can be used to meet these requirements. An architectural overview of SQL Server 2008 R2 self-service analysis components is also provided including SQL Server 2008 R2 PowerPivot for Excel and SQL Server 2008 R2 PowerPivot Server for SharePoint 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

Follow the Discussion

Follow
Oops, something didn't work.

Try again?

Sign In to be begin to follow these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.

Getting "follow" information

Stop following these comments

Start following these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.

Removing your "follow"

Setting up your "follow"

Did you know you can
sign up for email notifications?
- Subscribe to this comments

Hua Yang

Apr 20, 2011 at 11:42 AM

Hi,
Thanks for the post.

I have a question: where can I find reference on how to programmatically link PowerPivot to teh data in a worksheet?

Thanks again.
Hua
rdoherty Roger Doherty

Apr 25, 2011 at 7:44 AM

@Hua Yang: Hi Hua, thanks for the first non-spam comment I'VE EVER HAD! I'm assuming you mean "How do I include table data from an Excel worksheet in my PowerPivot Model?" This is really easy to do. Just define a table in the same Excel workbook that contains your PowerPivot model. Name it something useful, then select the table and switch to the PowerPivot tab. On the ribbon you will see a section in the ribbon entitled "Excel Data". Locate the button labeled "Create Linked Table" and click it. Presto! Your Excel table is now included in your PowerPivot model. If you add or change data in the Excel table and need to refresh your PowerPivot model, click "Update All" in the same ribbon section or update just that table from the model.

Remove this comment

Remove this thread

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.