Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 56

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 198
PowerPivot tutorial videos
User Rating: / 3
PoorBest 
Written by Jason Thomas   

Warning: mktime() [function.mktime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 117

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 245

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 249

Warning: strftime() [function.strftime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 250
Sunday, 27 February 2011 17:35
Reposted from Jason Thomas blog with the author's permission.

Waking up early morning for a technical webinar is so not me (I really love to have my sleep in the morning!); but then I was very interested in the PowerPivot webinar which was going to be taken by Rupesh Patric (Microsoft Partner Technical Consultant and an accomplished artist) exclusively for people from my company, MindTree Ltd. As I was the only one from UK, the time was adjusted for the majority people in India which meant I had to wake up early. Ofcourse, I knew I wouldn’t regret losing my beauty sleep from the very moment the presentation started and overall, it was a good introduction to PowerPivot. To top it all, Rupesh sent a goodie pack containing some video tutorials for PowerPivot and I thought it would be too selfish of me if I didn’t share it with you guys.

powerpivot-logo

Materials

  1. Deck : SQL Server 2008 R2 Overview
  2. Book : Introducing SQL Server 2008 R2
  3. Hands On Lab - PowerPivot in SQL Server 2008 R2.zip

Set 1

  1. Presentation What's New in the Excel 2010 Client
  2. Demo What's New in the Excel 2010 Client
  3. Presentation Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
  4. Demo Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
  5. Presentation Creating Reports with SQL Server PowerPivot for Excel 2010
  6. Demo Creating Reports with SQL Server PowerPivot for Excel 2010
  7. Presentation Defining DAX Calculations with PowerPivot for Excel 2010
  8. Demo Defining DAX Calculations with SQL Server PowerPivot for Excel 2010

Set 2

  1. Part 0 Installing the PowerPivot Add-In for Excel
  2. Part 1 Using the PowerPivot Add-in to Import Data into Excel 2010
  3. Part 2 Import data from a SQL Server Database
  4. Part 3 Import Data from an Access Database
  5. Part 4 Using Copy-Paste to Import Excel data
  6. Part 5 Using a Linked Excel table to Import data
  7. Part 6 Compressed data in PowerPivot for Excel
  8. Part 7 Handling big data in PowerPivot for Excel
  9. Part 8 Importing SAP data in PowerPivot for Excel

10.  Part 9 Reports as data sources in PowerPivot for Excel

11.  Relationships - 1 Overview

12.  Relationships - 2 Creating Relationships

If you are interested in Business Intelligence video tutorials, I would recommend you to visit Microsoft’s Channel 9, plenty more of the good stuff there.

Update (18/03/2011)

Another great Microsoft Technet resource – PowerPivot for Excel (Business Intelligence) was brought to my notice by Michele Hart (Microsoft). This site serves as a one-stop place for your PowerPivot requirements, be it articles, whitepapers, blogs, samples, videos or information about PowerPivot books. But the best part is the Virtual Lab where you can actually work and get your hands dirty on a system. Check it out!


jason-thomas

Jason has been working with Microsoft BI tools since he joined the IT industry in 2006. Since then he has worked across SSAS, SSRS and SSIS for a large number of clients like Unilever, Imperial Tobacco, IATA, Schneider Electric, etc. He is currently working at MindTree Ltd, Bangalore (www.mindtree.com) and his personal blog site can be found at http://road-blogs.blogspot.com His blogs can also be found at the popular technical site BeyondRelational.com at http://beyondrelational.com/blogs/jason


 


Read Full Article
  Tags: video, excel, introduction

Author articles


Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 198
  1. Ranking within Slicer Selection in Power Pivot
  2. Split a Delimited Row into Multiple Rows using DAX Queries
  3. UNION Operation in DAX Queries
  4. Row Selection Using Slicers in PowerPivot - Part 1
  5. Group Multiple Rows to Single Delimited Row in PowerPivot
All articles by Jason Thomas

Most Popular


Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 198
 

Warning: strftime() [function.strftime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /home/power169/public_html/libraries/joomla/utilities/date.php on line 250

Pyramid+PowerPivot