{"id":11,"date":"2022-11-10T09:56:48","date_gmt":"2022-11-10T09:56:48","guid":{"rendered":"https:\/\/dcarr-projects.com\/?page_id=11"},"modified":"2022-12-27T07:57:48","modified_gmt":"2022-12-27T07:57:48","slug":"cyclistic-2021-case-study","status":"publish","type":"page","link":"https:\/\/dcarr-projects.com\/index.php\/cyclistic-2021-case-study\/","title":{"rendered":"Cyclistic 2021 Case Study"},"content":{"rendered":"\n<p>This case study is based off of one of the&nbsp;assigned examples used in the Capstone Project for Coursera\u2019s Google Data Analytics Certificate Course. It details a scenario where we, the students, pretend that we are junior analysts at a company called Cyclistic. This is a made-up company, but the data used is from a real bike-sharing and urban service company called Motivate International Inc. Using the publicly released data of one of Motivate International\u2019s bike-sharing&nbsp; service areas, we can act as if this is the data collected by our fictional company, Cyclistic.&nbsp;<\/p>\n\n\n\n<p>Linked below are all of the individual steps that I took to complete this analysis.  You can begin at the Introduction page to get a better understanding of the project and it&#8217;s goals.<\/p>\n\n\n\n<p> There will be buttons at the bottom of each page to bring you to either the next step in the analysis, the previous step, or back here to the project&#8217;s main page. <\/p>\n\n\n\n<p>If you would like to skip to the results, you can click the link at the bottom of the page called &#8220;PowerPoint Presentation&#8221;. You can also view some of the visualizations made with Tableau by clicking the link titled &#8220;Tableau Worksheets&#8221;.<\/p>\n\n\n\n<ul class=\"has-medium-font-size\"><li><a href=\"https:\/\/dcarr-projects.com\/?p=13\" title=\"Introduction \"><strong><span style=\"text-decoration: underline;\">Introduction<\/span><\/strong> <\/a><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=15\" title=\"Ask Phase\">Ask Phase<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=19\" title=\"Prepare Phase\">Prepare Phase<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=22\" title=\"Process Phase\">Process Phase<\/a><\/span><\/strong><ul><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=24\" title=\"Creating a Format\">Creating a Format<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=34\" title=\"Adding Ride Length\">Adding Ride Length<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=38\" title=\"Using R\">Using R<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=40\" title=\"Baseline: Version 2\">Baseline: Version 2<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=51\" title=\"Day of Week\">Day of Week<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=56\" title=\"Trip Distance\">Trip Distance<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=64\" title=\"Downloading New Sheets\">Downloading New Sheets<\/a><\/span><\/strong><\/li><\/ul><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=69\" title=\"Analysis Phase\">Analysis Phase<\/a><\/span><\/strong><ul><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=74\" title=\"Datatypes in SQL\">Datatypes in SQL<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=78\" title=\"Making Queries\">Making Queries<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=86\" title=\"SQL Insights\">SQL Insights<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=90\" title=\"Max and Mean in SQL\">Max and Mean in SQL<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=102\" title=\"Mode and Expanding Queries\">Mode and Expanding Queries<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=217\" title=\"Creating a Summary Sheet\">Creating a Summary Sheet<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=226\" title=\"Importing Data into R\">Importing Data into R<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=236\" title=\"Data Visualization: GGPlot2\">Data Visualization: GGPlot2<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=254\" title=\"Improving our Graph in GGPlot2\">Improving our Graph in GGPlot2<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=264\" title=\"Perfecting Our Graph\">Perfecting Our Graph<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=284\" title=\"Selecting Visualizations from R\">Selecting Visualizations from R<\/a><\/span><\/strong><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=301\" title=\"Tableau\">Tableau<\/a><\/span><\/strong><\/li><\/ul><\/li><li><strong><span style=\"text-decoration: underline;\"><a href=\"https:\/\/dcarr-projects.com\/?p=325\" title=\"The Share and Act Phases\">The Share and Act Phases<\/a><\/span><\/strong><\/li><\/ul>\n\n\n\n<p class=\"has-medium-font-size\"><strong><span style=\"text-decoration: underline;\"><a href=\"http:\/\/dcarr-projects.com\/wp-content\/uploads\/2022\/11\/Cyclisitc-Rider-Data-for-2021.pptx\" title=\"PowerPoint Presentation\">PowerPoint Presentation<\/a><\/span><\/strong><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong><a href=\"https:\/\/public.tableau.com\/app\/profile\/dean.carr\/viz\/CyclisticCaseStudy2021\/PopularDaysMembersVsCasuals\" title=\"Tableau Worksheets\">Tableau Worksheets<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This case study is based off of one of the&nbsp;assigned examples used in the Capstone Project for Coursera\u2019s Google Data Analytics Certificate Course. It details a scenario where we, the students, pretend that we are junior analysts at a company called Cyclistic. This is a made-up company, but the data used is from a real&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/dcarr-projects.com\/index.php\/wp-json\/wp\/v2\/pages\/11"}],"collection":[{"href":"https:\/\/dcarr-projects.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dcarr-projects.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dcarr-projects.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dcarr-projects.com\/index.php\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":36,"href":"https:\/\/dcarr-projects.com\/index.php\/wp-json\/wp\/v2\/pages\/11\/revisions"}],"predecessor-version":[{"id":447,"href":"https:\/\/dcarr-projects.com\/index.php\/wp-json\/wp\/v2\/pages\/11\/revisions\/447"}],"wp:attachment":[{"href":"https:\/\/dcarr-projects.com\/index.php\/wp-json\/wp\/v2\/media?parent=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}