Thursday, April 26, 2007

Fuel the People Engine with Analysis

CRM Magazine recently published a great article written by Jim Dickie titled Fueling the CRM Engine. The sub-title, Sales reps are spinning their wheels waiting for sales knowledge and relevant management tools to be integrated, summarizes the artcles message.

The key reason, he explains is that many companies have installed CRM applications expecting to see improvements simply based on the technology's presence. Somehow Dickie reached back fifteen years for a great quote by Jessica Keyes: "Technology does not beget a competitive advantage, any more than paint and canvas beget a Van Gogh." Fifteen years ago the Pentium was just coming out, but this statement still really applies in today's market.

The fact that "sales people still cannot easily get access to the knowledge they need to effectively compete," is reinforced by citing a 2007 analysis performed by CSO Insights. Firms were asked what information their salespeople needed to sell effectively, and to assess how easy it was for the salespeople to access that information.

Several very basic types of sales information appear on the resulting list. Namely, simple contact information, purchasing history, case studies, executive profiles, previous sales and marketing efforts and the customer's industry. It makes sense to the canny salesperson who is used to having to "Google" the customer, look up past purchase orders or even sift through pages of web content to track down the name of a decision maker before picking up the phone. This is really some very basic but critical information. So basic that it's painful to think that salespeople have to spend any significant time and effort to get at it. Precious time and effort that could otherwise be spent selling.

The process of collecting the required sales information must become as automated as possible in order to minimize the amount of detective work done by salespeople. A great deal of this information is readily available on the web databases. Salespeople know this because they "Google" for the information. The trouble is that locating good information can be like finding a needle in the giant haystack of web content. A task that text mining is perfectly suited for. A text mining tool can meticulously comb web content and analyze the results to eliminate unneeded information and report significant customer information such as contact information, executive information, industry, customer lists, partners and recent events. Ideally all of this would be connected to a CRM system with customer reports available to salespeople at the push of a button.

With all due respect to the author Mr. Dickie, I would have titled the article "Fueling the People Engine". Simply fueling CRM still does not beget a Van Gogh. The the real engine in the sales process are the salespeople and businesses are clearly saying they need more access to higher quality food.

Labels: , ,

Tuesday, April 03, 2007

Microsoft Dynamics CRM Analytics Foundation

Microsoft recently released the Microsoft Dynamics CRM Analytics Foundation, a shared-source download for Microsoft CRM customers and partners. The Analytics Foundation is available as a free of charge shared-source download at CodePlex. The current release is in beta and includes sample code, pre-built templates and components, and guidelines for building business intelligence solutions for Microsoft CRM.

I got a chance to see a demo last month in San Diego at the Convergence event for Microsoft Dynamics and speak with the Wan Li Zhu, who is the coordinator of the Microsoft Dynamics CRM Analytics Foundation project. It looked good. Wan showed us some very nice OLAP integration with Excel 2007, a service dashboard, lead qualification and sales analysis. The views were very easy to understand and it was all right inside of CRM.

Based on this release and a few of the presentation sessions at Convergence it looks like Microsoft Dynamics is definitely trying to enhance the value of their CRM solution with analytics. Wan Li Zhu spoke with us at the exposition and described the Analytics Foundation as something Microsoft would like to see partners run with. More recently on the CodePlex message board Wan stated that Microsoft is intending to make the Analytics Foundation a product but did not have a schedule to share.

The Analytics Foundation data sheet presents the software as "a suite of business intelligence products that work with Microsoft Dynamics CRM 3.0." The CodePlex description of the Analytics Foundation as a "business intelligence solution accelerator" to help partners deliver analytics to customers is more accurate. Wan stated to us that support for the Analytics Foundation was still available only by blog and forum. Based on the communication thus far it does not look like Microsoft is ready to fully support the Analytics Foundation.

That does not mean that the Analytics Foundation is without value to end-users. As a Microsoft Partner and developers of analysis software, we see some great things in the Analytics Foundation to take advantage of to benefit CRM customers. Data analysis by nature is not a cookie cutter solution. Quality results require the analysis to be fitted to specific problems and business processes. When trying to extract useful information out of complex business data, CRM customers that do not have the benefit of in-house analysis experts will want the assistance of partner with experience in analysis and CRM. A good analysis partner will tailor what Microsoft has provided through the Analysis Foundation to address the unique needs and problems of individual organizations.

ProWorks is interested in working with CRM partners and customers who would like to get a head start with CRM analytics. We can help you take advantage of the Analytics Foundation or even create customized analyses designed specifically to meet a special need. ProWorks is particularly interested in the areas of predictive analysis, data mining and analyising unstructured data such as the text found in blogs. Even if you just want to chat about the future direction of CRM analytics, shoot us an email at crm@proworks.com.

Some of the customer benefits of the Analytics Foundation listed by Microsoft include:
  • Executives can better track and manage business performance
    through dashboards
  • Managers and employees can create reports quickly and
    make better decisions
  • Sales, marketing, service employees can identify new opportunities
    to grow revenue and increase efficiency through
    predictive analytics.

Analytics Foundation Requirements:

  • Microsoft Dynamics CRM 3.0
  • Windows Server 2003 Enterprise Edition with Service Pack 1
  • SQL Server 2005 (Standard or above)
  • Internet Information Services (IIS)
  • Both .NET Framework 1.1 and 2.0
  • Office SharePoint Portal Server 2003 or Windows SharePoint Services with SP2
  • Business Scorecard Manager 2005 (required for editing and creating new scorecards)
  • Visual Studio 2005
  • Excel 2007 (recommended)

Labels: , , ,