thenewmdf.blogg.se

Data analytics capstone projects gihub excel tableau
Data analytics capstone projects gihub excel tableau












# ,end_station_id = "02 - Rental End Station ID" # ,end_station_name = "02 - Rental End Station Name"

data analytics capstone projects gihub excel tableau

# ,start_station_id = "03 - Rental Start Station ID"

data analytics capstone projects gihub excel tableau data analytics capstone projects gihub excel tableau

# ,start_station_name = "03 - Rental Start Station Name" # ,ended_at = "01 - Rental Details Local End Time" # ,started_at = "01 - Rental Details Local Start Time" # ,rideable_type = "01 - Rental Details Bike ID" # ,ride_id = "01 - Rental Details Rental ID" (How do annual members and casual riders use Cyclistic bikes differently?) Prepareĭata is obtained from for period October 2021 to September 2022 Load Libraries This Analysis will focus on the first question. How can Cyclistic use digital media to influence casual riders to become members? Objectives Why would casual riders buy Cyclistic annual memberships? 3. How do annual members and casual riders use Cyclistic bikes differently? 2. Three questions will guide the future marketing program: 1. Moreno and her team are interested in analyzing the Cyclistic historical bike trip data to identify trends Ask To do that, however, the marketing analyst team needs to better understand how annual members and casual riders differ, why casual riders would buy a membership, and how digital media could affect their marketing tactics. She notes that casual riders are already aware of the Cyclistic program and have chosen Cyclistic for their mobility needs Goalsĭesign marketing strategies aimed at converting casual riders into annual members. Rather than creating a marketing campaign that targets all-new customers, Moreno believes there is a very good chance to convert casual riders into members. Although the pricing flexibility helps Cyclistic attract more customers, Moreno(director of marketing) believes that maximizing the number of annual members will be key to future growth.

data analytics capstone projects gihub excel tableau

Customers who purchase annual memberships are Cyclistic members.Ĭyclistic' s finance analysts have concluded that annual members are much more profitable than casual riders. Customers who purchase single-ride or full-day passes are referred to as casual riders. One approach that helped make these things possible was the flexibility of its pricing plans: single-ride passes, full-day passes, and annual memberships. Until now, Cyclistic' s marketing strategy relied on building general awareness and appealing to broad consumer segments. The bikes can be unlocked from one station and returned to any other station in the system anytime. Since then, the program has grown to a fleet of 5,824 bicycles that are geotracked and locked into a network of 692 stations across Chicago. In 2016, Cyclistic launched a successful bike-share offering. The program prepares participants for a career in data analytics with training focused on key analytical skills (data cleaning, analysis, and visualization) and tools (Excel, SQL, R Programming, Tableau) This project is the capstone assignment for the Google Data Analytics Professional Certificate program.














Data analytics capstone projects gihub excel tableau