Use case description - Scenario 3 - Low code data analytics#
Use case description - Problem statement#
As a data scientist, I need to extract insights from data stored on a relational database in a low code/no code manner such that I can create reports quickly and with a low amount of effort.
Use case goals#
- Load the data
- Perform ETL operations on the data
- Provide a low code/no code solution to create data visualizations
Tools & Capabilities#
To meet the use case goals, the following tools from the portal will be leveraged:
| Tool | Description | Key capability |
|---|---|---|
| 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 data - Data query |
| Knime | KNIME Analytics Platform is the open source software for creating data science. Intuitive, open, and continuously integrating new developments, KNIME makes understanding data and designing data science workflows and reusable components accessible to everyone. | - low code/no code ETL operations on the data - Visualization of the results |