subscriber data mining in telecommunication
TRANSCRIPT
![Page 1: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/1.jpg)
Supervisor
Babu Ram Dawadi
Co-Supervisor
Manoj Ghimire
Subscriber Data Mining for Business Reporting and Decision Making in Telecommunication
Project Member
Bishal Timilsina
Bishnu Bhattarai
Narayan Kandel
Niroj Karki
1
![Page 2: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/2.jpg)
PRESENTATION OUTLINE1. Introduction
2. Block Diagram
3. Data Collection
4. Data Preprocessing & Loading
5. Data Mart Design
6. OLAP Design
7. Data Mining Algorithm
8. Visualization
9. Result & Conclusion
10. Reference2
![Page 3: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/3.jpg)
INTRODUCTION
Problem Statements
Product based strategies rather than customer based strategies
Problem on CRM
Ignorant about customer behaviours
Objectives
Customer Segmentation
New Campaign
Customer Relationship
Management
Reporting
To know more about customer, their call detail
Churn Prediction3
![Page 4: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/4.jpg)
BLOCK DIAGRAM
4
![Page 5: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/5.jpg)
DATA COLLECTION
1. csv format
2. Txt format
5
![Page 6: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/6.jpg)
ETL PROCESS
Extract Extract tab separated data from txt file using bash shell & regular expression
Transform Male to m
Female to f
Business_call to 1
Non_business_call to 0
Load Load data to mysql database using python script
6
![Page 7: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/7.jpg)
DATA MART DESIGN
7
![Page 8: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/8.jpg)
OLAP DESIGN
Purpose:
Slice, Dice, Roll up, Drill Down operation
Design Basis:
4 dimension representation
8
![Page 9: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/9.jpg)
DATA MINING
1. RFM Methods
R Recency (x axis)
F Frequency (y axis)
M Monetary (z axis)
Step
Attribute Selection & K-means Clustering
9
![Page 10: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/10.jpg)
DATA MINING …
2. Two Phase Clustering
10
Objective
Customer Segmentation
How?
1st clustering -> Diamond, Gold,
Silver …
2nd cluster -> Demographic
cluster
Now compare cluster based on
attribute value
![Page 11: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/11.jpg)
DATA MINING …
2. Two Phase Clustering
11
Objective
Customer Segmentation
How?
1st clustering -> Diamond,
Gold, Silver …
2nd cluster -> Demographic
cluster
Now compare cluster based on
attribute value
![Page 12: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/12.jpg)
DATA MINING …
2. Two Phase Clustering
12
![Page 13: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/13.jpg)
DATA MINING …
3. Gaussian Distribution
13
Objective
Churn Prediction through call
diameters
How?
Predict customer with value
outside 90% confident range
Accuracy?
With increase in data size->
accuracy increase
![Page 14: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/14.jpg)
VISUALIZATION
1. Demographic Visualization
14
![Page 15: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/15.jpg)
VISUALIZATION
2. CDR Visualization
15
![Page 16: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/16.jpg)
VISUALIZATION
3. Time Series Visualization
16
![Page 17: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/17.jpg)
VISUALIZATION
4. OLAP Visualization
17
![Page 18: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/18.jpg)
VISUALIZATION
5. OLAP Visualization …
18
![Page 19: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/19.jpg)
VISUALIZATION
6. OLAP Visualization…
19
![Page 20: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/20.jpg)
RESULT & CONCLUSION
With the implementation of this software, telecommunication will be able to
know more about customer & their call behavior
Customer Segmentation help them
1.To maintain effective customer relationship management
2.To launch specific offers focusing on specific groups
Alert them about customer churn behavior
20
![Page 21: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/21.jpg)
LIMITATION & FURTHER ENHANCEMENT
Limitation
Data load time is high
Our System Isn’t customizable for all query
Further Enhancement
Customer Segmentation accuracy could be improve by including customer life time value & apriori algorithm
Reporting tool could be made more general & flexible
Competitor Analysis
21
![Page 22: Subscriber Data Mining in Telecommunication](https://reader033.vdocuments.us/reader033/viewer/2022052506/5577c598d8b42a1c068b53ea/html5/thumbnails/22.jpg)
THANK YOU
Any Queries?
22