Folders structure

01 Data Prep

01 Select

02 Clean & Merge

Open - prepared files for workbooks

Save - folder for saving Excel Power Query exercises

02 Workbooks

Open - prepared files

Wiew - .twbx - packaged workbooks

1-2-3 files - prepared workbooks to use if needed

Save - Folder for saving Tableau exercises

Prepared files for workbooks

Eurostat

Excel file: ESS - 4 relevant tables:

Housing_Tenure - aggregated data at country-level

• country
• year
• tenure
• pct

Severe_MD - aggregated data at country-level

• country
• year
• pct

GDP - aggregated data at country-level

• country
• year
• GDP

2018 GDP MD - aggregated data at country-level

• country
• year
• GDP
• Severe_MD_pct

ESS

Excel file: ESS - 2 relevant tables:

ESS_Happy_All - microdata, row = respondent, columns:

• country
• year
• happy
• income_deciles

ESS_Happy_Avg - aggregated happiness at country-level

• country
• year
• happy_avg
• n

HBSC

Excel file: HBSC - 2 relevant tables:

HBSC_Happy_All - microdata, row = respondent, columns:

• country
• year
• happy
• owns_bedroom
• n_computers

HBSC_Happy_Avg - aggregated happiness at country-level

• country
• year
• happy_avg
• n

Happiness_Combined

Excel file: Happiness_Combined - 2 relevant tables:

Combined Happiness - microdata, row = respondent, columns:

• country
• year
• happy

Combined Happiness Avg - aggregated happiness at country-level

• country
• year
• avg_happiness