Exploit Predictive Analytics for a Pricing Strategy

  • by Shreekant W. Shiralkar, Global Head, SAP Analytics CoE, Tata Consultancy
  • Rohit Kumar Das, SAP HANA Architect, Tata Consultancy Services
  • December 16, 2014
Shreekant Shiralkar and Rohit Kumar Das show how to apply SAP Predictive Analysis Library (PAL) functions in SAP HANA to retail store data to calculate an optimum price.
Learning Objectives
Reading this article you will learn how to:
  • Apply the Predictive Analysis Library (PAL) within SAP HANA for predicting the optimum price for a product by using k-means and multiple linear regression algorithms
  • Create an SAP HANA calculation view, an SAP HANA procedure, and SAP HANA predictive modeling
Key Concept

The Predictive Analysis Library (aka PAL) is a set of predictive algorithmic functions embedded in SAP HANA. Each of the algorithms is written in native C++ and is capable of execution at the database layer (i.e., in-memory computing). Execution at the database layer enables computing of an extremely large set of data with millions of rows in a few seconds. You can generate results in real time.

The SAP HANA Predictive Analysis Library (PAL) contains the most popular and proven algorithms applicable to real-life scenarios. Each algorithm has a specific property that you can configure for its execution to meet the requirements of a particular business scenario. 

We demonstrate how PAL enables better business decision making with a case study that shows how to apply regression analysis over data clusters for a pricing strategy in the retail industry. You can predict the right price of an article at a future time, providing for higher profitability. Application of the k-means cluster analysis and multiple linear regression (MLR) algorithm is explained through step-by-step instructions. You can create relevant clusters and find relationships between different sales parameters in an electronic retail store to arrive at the optimized pricing for a product.  

Shreekant W. Shiralkar

Shreekant W. Shiralkar is a senior management professional with experience on leading and managing business functions as well as technology consulting. He has authored best selling books and published many white papers on technology. He also holds patents for innovations. Presently he is global head of the SAP Analytics Centre of Excellence at Tata Consultancy.

See more by this author

Rohit Kumar Das

Rohit Kumar Das is a certified SAP HANA architect and SAP Data Services consultant at Tata Consultancy Services and a senior associate at its SAP HANA Center of Excellence. Rohit is engaged in designing and developing SAP HANA-based solutions across industries and business scenarios. In his 10 years of career in IT services, Rohit has worked with multiple industries such as banking and finance and retail. Rohit has extensive experience in designing and developing SAP HANA-based solutions, data warehouse, and SAP Data Services.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.