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