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 12, 2012
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.
Labels:
BI,
Charts,
Data,
Dynamics CRM 2011,
Installation,
Reports,
Sharepoint 2010,
User Experience
Subscribe to:
Posts (Atom)