Mining Customs Data for Customer Segmentation: the Case of Ethiopian Revenues and Customs Authority (Erca)

dc.contributor.advisorAssefa, Temtim (PhD)
dc.contributor.authorTenaw, Sewagegn
dc.date.accessioned2019-09-26T09:53:28Z
dc.date.accessioned2023-11-18T12:44:32Z
dc.date.available2019-09-26T09:53:28Z
dc.date.available2023-11-18T12:44:32Z
dc.date.issued2018-06-04
dc.description.abstractCustomer relationship management (CRM) is the overall process of exploiting customer data and using it to increase the revenue generated from an existing customer and attract new customers by creating good relationship with them accordingly. CRM links business processes across the supply chain from back office functions through all touch points, enabling continuity and consistency across customer relationships. On the other hand, customer segmentation is the process of dividing customers into homogeneous groups, where customers within each group are similar to each other and share common attributes. In order to analyze CRM sophisticated data, one needs to explore the data by using different aspects. Data mining is one the newly emerged technology in this endeavor. Data mining finds and extracts hidden knowledge in corporate data warehouses. In this study the applicability of clustering data mining technique to support CRM activities for ERCA has been explored using the CRISP-DM process model approach. After understanding business objective of the authority, different characteristics of the ERCA customers' data were collected from the ERCA's ASYCUDA++ database. Once the customers' data were collected, the necessary data preparation steps were conducted and finally the dataset consisting of 65535 records/instances were employed to develop a clustering model. To segment customers, the k-means clustering algorithm was employed. During the cluster modeling, different experiments were conducted using different cluster numbers (k=4, 5, 6) with different seed values (10, 100, 1000). Then, the one which performed the best was selected. Thus, the model where k=4 and seed size 100 had shown better clustering performance. It enables to cluster the authority's customers into dissimilar clusters of high, medium and low value customer groups with minimum iteration value of 6 and minimum sum of square error (SSE) within clusters value of 2142.82. The results of this study have shown that the data mining techniques are valuable for customer segmentation. Hence future research directions are pointed out to come up with an applicable other data mining techniqueen_US
dc.identifier.urihttp://etd.aau.edu.et/handle/12345678/19194
dc.language.isoenen_US
dc.publisherAddis Ababa Universityen_US
dc.subjectMining Customsen_US
dc.subjectData for Customeren_US
dc.subjectSegmentationen_US
dc.subjectCase of Ethiopianen_US
dc.subjectRevenuesen_US
dc.subjectCustoms Authority (Erca)en_US
dc.titleMining Customs Data for Customer Segmentation: the Case of Ethiopian Revenues and Customs Authority (Erca)en_US
dc.typeThesisen_US

Files

Original bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
Sewagegn Tenaw 2018.pdf
Size:
1.57 MB
Format:
Adobe Portable Document Format
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.71 KB
Format:
Plain Text
Description: