How to develop scorecards in SAP Expert Analytics

Custom R Components – Weight of Evidence coding and scorecard builder application

Introduction

This application provides an analysis of exploratory type, used to determine which variables in the dataset have a predictive power over the dependent variable (target).

It has been a very popular method in scorecard development – for credit risk within the banking sector, but in the recent years it has received increased attention in other sectors, as well.

Prerequisites

We suggest installing the RStudio Integrated Development Environment (IDE), as it is the most popular interface for R.

You can, then, simply install the following libraries through RStudio:

  • data.table (available on cran)

To install the package use the following command: install.packages(“data.table”)

  • devtools   (available on cran)

To install the package use the following commandinstall.packages(“devtools”)

  • woe    ( available on Github)

To install the package use the following commandinstall_github("woe","barbuirina19")

If you need assistance configuring R in SAP PA Expert Analytics, refer to the following guide.

How to upload the component in SAP PA

You can download the component as a .spar file Github and then deploy it as described here.

Simply import the component by clicking the + button under models tab:

6.png

Usage

The users can set the following parameters:

7.png

Example

We can use the Insurance_training dataset, which can be found here.
This table contains data on the customers of insurance company (demographics : age, gender, children, profession and more specific: type of car, annual km, years since license, etc.)
The goal is to analyze the past accident claims and get a deeper understanding over the main characteristics of a risky client. The scorecard that gets generated can be, then, pushed into a database and used to generate risk scores for the new insurance applicants.
In the Predict tab, simply drag and drop the new component, right click on it, and Configure Settings:

After successfully running the analysis, you can explore :

1.   Scorecard table
2.    Variable importance chart
3.    Weight of evidence charts

1.   Scorecard table

2.   Variable importance chart

3. Weight of evidence charts

Please note it is mandatory that the target variable be binary and numerical. The application will not translate categorical variables into the appropriate format (e.g. “Yes/No” response variable into numerical “1/0”).
In case the target is not numerical, simply use a formula (under Data Preparation) and do the necessary changes before running the analysis.
In case the target is not binary (more than 2 values), then use a formula to create dummy variables and then run the analysis using each one of the new variables as target.

Al Faisal Holding selects SAP and Clariba to deploy business software solutions to support its expansion plans

Al Faisal Holding, one of Qatar’s leading private companies, has signed a five-year agreement with SAP, the market leader in enterprise application software, to deploy SAP business solutions. These solutions will enhance the integration of Al Faisal Holding’s operations as the Group continues its strategic expansion across a number of different sectors.

Clariba Launches Office of the CFO Division to Focus on the Most Critical Pillar of Any Organization – the Finance Team

Clariba — an independent, analytics consultancy — creates new business unit, Office of the CFO, that builds on Clariba’s considerable strengths in data warehousing, big data, business intelligence and advanced analytics to provide solutions devoted to CFOs and finance teams. Christophe Machinet has joined the company as general manager for the new business unit and will be responsible for the division’s growth.

Clariba to host webinar on data discovery, self-service BI and SAP Lumira in Spain

SAP Lumira: Convierta grandes volúmenes de datos en información manejable

¿Qué es Data Discovery? ¿ Qué es el self-service de BI ? ¿Qué es SAP Lumira? 

Descubra con nosotros los beneficios que proporciona esta útil y dinámica solución de negocio en la próxima conferencia web de Clariba en 30 de Septiembre.

 

 

How to overcome limitations of having 1 data source: Multisource SDK with SAP BusinessObjects Design Studio 1.5

As a SAP BusinessObjects Design Studio SDK developer, I always faced the limitation of having only one data source on my components, but now with SAP BusinessObjects Design Studio 1.5 the option of binding a data-source to a property on any component (SDK or out-of-the-box) that limitation no longer exists, and here is how to overcome it.

Clariba Selected as a Finalist in the People and Culture of the Year Award Category for the Gulf Capital SME Awards 2015

Clariba — an independent, analytics consultancy based in Dubai — is named a finalist in the People and Culture of the Year Award category for the Gulf Capital SME Awards 2015.

The awards are organised by MEED, which partnered with Gulf Capital four years ago as the headline sponsor, to recognise the UAE’s SMEs, business leaders and entrepreneurs for innovation, growth and success.

How to implement dynamic maps in SAP BusinessObjects 4.1 Web Intelligence

As you may know, there are different workarounds to include dynamic maps in SAP BusinessObjects 4.1 Web Intelligence, such as using hyperlinks (i.e. Dashboards) or external API’s (i.e. google maps).  In case that the reports have to be printed as they are, these options do not provide a solution because it’s necessary to embed an image and not a hyperlink in the document.

Our solution consists in using empty cells and insert PNG images of the regions/countries as a background.

Why Join Clariba? Learn how Alex becomes part of Clariba - #BeClariba

Alex discovers Clariba can provide him massive career growth, exposure to new cultures, and more responsibility in larger types of customer projects. Being part of the Clariba team is for people like Alex who strive to perform as individuals, who share the company values, who integrate well into a team, and who thrive in an international, networked environment.

Clariba Receives Certification for SAP Recognized Expertise in Business Intelligence within Spain

Building upon its solid SAP certification in the Middle East

Based on Clariba’s specific expertise and successful completion of all requirements of the SAP® Recognized Expertise Program, Clariba in Spain has been granted the SAP Recognized Expertise designation in Business Intelligence.