Wednesday, December 12, 2012

Business Intelligence for CRM 2011 data- Part II - PowerView

In Part I of the two part series, I had talked a little bit about the cool things that can be done with the Excel add on called PowerPivot, with the data feed coming in from a crm 2011 organization. In Part II, we are going to dive in to Power View, which is a browser-based Silverlight application launched from SharePoint  that enables users to present and share insights through interactive presentations.

Wednesday, December 5, 2012

Business Intelligence for CRM 2011 data- Part I - PowerPivot


In a typical CRM system, there might be huge quantities of data (like case items) that we would want to gain insight into. In the first part of a two part series, I will focus on using PowerPivot to connect to a CRM system, extract data, and present the data in powerful new ways using Excel.

PowerPivot is a powerful data mashup and data exploration tool based on xVelocity in-memory technologies providing unmatched analytical performance. The goal of PowerPivot is to empower users of all levels with new insights through familiar tools, which in this case is Excel.