In this project I analyze and design marketing strategies aimed at converting casual riders into annual members using real-world data provided by a bike-sharing company in Chicago.

• The final Cyclistic data analysis presentation is available at Google Slides.
• Documentation of Data Cleaning & Manipulation Using SQL.
• Documentation of Analyzing Data to Answer Questions Using SQL.
• Further analysis was done in Tableau Public and can be viewed at Cyclistic Data Analysis Tableau project.

• Promote using bicycles for work commutes and other repeating trips.
• Encourage using bicycles for short convenience trips.
• Launch campaigns in Spring, Summer, and on weekends when casual riders are most active.

• Launch digital media campaign based on given recommendations.
• Collect digital media campaign data for measuring the effects on conversion to membership.

• Case Study Power-Point Presentation

• Case Study: Design Strategies for Bike-share company to navigate speedy success

• Phase 3: Process
• Phase 4: Analyze

Tableau, SQL, Microsoft Excel, ...