Capstone Project - Cyclistic Ride Share Dashboard

To read the full project report, use the "Full Project Description" link:

Based on data through the Google Data Analytics Certificate course, the dashboard and attached deliverables compare the usage of bicycles from a fictional ride-share company in Chicago named Cyclistic. The data was obtained through a license from Motivate International Inc. and manipulated using Excel and SQL before being visualized in Tableau.

BACKGROUND:
Cyclistic is a fictional bike-share offering with over 5,824 bicycles in the Chicago area. They have over 600 stations in the area and have built a client base by marketing to broad consumer segments and offering a variety of bike styles to accommodate all riders. Casual riders in the system purchase either single or full day passes while members hold annual passes. The finance analysts have discovered that annual members are more profitable than casual riders and wish to increase the number of members.

Through this project, I was able to:
-Convert CSV files in Excel to perform data cleaning and preparation for analysis
-Utilize SQL to perform analysis on over 1,000,000 rows of data
-Design an interactive report in Tableau to describe differences in the target population

Questions I answered with the data included:
-How do member riders and casual riders use Cyclistic bikes differently?
-Why would casual riders buy Cyclistic memberships?
-How can Cyclistic market to casual riders to encourage them to buy memberships?