Utility of OLAP and Digital ATLAS to Enhance Cross-Border Connectivity among Punjabi Sikh NRIs

Abstract

Data analytics is one of the prominent research areas and finds its application in various domains. By expending this concept, this paper presents a case study of Punjabi Sikh NRIs that are one of the largest Diasporas in the world today. Diaspora has acted as a great reservoir for financial, political, and moral support for their homelands. Therefore, Diaspora has become a prominent part of human enquiry and research. However, with the invention and proliferation of Information and Communication Technologies (ICT), Diaspora people/communities connect effectively with the people of their community living in different countries. The proposed paper discusses the two main techniques, e.g., Online Analytical Processing (OLAP) and digital ATLAS, which can be used for the purpose of enhancing cross-border connectivity among Diasporas. These techniques provide a two-segment support. The first segment (OLAP) assists the development of a framework of database of profiles of the Diasporas of a particular community. These profiles include the prominent figures working in the mainstream political associations, in the fields of education, defense, entertainment, technology and economics, and various organizations of a few countries such as UK, Malaysia, USA, Canada, and Australia. The second segment (Digital ATLAS) facilitates the development of a digital ATLAS composed of detailed statistical profiles of the Diaspora community. This digital ATLAS draws upon the available official data in various locations of the countries, using visualizations and dashboards. The implementation details of five phases considered for these techniques have been elaborated in this paper.