This data is from data.world, and can be found here. This includes educational and living costs for Europe in 2023. We then begin this analysis by needing to create a single merged dataset. GDP per capita come from the World Bank.
Here Python is used for cleaning and merging the datasets into only relevant data. Countries names are checked using a list comprehension, and values are adjusted by the average exchange rate of US dollars to UK pounds.
Tableau Dashboard Engineering
The merged dataset is then imported into tableau for data visualization. The main aim is to visualize and statistically analyze the countries total education costs and gdp per capita.
This shows the rankings of Europe by Tuition Fees. To gain a deeper understanding, GDP Per Capita and Living Costs are explored in a Geographic Analysis.
The coefficient is very high, indicating that a high percentage of the variance in total educational costs and living costs are determined by gdp per capita.
When living costs are controlled for, the coefficient decreases substantially, but remains positive and significant.
Tableau Dashboard
Below is the entire tableau dashboard for exploration.
Manzano Analytics: European Education Costs
Lessons Learned:
Tableau Dashboard Engineering
Tableau is a powerful tool for combining correlational analysis and geospatial visualizations,
and this project helped me refine my process for each. Illustrating the correlation between total
education costs and GDP per capita was straightforward, but condensing this information into a single
frame was essential. Leveraging Tableau's features, creating a cohesive dashboard through effective data
visualization techniques becomes more accessible.
Designing with Icons
To make the most appealing visuals possible, I imported custom icons of flags and matched each with
the correct country. Tableau allows for easy importing of custom icons, and this supports its popularity
with the data visualization community. The project highlights how attention to aesthetically pleasing design
elements enhances the impact and clarity of data visualization.
Python Data Wrangling
This project involved merging datasets from data.world and the World Bank, necessitating proficiency in Python data
manipulation. I defined a function for list comprehensions in order to easily check which countries
were different, and then changed the names where applicable. Utilizing list comprehensions and
function building streamlines and accelerates this process compared to other methods.
Archaelogical Site Analysis
A descriptive analysis of a Southeastern Kentucky Archaelogical site.
Every year, hospitals are faced with staffing challenges due to the influx of influenza patients. This prescriptive analysis uses USA CDC data and seeks to define and direct staff from low-need states to high-need states.