Posts

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...
Post a Comment
Read more

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...
Post a Comment
Read more