An information retrieval platform for GDP, Life Satisfaction and Education Level
Question: when the company gives you a dataset to build a dashboard before the interview, what should you do?
Step1. Check the datasets, and understand the meaning of each column, I received two tables
Table 1. Copy of Life Satisfaction VS GDP Extract.csv
Columns: Country Code, Country, GDP per capita, Life satisfaction, Region, Year
Use a pivot table to check the range:
Table 2. Copy of Adult Education Extract.csv
Columns: Country code, Country, Education level, Proportion of population, Year
Use a pivot table to check the range:
So I have concluded that the datasets have
4 dimensions that I can use: Year, Region, Country, Education Level
3 measures that I can compare: GDP per capita, Life satisfaction, and Proportion of education level