A Data warehouse based analysis on CDR to depict market share of different mobile brands

摘要

Each mobile device represents the digital footprint of the owner; at the same time mobile location data stored in telecom operators' databases in terms of Call Detail Record (CDR). It holds the precise identity of the mobile cell tower to which the owner is connected at any given time. Effectively mobile device count within a region for some time period can be calculated. Again, International Mobile Equipment Identity (IMEI) number is an unique identity to every mobile device, a part of which, known as Type Allocation Code (TAC) uniquely identifies the make and model of the mobile device which further identify the company or manufacturer of the mobile device. So combining them it is possible to analyze different business information about mobile penetration of companies in a defined region; hence the localized market share comparisons with other companies as well as among different models of same company. In order to model the problem and analyze huge CDR data, an analytical processing is carried out here using data warehouse. Here we propose a suitable Data warehouse schema which comprises of the required dimensions along with their concept hierarchies. The ETL processing which is done to form the data warehouse is described here. Finally the lattice of cuboids is constructed to carry out the OLAP processing from all possible business perspective.