image
JayceEr

5

Measures for Auto Loan


Hi all, what measures should be used for auto loan and auto loan payment in OLAP.

Examples would be much appreciated :)

Thankyou :)



- JayceEr
image

ChiangZhiHui

3

Hi Jayce

An example for measures to be used in auto loan can be:

Count of Sign Up

Hope this helps

Best regards, ZhiHui



- ChiangZhiHui
image

JiaXin

5

hi jayce, you can use the amount in the auto loan table as one of the measure.



- JiaXin
image

FarhanaMahadi

5

Count of customers used what types of car brand.



- FarhanaMahadi
image

Alysha

3

Count of Category in auto loan table :)



- Alysha
image

Scottt

2

You could use sum of money collected per month from the customers as a measure



- Scottt
image

Nicoleswy

0

Hi Jayce Er,

You can count the noOfAutoLoan the bank has as a measure.



- Nicoleswy
image

XavierLZH

2

You can use a measure such as:

1) NoOfCustomers to find out which type of cars are popular among the customers

2) AutoLoanCount to see at which period the customers have applied for auto loan the most



- XavierLZH
image

ChinHin

0

Yo jayce you can use number of sign up, count of customer using the various car brands, Sum of Interest collected per month.

Hope this helps :D



- ChinHin
image

Bjergsen

3

I didn't do autoloan but it'll give some examples to the best of my knowledge and memory I have on the data .

Examples can be like the number of signups , number of specific car brand , average loan payment received per month or any time length of your choice ! There are many more .



- Bjergsen
image

OngChenYu

0

These are some examples I think would be good

-Count of signups

-Average Sum of money

-Sum of money



- OngChenYu
image

ruonan

0

-Maximum sum of money

U can use it to see the max amount a customer would pay

-Count of signups

To see the number of signups each year .



- ruonan
image

Suhaila

1

-Minimum Sum of money

See how low customers pay pay in a month



- Suhaila
image

AlvinYap

0

I think that these are some possible measures you could consider:

-Count of signups

-Average payment



- AlvinYap
image

tyt2315

0

Count of total no. of accounts



- tyt2315
Cancel