Preview of Microsoft's advanced analytics tools for Dynamics CRM

Preview of Microsoft's advanced analytics tools for Dynamics CRM

I heard that Microsoft developed advanced analytics tools for Dynamics CRM. How can I find out more information?

    Requires Free Membership to View

    When you register, you'll begin receiving targeted emails from my team of award-winning editorial writers on the latest customer relationship management (CRM)and call center technology issues today. Our goal is to keep you informed on the hottest issues facing this fast-changing industry.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchCRM.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchCRM.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

The goal of any analytics solution is to provide the summary information to executives and real-time statistics to line managers that enable organizations to leverage CRM data to improve business performance.

Microsoft has released a suite of powerful analysis tools as part of SQL Server 2005 -- namely, Analysis Server and an improved version of SQL Reporting Services. Microsoft is helping customers to leverage this functionality in Dynamics CRM with the Analytics Foundation solution.

The Analytics Foundation package includes a pre-defined set of analysis tools that are pre-integrated with the Dynamics CRM schema, including an OLAP cube for reporting on CRM data directly from Microsoft Excel and predictive analytics solutions for lead rating, product recommendations and market list generation. Report data can be viewed in Dynamics CRM as integrated dashboards by leveraging Microsoft SharePoint Portal Server.

While no analytics solution can truly be "plug and play" because of the varying natures of each organization's unique business needs, the foundation pack includes tools will enable you to better understand what each of Microsoft's analytical solutions can offer and will help you to evaluate how the tools can value your business.

You can download a free copy of the Dynamics CRM Analysis Foundation from Codeplex.com.

This was first published in June 2007