RAILytics: ONCF Traffic Analysis

Project Overview

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.

Dataset

Data Source

The dataset was obtained from the official ONCF website.

Data Schema

The data schema is structured as follows:

Project Architecture

The project architecture is outlined below:

Visualizations

The visualizations are available on Tableau Public:

For an interactive version, please visit the Tableau Public page.

Used Resources and Tools

• 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.

Acknowledgements

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.

License

This project is licensed under the MIT License - see the LICENSE.md file for details

---