CRM Accelerators – Part I – Analytics Accelerator


Last week we introduced the CRM Accelerators program for Microsoft Dynamics CRM customers and partners, each week we will unveil more details of each accelerator. In this article we feature the Analytics Accelerator.
Analytics Accelerator – Due to be released in Q3 2008

Many customers and partners will be familiar with Analytics Foundation for Microsoft Dynamics CRM 3.0 which was a business intelligence feature pack for Microsoft Dynamics CRM 3.0. Analytics Foundation for Dynamics CRM 3.0 included Dashboards, Key Performance Indicators (KPI’s) and a suite of new reports. Analytics Accelerator for Microsoft Dynamics CRM 4.0 expands on this, and is designed to support a range of business intelligence “maturity” levels for customers and partners. The Analytics accelerator has been built to cater for differing business intelligence skill-sets and experience levels. Elements of the accelerator include:

  • Sales, service and operations dashboards delivered with Microsoft SQL Server® Reporting Services (SSRS).
  • Sales, service and operations dashboards and scorecards delivered with Microsoft PerformancePoint® Server.
  • Additional reports delivered with SSRS.
  • Two Online Analytical Processing (OLAP) cubes which are designed to allow customers to conduct in-depth analysis and key performance indicator (KPI) monitoring based on Microsoft Dynamics CRM 4.0 data. Customers can consume these cubes through Microsoft Excel®, Microsoft SharePoint® technologies and Microsoft PerformancePoint Server. The first OLAP cube is designed for simple setup and consumption, the second cube is more detailed and requires a more advanced knowledge of analytics and OLAP technologies within Microsoft SQL Server.
  • Predictive analytics to provide statistical guidance in areas such as lead and sales opportunity management. There are several sample applications which ship as part of the accelerator that showcase how customers can leverage predictive analytics directly within the Microsoft Dynamics CRM 4.0 user interface.
  • The analytics accelerator will work with SQL Server 2005 with some components enhanced to take advantage of SQL Server 2008.

The Analytics accelerator will be free of charge for Microsoft Dynamics CRM 4.0 customers and partners.

The following images are taken from the beta version of the Analytics Accelerator (NB: these may change between now and the release of Analytics Accelerator)

clip_image002

Beta version of the Analytics Accelerator landing page in Microsoft Dynamics CRM 4.0

clip_image004

Beta sample sales dashboard for Microsoft Dynamics CRM 4.0

Kind regards,

Reuben Krippner

