Creating a Stock Ticker View for Performance Data in PowerPivot

My previous blog post “Analyzing Performance Data in PowerPivot” explained how to create a basic PowerPivot solution to display performance counters for individual servers or server roles in a PivotChart. Subsequently, Jesse Harris, Premier Field Engineer for Microsoft System Center Operations Manager, suggested expanding this solution by providing a view similar to a stock ticker… Read more

Released: Service Pack 1 for Microsoft SharePoint Server 2010

 Today is a great day for us PowerPivoteers because Service Pack 1 for Microsoft SharePoint Server 2010 has been released. You can download it from our new and fantastic Microsoft.com Download Center at http://www.microsoft.com/download/en/details.aspx?id=26623. Why is this SharePoint Service Pack so important for PowerPivot? Among other things, it lowers the number of query requests Excel… Read more

Analyzing Performance Data in PowerPivot

PowerPivot is an absolutely fantastic performance analysis tool. You might say that I’m biased, but wait until you see firsthand how easy it is to analyze large amounts of performance data from any number of computers. For example, I recently had to analyze resource utilization in a SharePoint farm with 16 front-end servers, 8 Excel… Read more