Make the most of your existing investment in Microsoft SQL Server 2008 or 2005 to gain knowledge and insights from Microsoft® Dynamics CRM.

• Manage the Microsoft Dynamics CRM report store using SQL Server Reporting Services.
• Reduce the need for IT-build reports with wizard-based report building tools.
• Use pre-built cubes to provide a single, consolidated business view for relational and multidimensional data warehousing through SQL Server Analysis Services.

Analytics

Gain deep insights into your business through detailed data analyses. By using Unified Dimensional Models, users can get a simpler, more readily understood view of your data.

• Analyze and report on data across your business applications, including Microsoft Dynamics CRM.
• Improve business planning by using predictive models with sophisticated pre-built data-mining algorithms.
• Give users greater clarity in reviewing business data with advanced visualizations.

 

Data Access

By providing broad access to business insights, organizations can become more proactive and successful. Users can view data and take action on business intelligence when it is provided in the context of the business application.

• Bring data from Microsoft Dynamics CRM into corporate performance management tools through PerformancePoint Services for SharePoint®.
• Distribute business intelligence from Microsoft Dynamics CRM across the enterprise through Microsoft Office SharePoint Server.

Users can derive more value from BI with in-context reporting.

 

Familiar Tools

Developers can use a broad set of familiar tools when developing customizations for, or creating integrations with Microsoft Dynamics CRM.

• Gain quick insights into CRM data and visualizations with Microsoft Office Excel.
• Give knowledgeable users of Microsoft Dynamics CRM the ability to create self-service SQL Server Reporting Services reports with the built-in wizard.
• Help employees create visually compelling reports with the drag-and-drop simplicity of the SQL Server Report Builder.
• Use Microsoft Visual Studio® as a development tool to tap the extensive business intelligence capabilities of the Microsoft SQL Server platform—including interactive reports from multiple data sources and predictive analytics.

Analytics Accelerator

Analytics Accelerator for Microsoft Dynamics CRM provides business intelligence for differing skill sets and experience levels with dashboards, scorecards, and online analytical processing (OLAP) cubes.

• Give users access to key metrics from one location with prebuilt dashboards.
• Speed time-to-development of data warehouses with prebuilt Unified Dimensional Models.
• Review the sample applications that ship with the accelerator to see how to use predictive analytics within the Microsoft Dynamics CRM user interface.