Comments (26)

  1. CBM on CRM says:

    hey, I have been at Redmond for the past 4 weeks, attending training and so forth and after this at TechReady.

  2. In arrivo Analytics Accelerator for Microsoft Dynamics CRM 4.0

  3. ASPInsiders says:

    One of the more popular questions I get asked is when will the Analytics be released for CRM 4 – Yesterday

  4. Last week we introduced the Analytics Accelerator which is part of the CRM Accelerators for Microsoft

  5. vanatta_tl says:

    Can you provide any white paper or other documentation related to this accelerator?

    I need more info. 🙂

  6. DM - 3 Peaks says:

    Could you please update the screen shots in your article with ones that are legible.  I would like to give these to a customer, but they are too hard to read.  Thx.

  7. The Microsoft Dynamics CRM Team is pleased to announce the upcoming availability of eight no-cost add-on

  8. The Microsoft Dynamics CRM Team is pleased to announce the upcoming availability of eight no-cost add-on

  9. saml26 says:

    Where can we get some more information about these accelerators? There is not very much on the web.

  10. The Dynamics team have been busy bees lately! CRM 4.0 BizTalk Adapter Now Available The long awaited

  11. Giri says:

    When will be the cubes available to partners and MCT(s) so that we could be hand-on to the product and prepared to support the market?

  12. grahamp says:

    Q3 came and went.

    When are the Accelerators being released!

    Graham

  13. Gilles Boyer says:

    Does the cube support the CRM security features (access roles)?

  14. The Microsoft Dynamics CRM Team is pleased to announce the upcoming availability of eight no-cost add

  15. This past month, Reuben Krippner and I sat down to chat about the exciting Microsoft Dynamics CRM 4.0

  16. This past month, Reuben Krippner and I sat down to chat about the exciting Microsoft Dynamics CRM 4.0

  17. This past month, Reuben Krippner and I sat down to chat about the exciting Microsoft Dynamics CRM 4.0

  18. Johnny Sovereign says:

    Analytics Accelerator R1 for CRM 4.0- On 2-4-09 I downloaded & ran through the deployment guide titled "Dashboard Reports Deployment Guide". All the report files load and appear in CRM, however when I go to run any of the reports I receive the following generic error "An internal error occurred on the report server. See the error log for more details." The only report that works is the Account Executive Dashboard for a 1 particular user and only when ‘Stage’ is selected vs. month? I know my SQL 2005 Reporting Services is setup correctly because it works for all my other report in CRM. I don’t have very much data in this DB as far as opportunities & cases, but I would hope the report would still run even if it was on a clean CRM 4 DB.

    This deployment guide it doesn’t make clear if you need to install the Cube as well when you only want the base Analytics, so I have not installed that as of yet?

    Also in the deployment guide its very first section of the Contents is titled "SQL Reporting Services 2005 Dashboard Frequently Asked Questions" page 1, but then that section is missing?

    What is my next step in resolving this issue? And where are these errors logged? Thanks Johnny

  19. This past month, Reuben Krippner and I sat down to chat about the exciting Microsoft Dynamics CRM 4.0

  20. There are servel ways to build up a dashboard to integrate with Dynamics CRM. Let's take a look(projects

  21. 关于把图形报表整合到 CRM 的应用比较普遍,也是大家比较感兴趣的问题。我总结了一下自己在项目中用到的一些方法: Windows Sharepoint Service (WSS 3.0) + Office

  22. PuroClean says:

    PuroClean Home Rescue, a leader in water damage restoration, was able to optimize its marketing mix through Microsoft Dynamics CRM. We were able to reduce the efforts and costs involved in marketing to lower-end targets and increase our ROI by focusing on our most valuable contacts.

  23. Bill says:

    I’ve used the CRM system before, and most all of the business intelligence and Customer relationship management systems from Microsoft are excellent. This is no exception.  I look forward to seeing the latest update. OLAP is an advanced topic, but made much easier with this product.

  24. Mac says:

    I can’t install Analytics_R2_RTW for MS CRM 4.0

    This Errors :

    1.internal error : The operation terminated unsuccessfully.

    2.Errors in the OLAP storage engine :the process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.

    3.Error in the OLAP storage engine : An errors occured while processing the ‘Fact opportunity competitor’ partition of the ‘opportunity competitor’ Measure group for the ‘CRM AF Base’ cube from the CRM Base Database.

    4.Server : the operation has been can cancelled

  25. Saraswathy says:

    Hi,

    I’m a fresher to MS CRM 4.0 i got a task to worked with dashboard i have downloaded Analytics_R1 and installed all .rdl reports for sales manager dashboard,CRM sales usage dashboard,service dashboards,Account Exceutive Dashboard and its corresponding sub-reports..

    Reports is being generated if i click on corresponding dashboard. The problem is for Crm sales usage dashboard its produce 3 diff graphs

    1.Appointment VS week  

    2. Emails vs week

    3.Count Vs month

    i need to know from which field its getting the data to make a graph

    sales manager dashboard generate a graph n two tabulation format information

    graph is Revenue in 1000s Vs Month the same problem, need to know the data input

    on the top of the graph its shows {Won Deals in 1000s:2} what does it mean.. its also generates the same record if i select [(year: any year) Vs [(Quarter): Q1/Q2/Q3/Q4]

    Please reply as soon as possible

    i would be ThankFul if some reply to my queries

    Thanks,

    Saraswathy