This is my entry for the #may 2022 challenge by onyx data
For this challenge we analyzed the Nobel prize winners dataset from 1901 - 2019
For my analysis I used Microsoft SQL Server and Microsoft Power BI
I queried the dataset for the following information:
- country of birth with most award won in each category
- laureates total prize's won and list of categories
- universities and total prize won
- total number of laureates
- total number of winners in each category
- first prize winners in each category
- recent prize winners in each category
- gender distribution in each category
I did some data cleaning on the dataset,
Did some data modelling
And I created an interactive dashboard.
first look at the dashboard represent the entire information from 1901 - 2019 and from all 6 categories
when filtered by chemistry category, the dashboard would represent all information from 1901 - 2019 for chemistry category alone.
This project was fun and I gained a lot of knowledge working on something with no prior information unlike my previous projects where I get to watch tutorials.