Icon

GDP360 - Solution

Data Access

Read Tables from the Database

Data Cleaning

Clean the data tables.

Data Transformation

Transform data to analyze key metrics

Data Merging & Aggregation

Data Export & Visualization

Remove MissingCountry Names &Country Codes
Missing Value
Column Renamer
Sorter
Remove DuplicateYear Records
Duplicate Row Filter
Expression
Remove MissingYear Records
Missing Value
Expression
Bar Chart
Joiner
Missing Value
Basic urbanization data for each country-year
Column Filter
Duplicate Row Filter
Lag Column
Remove FutureYears beyondcurrent year
Row Filter
Expression
Duplicate Row Filter
Country & year
Missing Value
Duplicate Row Filter
Missing Value
Duplicate Row Filter
Lag Column
Column Renamer
Column Renamer
Remove ExtremeUnemployment Percentage
Row Filter
Lag Column
Duplicate Row Filter
Column Renamer
Lag Column
Missing Value
Column Renamer
Joiner
Calculate how many new urban residents this year
Expression
Missing Value
Sorter
Joiner
Calculate how much urbanization increased this year
Expression
Joiner
Connect to the gdp360.dbfile
SQLite Connector
Select CountryTable
DB Table Selector (deprecated)
Read CountryTable
DB Reader
Select YearTable
DB Table Selector (deprecated)
Read YearTable
DB Reader
Select GDPTable
DB Table Selector (deprecated)
Read GDPTable
DB Reader
Expression
Calculate percentage increase in urban population
Expression
Total change over 5 years
Expression
Top 10Countries
Top k Row Filter
Column Filter
Expression
Get most recent year to identify top 10 countries
Row Filter
Sorter
Filter main dataset to show only top 10 countries across all years
Reference Row Filter
Rule Engine
Loop End
Group Loop Start
Column Renamer
Calculate the average YoY growth rate per country
GroupBy
Visualize the average GDP growth per country
Bar Chart
Arrange countries by growth rate
Sorter
List oftop 10countries
Top k Row Filter
Line Plot
Joiner
Line Plot
Line Plot
Country & year
Get last year's GDP for comparison
Lag Column
Country & year
Calculate absolute GDP increase/decrease
Expression
Column Filter
Sorter
Select ElectricityPercentTable
DB Table Selector (deprecated)
Read PopulationTable
DB Reader
GroupBy
Fetch mostrecent data2019-2024
Row Filter
Read ElectricityPercentTable
DB Reader
Select UnemploymentPercentTable
DB Table Selector (deprecated)
keep only the rows from your main GDP dataset that belong to those top 10 countries
Reference Row Filter
Column Filter
Calculate percentage GDP growth
Expression
Line Plot
Select PopulationTable
DB Table Selector (deprecated)
Top k Row Filter
Color Manager
Read RuralPopulationTable
DB Reader
Remove DuplicateCountry names &Country Codes
Duplicate Row Filter
Bar Chart
Read UnemploymentPercentTable
DB Reader
Joiner
Select RuralPopulationTable
DB Table Selector (deprecated)

Nodes

Extensions

Links