business intelligence for loans and fixed deposits

1www.ElegantJBI.comElegantJBI-Business-Intelligence-Suite-for-Loans & Fixed Deposits

ElegantJ BI- Business Intelligence for Loans & Fixed Deposits Business Intelligence is no longer what you thought it to be

2ElegantJBI-Business-Intelligence-Suite-for-Loans & Fixed Deposits www.ElegantJBI.com

The PromiseBI Democratization:Cost effective reach across the organization. You can reach hundreds of users at an unmatched cost

Incredible TCO:Lowest cost of ownership

Independence:From special skill, consultants, device, operating system, complex licensing or any transaction systems

Unique TechnologyManaged Memory Computing: Puts the power to choosing the data you want in memory in your hands

Speed:Shortest implementation time


The Architecture

Driving Principles:• Simplicity: Make product design simple to use and reach• Independence: Give customers the freedom to choose other platforms and options• Scalability: Should grow as use and reach expand• No Maintenance: Should not have any other cost for maintaining and running the

application


INTEGRATE TEAMS, SCALE POTENTIAL

ElegantJ BI for Logistics


Key Challenges

Connecting to disparate data sources

Consolidating data for accurate monitoring of business

Data-level security in reports and dashboards through access rights

Making analytics available across the organization in multiple branches and across the board

Limited analysis of daily business operationsDelays in reporting due ad-hoc dependency on MIS team

Limited performance management due to shadow areas in reporting in absence of Dashboards & KPIs. Handling large data sizes for ad-hoc analysis


ElegantJ BI for Loans & Fixed Deposits

SPECIMEN KPIS & ANALYTICS


Key BI Objects and Analysis Overview of Operations : Loans & Fixed Deposits

Monitor important KPIs like EMI collection day over day Branch wise EMI: Due & Collection over the periodBranch wise analysis for Clients Added, Pending Applications and EMI unpaidDeep Dive KPI analytics for Fixed DepositsAnalyze Fixed Deposits Branch wise, Product Wise, for Divisions & SchemesMonitor Branch wise Interest paid Exception Alert for Fixed Deposits performance branch wise

Analyze Branch Performance Identify top-bottom performing branches by Loans Overdue Branch wise performance in terms of clients added, loans sanctioned, EMI collectedIdentify top-bottom branches with respect to Fixed Deposits value

Trend Analysis Identify trend for Non-Performing AssetsIdentify trend for Product wise Loans issuedIdentify trend for Dues Vs CollectionIdentify trend for Loan Approval Lead timeIdentify trend for Sanction Loan Vs SecurityMoM & YoY Maturity Trend for Fixed DepositsMoM & YoY trend analysis for New Fixed Deposits


Loans Monitoring

Monitor Loans given: by different Branches, by different Agencies, to different Industries, given in the form of various Loan Products

Apply filter by Branch, Product, Account type etc

Exception alert to track overdue amount

Detailed analysis to monitor Interest overdue, Principal Overdue, Leadtime to process the loan etc


Loans Overdue Analyze Overdue amount and

Overdue installments for loans given by different Agency and loans given to different Age group

Top-Bottom analysis for various Branches, Approval Managers, Loan Products, Agencies and Client Age Group with respect to amount overdue

Analyze Loans Overdue by : - Various Branches, Approval Managers, Loan Products

Apply filter by Branch, Product, Account type etc

Identify number of clients for installments overdue with respect to various agency and age group


EMI Due & Collection KPI analytics for day to day EMI

collection

Branch wise analysis for EMI due and collected over the period

Branch wise analysis for clients added, EMI unpaid & Pending application with count and amount due

Ageing analysis for EMI due


Trend Analysis: Loans Interactive Graphical analysis for

identifying the trends

MoM trend analysis for Non-Performing Assets

MoM trend analysis for Loan approval lead time

MoM trend analysis for Sanction Loan Vs Security

MoM trend analysis for Product wise Loan issued

MoM trend analysis for Dues Vs Collection

Apply filters for Branch, Product, Industry type, Approval Manager, Account Type etc


Top-Bottom Analysis

Identify Top Branches, Agency, Clients, Products, Industry, Age Group with respect to Loans Overdue

Analyze Overdue Amount and overdue stake percentage wise.

Analyze Security value, Negative security and Security Deficiency


Fixed Deposits: Overview

MoM KPI analytics for Fixed Deposits Analyze performance of Fixed Deposits various Branch wise,

Product, Divisions and Schemes wise for a period and measure it through Exception alert

Analyze interest paid on Fixed Deposits by different branches Apply filters for Schemes, Products, Branch, Gender, Zone etc


Trend Analysis: Fixed Deposits

MoM & YoY trend analysis for New Fixed Deposits.

MoM & YoY trend analysis for Fixed Deposits maturity and its value

Apply filters for Branch, Product, Age group, time period etc


Analyze Fixed Deposits Branch wise, Deposit Terms wise, Age Group wise.

Analyze Fixed Deposits contribution by Account Type, Mode of Operations, Division

Apply filters for Scheme, Product, Agency, Account Type etc

Distribution Analysis


Unique Value Proposition

Ready to use templates to get started

Typical Implementation Cycle of 4 to 6

weeks

Training & Consulting for

DWH & ETL( if needed )

Model to empower your IT team for all your BI needs

Unbeatable ROI & shortest

Implementation Cycle


Unique Managed Memory Computing

Works on any OS

Device Independent; ready for any desktop, mobile or tablet

100% browser based

Connects to most databases and

applications

Self-service BI; works with novice user as easily as it works with

power analyzers

No dependence on special skills; in-house IT staff can easily maintain

and develop the application

Quick rollout to various locations and large number of users with short

training and no installation on client devices

For IT managers and Business Users

Design once, Use anywhere

Integrate ElegantJ BI into your apps,Deliver embedded analytics within your applications


Contact Us

For More Information Contact:Elegant MicroWeb A-305 Shapath IV, Opp. Karnavati Club, S. G. Highway, Ahmedabad- 380051 (India) Email: [email protected]

Sales, Partnership and Support :For any sales, licensing or partnership related inquiries:Email: [email protected]: [email protected]

ElegantJBI-Business-Intelligence-Suite-for-Loans-&-Fixed Deposits – Version 1.0 – Published 2015Copyright © Elegant MicroWeb Technologies Pvt. Ltd (EMTPL), all rights reserved

This presentation contains information that is proprietary and confidential to EMTPL, which shall not be disclosed, transmitted, or duplicated, used in whole or in part for any purpose other than its intended purpose. Any use or disclosure in whole or in part of this information without express written permission of EMTPL is prohibited.Any other company and product names mentioned are used for identification purpose only, and may be trademarks of their respective owners and duly acknowledged

mailto:[email protected]

mailto:[email protected]

business intelligence for loans and fixed deposits

Data & Analytics