Power BI project -
World happiness Report data analysis
First step is to collect data. I downloaded, filtered and cleaned 10 datasets from https://worldhappiness.report/data/ representing each year from 2013 - 2022 I finally joined them into Happiness 2013-2022 table using Power Query.
I created two additional tables Median_age and Sunshine_hours using DAX. I find interesting to observe wheter age of the population or amount of sunshine affects happiness score of the country. Data for the tables are scraped from Wikipedia.
Finally I created a central Countries table using Region/Subregion/Country hierarchy. The table is connected to all other table via N:1 cardinality.
Interactive part of the report is represented by two slicers where filtering certain country, region or period is possible. A panel with 8 cards displays values for every variable recorded.
Finally, I created three charts. Each display top 5 countries in terms of Generosity, Freedom to make live choices and perceptions of corruption. Unexpected countries scoring this high re highlited by distinct colour. Moreover, I added textboxes to each, asking why is such score possible and enabling you to redirect to web article explaining conditions that led to succes of those countries.
Next page is seeking correlations between variables observed. If so, it focuses on outlying countries. Textboxes are trying to explain this outliers. You can use them to redirect to web articles and dive deeper or click on bookmark bellow and see the data of the certain country.
On the last page, I focus on the Balkans region and asking the question whether global perspective observatios do necesarily work on the regional one. I am highlitening data for two of the least developed countries of the region - Kosovo and Moldova. Data suprisingly show those two countries being among the happiest of the region.
Finally, I am trying to sugest reasons why Kosovo scores relatively high in happiness compared to level of the development. Panes can redirect you to the source articles or you can click on the bookmark to see the report data about the country.
