Data Mining Consultancy Project (DMRG) Meeting 16

siberiaskeinΔιαχείριση Δεδομένων

20 Νοε 2013 (πριν από 3 χρόνια και 9 μήνες)

227 εμφανίσεις

Data Mining
Consultancy Project

(DMRG)

Meeting
1
6

Date:

30th Nov 2012

Time:

2.3
0


5.30
p
m

Venue:

Level 4
, Discussion Room

Attendees:


Alan

Cheah Kah Ho
e
,

Zaihisma,

Dr.Sharif
ud
d
in
,
Ammutha,

M
ohana


1.

Meeting started at
2.3
0p
m.


2.

Agenda :


a.

Anal
yze customer paying regularity for PK Bangi
for the month
Jan


佣O′012⸠





Shukeri
managed to
trans
pose

all the data from Jan
-
Oct 2012 where null
indicates payment not made
.

4.

Numbers of null values were successfully derived from the transposed
data.

5.

Based on analysis done, month 1
-

month 10,
CW 1

-

22101 records
(
average paymaster
, very few who pays regularly) findings contradict as
CW 1

was supposed to be

噥特VGood


p慹m慳瑥牳⸠



For CW 3,4,5
-

graph as predicted (histogram).

7.

D
ata
was classified
bas
ed on earlier analysis done to 1
-
2 very bad, 3
-
5
bad, 6
-
8 good, 9
-
10 very good.

8.

Visualized findings through histogram showed the following (bad
42.84
%
, good 20.88
%
, very bad 33.24
%

, very good 3.04
%.

9.

Challenges faced:

a.

Could not merge files CW1 & CW3,4,5 be
cause of customer type
mismatch (symbol & float).

b.

Used ‘filler’ function to merge, works but no values derived
⡣畳瑯m敲e䥄⁣on瑡楮猠s0⁩ ⁦牯n琩



㄰1


Next course of action:

a.

To
request from Wan Johari excellent paymasters with CW 0
-

10% of 143819 (14000)
to identify pattern.





11.

Seventh meeting scheduled on the 7
th

December

2012, at 2.30p
m.


12.

Meeting adjourned at 5.30
p
m.



Minutes prepared by,

Mohana Shanmugam