PERANCANGAN DATA WAREHOUSE DAN PENERAPAN TEKNIK CLUSTERING SPATIAL PADA WESEL: STUDI KASUS PT XXX

By setting up the right service and product for the customer, the company may increase its marketing effectiveness as well as sales. For that purpose, information on company’s product and sales is highly needed in order to help on decision making process, which expectedly enables company to create value and eventually gain competitive advantage. This research attempts to develop a Data warehouse for PT XXX, which is expected to exhibit useful information for the company without disturbing its operational system. The Data warehouse is developed with Oracle 11g. Apart from that, this research also aims to gather information and knowledge with spatial database. The data mining is conducted by using WEKA application, which compares the algorithm of DBSCAN, K-Means, and EM clustering. Data mining from the spatial data is expected to create area map which indicates sales rate of PT Pos Indonesia’s products. Through this it is hoped that the company may focus more in marketing certain product with particular advantage in one particular area to produce effectiveness. The research outcome indicates that the Data warehouse being developed has already managed to exhibit the receipt report of postal money order (wesel pos), retail stock, as well as retail sales