http://blogs.technet.com/b/andrew/archive/2009/12/10/powerpivot-101-an-introduction.aspxIf you showed a business analyst or finance guy how to manipulate a whole year’s worth of data in Excel they’ll probably buy you lunch.&#160; PowerPivot for Excel does just that, but before you cash in, you need to be aware of how it works its magic anden-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/andrew/archive/2009/12/10/powerpivot-101-an-introduction.aspx#3424211Tue, 26 Apr 2011 08:21:41 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3424211Andrew.Fryer<p>Bharath the screen grabs in this post are form a pre-release veriosn of PowerPivot. &nbsp;In the production dasshboard today you&#39;ll see a funky solverligth control that show powerpivot usage over time. But not the gauges. &nbsp;If you want to create those you could put a separate report in sourced form the data on the dashboard, based on the connections used in the excel reports that are already there.</p> <p>Andrew</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3424211" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2009/12/10/powerpivot-101-an-introduction.aspx#3423506Thu, 21 Apr 2011 20:48:02 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3423506Bharath<p>How did you create CPU/Memory guages?</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3423506" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2009/12/10/powerpivot-101-an-introduction.aspx#3300581Tue, 15 Dec 2009 04:35:39 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3300581Rob Collie<p>For additional, in-depth content on PowerPivot, includihng videos, tutorials, and case studies, check out <a rel="nofollow" target="_new" href="http://powerpivotpro.com">http://powerpivotpro.com</a></p> <p>-Rob (member of the PowerPivot team at MS)</p><div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3300581" width="1" height="1">