My First Engagement with a SQL project; thoroughly enjoyed it and I’m continuing to enjoy the hands-on teaching strategy of the Dataquest platform
Guided Project - Analyzing CIA Factbook Data Using SQL.ipynb (36.8 KB)
Click here to view the jupyter notebook file in a new tab
Hi @jweekes13! Thanks for sharing your project with the Community! I’m glad that you enjoyed doing it
I have a few comments on how to improve the project:
- Paraphrase the introduction as it’s copied from DataQuest. It’s a good way to practice because at some point you’ll have to create original content
- Have a list of questions you want to tackle right at the beginning so we know what you are curious about
- SQL queries are not right-aligned, it’s better to do it as it’s more appealing to the eye and follows SQL style guidelines
- You have an SQL error in the “Summary Statistics” section
- Make a comment about Antarctica
- As far as I remember, there are countries like European Union. Have you checked that these do not have any impact on the average population/area calculations?
- What do you consider a “developed world”? I’d say it’s 50/50 in the values of lower than average area and higher than average population
- You have some typos, so correct them
- You may try excluding outliers like BIOT and Virgin Islands and see what are the countries with the highest water-to-land ratio
- Are you sure that India will add more than 1.5 billion people next year? It’s in the section " Which countries will add the most people to their population next year?"
- You can also exclude micro-states and see what countries have the highest population density
I hope I was helpful, happy coding
Thanks a lot for the feedback! I will be sure to apply the comments for improvements.