Posts

Showing posts from May, 2023

Petroleum Project

Image
 This is my first independent project after my completion of the Google Data Analytics course. Task For this project, I compared the petroleum prices of the top 5 most powerful nations in the world and the number of gallons of petroleum used daily. Ask First, I set out to answer two questions. First, what country had the highest daily use of petroleum in barrels, and which country had the highest petroleum price per gallon in USD. Process First I downloaded the dataset  here  dated June 20, 2022. I opened up the data set in Excel where I cleaned the data by limiting things such as the price to USD and taking out world shares as that wasn't what I wanted to see. After this was done I uploaded the data set into MYSQL to see what I could find out about the data. You can find my SQL queries  here  where I show you exactly what I typed and an explanation of what I was finding. Findings What I found was that the United States as of June 20,2022 the date on this data s...