Geo Business Intelligence for Fast Moving Consumer Good (FMCG) Industry in Pakistan

Abstract

The Geo-Business Intelligence (Geo-BI) is a collection of technologies that combines Geographic Information Systems (GIS) and Business Intelligence (BI) for evaluation of the results achieved, planning and decision-making. In this research we developed a Geo-BI for fast moving consumer goods industry like Anhaar Foods in Islamabad with the objectives (1) to provide Geo-Visualization capability for viewing FMCG distribution networks and other statistical information on maps (2) to design and optimize economically efficient routes for delivery dispatch (3) to develop spatial decision support system for potential sites selection for new warehouses and their network optimization. The survey was conducted to collect the different business attributes including monthly sale/purchase of Anhaar Foods items as well as their GPS coordinates. Road network taken through OSM and was corrected topologically and a network routable dataset was prepared. A web based system was developed where ArcGIS server was used to publish retail outlets location and network dataset for routing. Widgets were customized to provide spatial intelligence capabilities like directional distribution, mean location, standard distance, site suitability, and network routing etc. The web based Geo Business Intelligence platform developed in this research will allow managers and business analysts monitor data and statistics, make decisions, analyze market trends, study the insertion of new products and maintain profitable and long-lasting relationships with customers in order to stay competitive in a global world.