Business Analytics for Microsoft Dynamics CRM

Technical specifications

Out-of-the-box analytics in days

Business Analytics for Microsoft Dynamics CRM is a packaged, web-based analytics solution that can be deployed in days, without the need for extensive ongoing IT support. It provides OLAP-style analysis, including interactive online drill-down, slice-and-dice, advanced filtering, comprehensive formatting and custom calculations on your CRM data, including your customizations.

Deployment

  • A pre-built data warehouse means that CRM data is ready for analysis within minutes of deployment.
  • More than 60 packaged analytics give you KPIs, scorecards and dashboards from day one.
  • The zero footprint web architecture installs easily and quickly on your server environment with no intrusion on your end-users’ computers.

Performance and administration

  • Scalable from one to thousands of concurrent users – proven by industry standard testing.
  • Integrates with the Windows Active Directory for authentication and offers a comprehensive authorization model that allows permissions to be assigned at any level of granularity: from a report folder to cell-level data.
  • Scalable from one to thousands of concurrent users – proven by industry standard testing.

System requirements

  • Microsoft Dynamics CRM: 3 or 4
  • Operating System: Windows 2000 Desktop/Server, Windows XP, Windows Vista, Windows 2003 Server*
  • Web Server: IIS 5, IIS 5.1, IIS 6*, IIS 7
  • Database Server: SQL Server™ 2005 SP2 (Standard or Enterprise Edition) Client: Internet Explorer 6, 7*

    *Recommended

Customizations and security with the Customization Wizard

The Customization Wizard for Microsoft Dynamics CRM is an easy-to-use wizard that reads your CRM customizations and automatically updates the OLAP cube to make customizations available for instant analysis. It is also used to replicate the CRM security model. Key features include:

  • Automatically import CRM customizations for instant analysis.
  • Smart defaults automatically detect the type of customization for you. Or you can choose to edit the advanced properties of measures, dimensions, attributes, hierarchies and relationships.
  • Customizations handled – new, modified and removed custom entities, attributes and relationships.
  • Automatic synchronization with your CRM security model.

Architecture - Multi-tenancy

MS CRM Diagram


Architecture - On-premise

MS CRM Diagram

Top of page