Validation of Sales Prediction Model – A Linear Regression Model

In today's world, all banks are using analytics to take more informed decisions. Banks often use sales or revenue prediction models to plan their marketing strategy and customer focus. The models are either developed by in-house analytics teams or purchased from external agencies. Often banks struggle to monitor the performance of the models. Such monitoring is done either through ad hoc reports & tracking or periodic recalibrations of the models. It is imperative that banks examine the ongoing validity (versus obsolescence) of the models during such recalibration exercises. Banks that do not possess in-house analytics expertize and use external credit scores could struggle to conduct such evaluation & validation exercises, particularly in deciding whether the model remains applicable across the bank's target market segments.

insAnalytics brings an integrated easy-to-use validation tool to track, monitor, and evaluate the model being used by the bank. The solution provides answers not just to the questions generally asked by business end-users, but also those asked by project leaders and analysts. The complete solution is divided into three major sections. "Measure the Benefit" tracks major KPIs looked at by the business users. "Understand the Accuracy" reports statistical measures that help a project leader to monitor the performance of the model. "Understand Model Better" provides a 'dig-deeper' analysis that helps an analyst to evaluate areas where the model is performing in the desired fashion as well as areas that need to be investigated.

Key Features

  • Track your model with respect to Year-on-Year migration of customers, expected sales/ revenue loss or gain by each customer segment
  • Monitor your model with respect to rank ordering of the model, error distribution, Mean Absolute Percentage Error, etc
  • Evaluate your model with respect to actual versus predicted sales and residual analysis for each influencing variable
  • Drill down your analysis by different time windows, customer types, product types, geography, etc

Business Benefits

  • Visually-appealing decision engine easily usable by a wide range of business end-users
  • Real-time monitoring of your model or scorecard
  • Easy-to-use drilldown by various dimensions like "Customer Type", "Loan Type", "Location", etc
  • Early-warning signal to flag the need to revisit/ rebuild a model before it becomes obsolete and unusable
  • In-house expertize to frame and/or modify credit policies, reducing dependence on third-party analytics vendors

Analytics Backbone

  • Classification Analysis
  • YoY Analysis
  • Rank Ordering
  • Goodness of Fit
  • Residual Analysis
  • Visual Analytics
  • Exploratory Analysis

Technology Variants

  • Tableau
  • Qlik View
  • SAS Visual Analytics
  • SAP Lumira
  • Oracle
  • R

The solution is technology-agnostic, and available over a range of technology platforms. Choice of the best-suited platform for specific installations is governed by the existing ERP product being used by the client, in order to provide a cost-effective solution and to ensure seamless connectivity & integration. Open-source adaptations of the solution are also available to reduce the total cost of ownership for the client.

© 2017 All rights reserved
+ +