Use case Description - Scenario 5 - Live dashboards#
Use case description - Problem statement#
As a data scientist, I need to create a dashboard that visualizes up-to-date insights.
Use case goals#
- Fetch the weather data of the city of Brussels from the Open-Meteo API
- Store the data into a SQL DB
- Set the execution of data fetching on a daily basis
- Build a dashboard to display the weather data
Tools & Capabilities#
To meet the use case goals, the following tools from the portal will be leveraged:
| Tool | Description | Key capability |
|---|---|---|
| Jupyter notebook | The Jupyter Notebook is a web application for creating and sharing documents that contain code, visualizations, and text. It can be used for data science, statistical modeling, machine learning, and much more. | - Fetch the data from the API - Connect with PostgreSQL - Store the data into dedicate tables |
| PostgreSQL | PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. | - load and store the data |
| Airflow | Airflow is a platform created by the community to programmatically author, schedule and monitor workflows. | - Schedule the execution of the data fetching/storing script |