Embedded Files
Overview
Overview
Cyclistic is a fictional bike-sharing company based in Chicago, IL. Its customers can check out and drop off bikes at any of their multiple stations across the city!
Business Questions
Business Questions
How do annual members and casual riders use Cyclistic bikes differently?
How should Cyclistic approach digital marketing as a result of the differences between riders?
About the dataset
About the dataset
Data records individual trip records for 2021
Contains 5,595,063 rows of data
Contains 13 unique attributes (columns)
Tools Used
Tools Used
Google Cloud to store the data
SQL inside BigQuery to perform my analysis
Kaggle to document and share my code and thought process
Tableau to create visualizations of my queries
Google Sheets to present the information to the stakeholders
Steps Taken
Steps Taken
Uploaded 12 .csv files (one for each month) into Google Cloud bucket
In BigQuery, I created a dataset using all 12 files to make 1 table.
I renamed this table "2021_original"
I created a duplicate table for the cleaning process.
This file is called "2021_cleaned"
I queried the dataset using the duplicate table, in case there were any errors, I could always go back to the original
Click here to view the code on Kaggle
After querying the data, I exported the data to Tableau to visualize it
After creating captivating visuals, I created a slide deck to share with key stakeholders to communicate my findings and advice!
View the Slide Deck
View the Slide Deck
Page updated
Google Sites
Report abuse