Petroleum Project

 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 set the United States has the highest daily oil consumption coming in at 19,687,287.  I also found out that the United Kingdom has the highest price per gallon in (USD) at $8.38 per gallon 
Link to Dashboard click here

What I've learned
  • How to use MYSQL to aggregate data.
  • How to create visuals using Tableau
  • Lastly, I've learned how to upload my SQL into Github


Comments

Post a Comment

Popular posts from this blog

Google Capstone Project

Image
This is a detailed article explaining the steps I took and the conclusions I came to for this capstone project. Scenario      For this project, I'm a junior data analyst for a fictional company called "Cyclistic", a bike-share company in Chicago. I've been given the task of figuring out how annual members and casual riders use Cyclistic bikes differently and design a new marketing strategy to convert casual riders into annual members. Ask In this step, I asked myself the question “How do annual members and casual riders use Cyclistic bikes differently?” It’s believed that annual members are more profitable than casual riders. My task was to analyze the data to find the difference between casual riders and members and then provide recommendations to convert casual riders into annual riders. Prepare To prepare I downloaded the data for this case study. I downloaded the trip data from Q2-Q4 of 2019 and Q1 of 2020 from here . Process For this step, I combined and uploaded...
Read more