Posted in QlikView Project by ProjectBuckets-Free Projects Source Code (620 points)

Here we are creating KPI’s to calculate customers number, disbursed amount, Over Due Principle amount, Outstanding Principle amount and sales on year wise, month wise, etc.

We can create Dashboards and analyze Customer Loan Data by using different types of Charts example Bar Chart, Pie Chart, Line chart, Pivot Table and Straight Table.

Calculate the below:

1) Minimum and Maximum customer values
2) Minimum and maximum Disbursed Amount Month Wise, Year wise.
3) Minimum and maximum Due Principle

Using Set Analysis to Analyze & Calculate the Data:

State and region wise Loan Analysis using Pie & Bar Charts:

Area wise Distinct Customer Loan Analysis:

Download this Analyzing Customer Loan QlikView Project.

Welcome to Project Buckets, where you can post projects code/questions,download projects code and receive comments from other members of the community.