I am building a routing solution app for my city using public transit. Currently I have data regarding bus stops and routes.
Currently its an sqlite table with one table containig busstops with their latitude and longitude, and other containing all the bus routes, linking bus stops and having the bus time table.
How should I go about visualising the data using qgis? I need to visualise the data to validate my data set and to extract more information to develop my routing solution.