DataBound Episode 1 - Developing Custom PowerPivot Apps
- Posted: Jun 02, 2011 at 8:07 AM
- 3,267 Views
- 11 Comments
Download
How do I download the videos?
- To download, right click the file type you would like and pick “Save target as…” or “Save link as…”
Why should I download videos from Channel9?
- It's an easy way to save the videos you like locally.
- You can save the videos in order to watch them offline.
- If all you want is to hear the audio, you can download the MP3!
Which version should I choose?
- If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
- If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
- If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
- If you just want to hear the audio of the video, choose the MP3 file.
Right click “Save as…”
- High Quality WMV (PC, Xbox, MCE)
- MP3 (Audio only)
- Mid Quality WMV (Lo-band, Mobile)
- High Quality MP4 (iPad, PC)
- MP4 (iPod, Zune HD)
Join Roger as he covers database and BI development on the SQL Server Information Platform. You can follow and interact with the show @SQLServer.
In the DataBound premier, Roger is joined by Aaron and Chris from Extended Results to discuss a custom PowerPivot application they developed for Microsoft called Calendar Analytics. This free Excel 2010 / PowerPivot app can be used to do some very useful analysis on your Microsoft Exchange calendar information whether it's hosted on-premise or in Office 365. This app is getting a lot of buzz and is a great example of how to deliver useful analytics to the average working professional with familiar tools they use every day.
If you want to learn more about PowerPivot, check out the SQL Server 2008 R2 Business Intelligence Training Course on MSDN. In particular, check out the last unit named Introduction to Self-Service Reporting and Analysis with SQL Server 2008 R2.
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.
Follow the Discussion
What a great feature! Make sure to download the application @ tinyurl.com/calendaranalytics and continue to follow our BI and Data TV-Shows on www.bizintelligence.tv !
Best
Bruno
@brunoaziza
Oh and one editorial comment, the tounge-in-cheek term "Mind Destroying Expressions" was not of my invention. I first heard it from Peter Myers, who heard someone else use it. Will the real creator of "Mind Destroying Expressions" please stand up!
Why doesn't this show appear in the C9 podcast feed? I would have missed it had I not stumbled in here from someone else's link!
Please add to the podcast feed. Thanks.
Hi, Cool feature.
But I got error when try to download my calender. Something about missing date. EWS should be enable. What is wrong?
@Jonas Claudelin
Could you please provide us with some more details? What is the exact message?
Thanks!
Episode 2 anyone?
cool feature.
I have been looking for some resources for me to learn how to programmatically import data to powerpivot and create a powerpivot worksheet. I have not found one. The video gives me important starting information. But I still have questions like below and hope I can get answer from you:
Does the final release of SQL Denali provide capability or APIs for developer to programmatically import data to powerpivot and create a powerpivot worksheet?
Thank you
where can I download teh source code for the app?
Thank you.
@rollo:Coming soon, have a very cool app to show built around statistical semantic search in SQL Server Denali...
@Hua Yang:This is a commercial app so I don't think they are sharing their source code.
@Hua Yang:Still no PowerPivot API's in Denali unfortunately.
Remove this comment
Remove this thread
close