CXO

Use business intelligence to boost sales and profitability

What enterprise doesn't want better sales forecasts, a better record of hitting sales targets, and increased profitability per sale? Find out how you can achieve all of these goals using business intelligence tools.

When organizations are equipped to extract crucial facts from operational data and then act upon them quickly, the result is often improved selling efficiency and enhanced profits. The good news is that business intelligence (BI) tools necessary to support this data analysis are within the grasp of most organizations.

Effective BI can boost your sales and marketing efforts in nine ways:
  • Increase sales using “fact-based” selling tools.
  • Build profits by targeting profitable activities.
  • Increase customer loyalty and retain customers for life.
  • Increase the accuracy and timeliness of sales forecasts.
  • Achieve budgeted sales.
  • Increase the proportion of high-value customers in your customer mix.
  • Reduce low-yield activities in the sales process.
  • Deploy higher-yield promotions and advertising.
  • Predict future behavior of prospects and customers.

In this article, I’ll discuss items four, five, and six on the list (as seen in bold above). My earlier article, "Business intelligence tools are key to building profits," discussed the first three points, and I will cover the last three in an upcoming piece.

Increase the accuracy and timeliness of sales forecasts
Information concerning future revenue answers the questions of ”what” you’re going to sell, “to whom” you’re going to sell it, and “when” you will make the sale. When it’s accurate and timely, this information has immense business value. The product side of your business benefits by knowing that red widgets, for example, are outselling blue widgets in Florida, but blue leads two-to-one in Ohio. Armed with such facts, you’re able to increase sales by putting the most attractive product in front of each customer. In addition, you can increase profitability by optimizing procurements and distribution. On the financial side, your CFO loves the reputation of credibility your organization can gain with bankers and investors who view accurate forecasts as evidence that you’re running your business well.

Of course, the challenge lies in actually constructing the accurate forecast. Particularly daunting is the required individual product and customer detail. Most often, gathering this information is a brutal and unreliable process.

The following are the common issues most organizations face when building a sales forecast:
  • When substantial facts are missing, forecasts are developed subjectively using different standards. Sales reps are often liberal, if not wildly optimistic, compared with management’s conservative posture. Either extreme is costly to the organization.
  • Sales momentum is crippled at budget time, as sales reps and managers waste time dickering over figures when compiling their account-by-account forecasts. All told, the preparation of sales forecasts can sideline a sales rep for weeks each year.

The forecasting burden can be considerably eased and the reliability of the forecast much improved when the right information is at hand to support the underlying analysis. BI tools give decision makers ready access to information that provides a detailed portrait of sales history. Easy and direct access to historical sales information supports both forecast accuracy and better, faster procurement and inventory decisions.

Achieve budgeted sales
Time and again, you find it’s late in the month and it’s apparent from the sales team that there will be a problem hitting the numbers. You scramble to assess both the magnitude and the source of the variance, and both you and the sales team pose dozens of pressing questions in a last-minute charge to recover. In this climate, most organizations face the following problems:
  • Answering the pressing questions requires sales rep and management time, shifting the focus away from productive sales activities. The valuable sales time lost serves to further compound the problem.
  • Shortcomings are revealed too late in the sales cycle to stimulate sales and recover the month.

Comprehending and acting upon accurate information early is what’s key to preempting unpleasant month-end surprises. Modern sales organizations employ BI tools, which allow them access to a continuous feed of valuable company information. In these organizations, managers and sales reps are able to, at any point in time, quickly grasp the big picture, then instantly drill down to identify particular areas of concern, such as individual products, accounts, and/or sales regions or representatives. Armed with this sort of intelligence, you can design and implement surgical “microplans” to address each small problem area as it is uncovered. The result? Making small corrections enable you to stay the course and make your month.

Increase the proportion of high-value customers in your customer mix
Your highest-value customers are dependable and low-maintenance. Most importantly, month after month, they contribute a hefty volume of high-margin sales. It makes sense to proactively seek prospective customers that have similar attributes and to focus your customer acquisition efforts on adding them to the fold. But many organizations have the following obstacles to overcome to achieve this sales initiative:
  • Often, organizations do not have the relevant customer information on which to build an accurate profile of their most-valued customers, which prevents any attempt to target similar prospects.
  • Even if an organization does have the critical customer information, it’s often not ordered in any useful manner. To truly reap the rewards of this information, customer information must be organized by geography, industry, volume of business, number of different products purchased, or any number of other pertinent characteristics to be truly useful in targeting high-value potential customers.

With a little imagination and a great information system, you can begin by implementing simple measures to enable you to rank your current customers according to their relative value to your organization. Initially, try ranking them by profit contribution alone, then you can add more sophisticated factors later, if you choose (timely payment, returns, complaints, etc.).

Once you’ve arranged customers from high to low value, you can do two powerful things right off the bat. First, you can better target your customer-acquisition initiatives by focusing your customer-acquisition efforts around the attributes common to high-value customers. Second, you can begin to engineer your overall customer mix by targeting high-value replacements for low-value customers.

Conclusion
The rewards of having the right information organized in a useful manner are many to the organizations that make the effort to attain these sales and marketing goals. Most organizations either have or can get the necessary data (garden-variety transactional type), but implementing the right BI tools can allow organizations to utilize that data in new and more efficient ways. The current crop of BI tools is both affordable and straightforward to implement (although it’s always advisable to spend some time with a BI specialist who has experience with BI solutions), and many organizations realize a payback in just a few months’ time.

How does IT help your sales efforts?
Using IT to enhance sales and marketing initiatives is a good way to generate measurable return on your technology investment. Share your success stories by posting a comment below.

 
1 comments
David Dell
David Dell

We all know and understand dashboards. Dashboards consist of visual components in the form of gauges, graphs, pie charts, bar charts, heat maps, and so on, allowing business users to get a quick overview of key performance indicators (KPI). One tool that i would recommend is VisualCue. This tools supports a new way of presenting KPIs with dashboards, and a new way of working with them.

Editor's Picks