Was given a dataset of 7 million daily records, that includes the daily check-ins made by passengers when accessing any of the over 500 stations in the combined Metrobus and STC Metro network.
I processed and optimized the data by grouping the relevant indicators into 15-minute timeframes. Additionally, designed an interactive UI to allow stakeholders to inspect any of the indicators displayed for any station they select.