Scribd
Upload
33 views1 page

Essential SQL Projects for Data Analysis

This document describes two free SQL projects that are useful for data analysts to include in their portfolios. The first project analyzes road safety in the UK using open datasets on road accidents, vehicles, and vehicle types. The goal is to evaluate accident severity and totals by vehicle type and motorcycle using SQL and Python. The second project analyzes world population data from the CIA World Factbook to answer questions about the countries with the highest, lowest, and fastest growing populations as well as population density. Both projects provide example questions and link to the source code on GitHub.

Uploaded by

Fãižął Qűŗeşhî
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
33 views1 page

Essential SQL Projects for Data Analysis

This document describes two free SQL projects that are useful for data analysts to include in their portfolios. The first project analyzes road safety in the UK using open datasets on road accidents, vehicles, and vehicle types. The goal is to evaluate accident severity and totals by vehicle type and motorcycle using SQL and Python. The second project analyzes world population data from the CIA World Factbook to answer questions about the countries with the highest, lowest, and fastest growing populations as well as population density. Both projects provide example questions and link to the source code on GitHub.

Uploaded by

Fãižął Qűŗeşhî
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

[Link]

com/ptyadana/SQL-Data-Analysis-and-Visualization-Projects

Let me tell you a 2 FREE SQL projects you must have in your portfolio to succeed in your data
journey.....

🎯𝗔𝗻𝗮𝗹𝘆𝘇𝗶𝗻𝗴 𝗥𝗼𝗮𝗱 𝗦𝗮𝗳𝗲𝘁𝘆 𝗶𝗻 𝘁𝗵𝗲 𝗨𝗞

𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗽𝗿𝗼𝗯𝗹𝗲𝗺:
The UK Department of Transport provides open datasets on road safety and casualties, and one can
use these datasets to analyze how safe the roads in the UK are. This project will help you answer a
few questions using their 2015 dataset.

The dataset has 3 tables i.e Accident, vehicle, Vehicle_type

𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵/𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗜𝗱𝗲𝗮
Use aggregate functions in SQL and Python to answer the following sample questions:
1. Evaluate the median severity value of accidents caused by various Motorcycles.
2. Evaluate Accident Severity and Total Accidents per Vehicle Type
3. Calculate the Average Severity by vehicle type.
4. Calculate the Average Severity and Total Accidents by Motorcycle.

Github source code link:


[Link]

🎯𝗔𝗻𝗮𝗹𝘆𝘇𝗶𝗻𝗴 𝘁𝗵𝗲 𝗪𝗼𝗿𝗹𝗱 𝗣𝗼𝗽𝘂𝗹𝗮𝘁𝗶𝗼𝗻


In this project, you will use the dataset by CIA World Factbook and explore how the world population
spreads across different countries.
The data has information from only 261 different countries.

Dataset contains 11 rows and 262 columns like id, code, area, population, birth_rate, death_rate,
migration_rate, population_growth.

𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵/𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗜𝗱𝗲𝗮
You will learn how to use SQL to answer the following analytical questions:
1. Which country has the highest population?
2. Which country has the least number of people?
3. Which country is witnessing the highest population growth?
4. Which country has an extraordinary number for the population?
5. Which is the most densely populated country in the world?

Master SQL Project :


[Link]

You might also like