This independent study aims to create a data transformation process and essential analysis and illustrate visualization from the passenger journey data on mass transit system. In this era, urban and population expansion has caused an incredible concern on urbanization especially infrastructure of the city. Mass public transportation is considered to be the core development for an urban logistic and one of the most important tools to minimize the social disparity. Unfortunately, due to some constrains, one of the most vital data such as passenger travelled data cannot be obtained in ready-to-use form. In this independent study, we will focus on develop the automation process to transform the origin-destination matrix of mass rail transportation into transactional data which will enable the processing of analytical and visualization data further. Furthermore, this study will develop analytical visualization in accordance with the requirements gathered from the executive of the Mass Rapid Transit Authority of Thailand (MRTA). This study has shown significant insights from passengers of the mass rail transit system which will be able to supply as supporting data for yearly and quarterly meeting for MRTA’s board of director to improve the ticketing system and most importantly to be a primary supporting data for future public transportation development in Thailand.