Use case Description - Scenario 1 - Data visualization#
Use case description - Problem statement#
As data scientist, I need to extract insights and visualizations from the provided dataset to support the storytelling of the "energy balance in the EU" report.
Use case goals#
- Load the data
- Query the data
- Explore the different visualization opportunities
- Select the best-fit visualization techniques
- Create the visualizations
Tools & capabilities#
In order to meet the use case goals, the following tools from the portal will be leveraged:
| Tool | Description | Key capability |
|---|---|---|
| PgAdmin | PgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. | Data load |
| 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. | Data query |
| Apache Superset | Apache Superset is a modern data exploration and visualization platform. It is fast, lightweight, intuitive, and loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial charts. | - Data pre-processing (null values, outbound values, ...) - Explore the different visualization opportunities - Select the best-fit visualization technique - Create the visualizations |