PURPOSE
How do social development and cultural values differ across Australia, Canada, France, Russia, and Saudi Arabia? This activity will help you utilize Power Query to clean, transform, and analyze social and cultural data, supporting your work in the Drafting Phase of the Infographic Design Team Project by allowing you to explore how a country’s social development, as measured by the Human Development Index (HDI), is influenced by cultural values, as reflected in Hofstede’s Six Cultural Dimensions, to uncover meaningful correlations and insights for policy-making and development outcomes.
TASK
Use Power Query to clean and prepare datasets on social factors (e.g., education levels) and cultural factors (e.g., cultural values) for analysis.
Submit an Excel file with your Power Query transformation showing Australia, Canada, France, Russia, and Saudi Arabia.
Readings & Resources
https://hdr.undp.org/data-center/documentation-and-downloadshttps://geerthofstede.com/research-and-vsm/dimensi…https://learn.microsoft.com/en-us/power-query/