This project aims to offer a comprehensive exploration of daily transit traffic within ONCF, covering both bus and train journeys. The process involves web scraping to collect traffic/trip data from the official ONCF website, structuring the data into a MySQL database, and subsequently visualizing it using Tableau.
The dataset was obtained from the official ONCF website.
The data schema is structured as follows:
The project architecture is outlined below:
The visualizations are available on Tableau Public:
For an interactive version, please visit the Tableau Public page.
- ONCF - Official ONCF website used to collect data.
- Python - Programming language used to build the web scraper.
- LatLong & GPS Coordinates - Used to obtain the latitude and longitude of Moroccan cities.
- MySQL - Relational database management system used to store the data.
- Figma - Used to design the dashboard.
- Tableau - Data visualization tool used to build the dashboard.
This project is a personal endeavor and is not affiliated with ONCF in any way. I do not own the data used in this project; it was collected from the official ONCF website.
This project is licensed under the MIT License - see the LICENSE.md file for details