For my case study I chose to do “Which country is the best to do business in?” as the research question.
Objective Phase:
To analyze which countries would be the best to invest in and do business there using a multiple of different metrics complied into one score. These countries were limited to countries in the EU or G20.
Prepare Phase:
Data was gathered from multiple sources.
Sources:
https://data.worldbank.org/country
https://en.wikipedia.org/wiki/List_of_countries_by_tertiary_education_attainment
https://research.stlouisfed.org/
Education and training monitor EU Commision
https://worldpopulationreview.com/country-rankings/literacy-rate-by-country
https://www.transparency.org/en/cpi/2019
Process Phase:
After gathering the data into Excel, the metrics were then added or subtracted into a single score(Total Score).
Analyze Phase:
The top countries were all westerns countries with the only two exceptions being Japan and South Korea.
Share Phase:
The data was then imported into Tableau to create visualizations.
https://public.tableau.com/views/GoogleCaseStudyVisualizations/TotalScoreRanked?:language=en-US&:display_count=n&:origin=viz_share_link
Act Phase:
A PowerPoint was made to summarize the findings.
This is one project I would like to come back to since it is very basic and there were a lot of things I wanted to do that I didn’t have time for. Hopefully I have time to come back to this project and do it how I originally planned.