Now that we have a made the desired edits to our raw dataset and have created new spreadsheets that display our changes, it is time to analyze our data. This is the crux of project. During our “Analysis” phase, we will use our data to develop the key insights which will help us answer the…
The first new column that we will add onto our sheets is meant to show the amount of time that each individual ride lasted for. We will call it “ride_length”, keeping with the naming convention found in the other columns. Specifically, we will continue to use an underscore to replace spaces in the titles of…
In the previous post, we deleted rows in our dataset that had data which was incomplete and couldn’t be used in our analysis. To continue the “Process” phase, we need to create the format in which we will want all of our spreadsheets to be in as we move forward. This means that now is…
Now that we have the data that we want to work with prepared, the next step is to process all of it into a form and format that will be appropriate for our analysis. To start the “Process” phase, we will want to clean up and remove any data that is incomplete or invalid to…
The next phase of the analysis is to prepare the data that will be used. Some important things to determine when conducting such analysis are the credibility of the data and if it is used under proper license. In reality, this is publicly available data collected by Motivate International, which Coursera compiled for the purposes…
The first phase of this analysis is to simply make sure we understand the question that we are being asked to answer, and to define a clear goal for the analysis. The company we work for in this scenario, Cyclistic, has had a marketing campaign that has been focused purely on making people aware of…
This case study is based off of a framework for one of the examples used in the Capstone Project for Coursera’s Google Data Analytics Certificate Course. It details a scenario where we, the students, are to pretend that we are a junior analyst at a Company called Cyclistic. This is a made-up company, but the…