google data analytics capstone project solution

• Oct 18, 2021
• 10 min read

Google Data Analytics Capstone Project

Updated: Jul 5, 2023

I worked on the Google Data Analytics Capstone Project, Track 1, Case Study 1. I will be diving into the background, my full process of cleaning, analyzing and visualizing the data, along with my final suggestions and summary of the data.

Quick Links :

Tableau Dashboard | Github R Code for Analysis | Github R Code for Tableau Visualization | LinkedIn Post

Below is a table of contents in case you want to go to a specific section.

Table of Contents:

Microsoft excel.

Finished Project

Summary of Data

Business Suggestions

What I Learned

Cyclistic is a bike sharing program which features more than 5,800 bikes and 600 docking stations. It offers reclining bikes, hand tricycles, and cargo bikes, making it more inclusive to people with disabilities and riders who can't use a standard two-wheeled bike. It was founded in 2016 and has grown tremendously into a fleet of bicycles that are geotracked and locked into a network of 692 stations across Chicago. The bikes can be unlocked from one station and returned to any other station in the system anytime.

Previously, Cyclistic's marketing strategy tried to build the general awareness and appeal to broad consumers. It has flexible pricing plans: single-ride passes, full-day passes, and annual memberships. Those who purchase single-ride or full-day passes are referred to as casual riders while those who purchase annual memberships are Cyclistic members .

My Role : In this scenario I am a junior data analyst at Cyclistic and my team has been tasked with the overall goal (see below) of designing marketing strategies

Overall Goal : Design marketing strategies aimed at converting casual riders into annual members.

Business Question : "How do annual members and casual riders use Cyclistic bikes differently?"

Below I will describe step-by-step the process I used to for this project. If you want to skip ahead to the business suggestions move onto the section "Insights".

Overview : I first analyzed the data separately (each month) in Excel, then used R to analyze the data as a whole (one year). Finally I created a dashboard in Tableau and used Figma to support the design elements.

I initially wanted to gather and analyze my data in Excel because it was the tool I was most familiar with and I could get a general understanding of the data quicker. I did not combine all of the spreadsheets into one because that would've taken more processing power than my computer had.

I began downloading the data from divvy-tripdata , and turning the .csv files into excel spreadsheets. I downloaded the most recent year of data which was at the time of starting my project:

August 2020

September 2020

October 2020

November 2020

December 2020

January 2021

February 2021

Added two columns to all of the months:

ride_length calculated the total ride length for each trip using the start_at column which was: ending time minus starting time.

day_of_week calculated the day of the week for each trip using the start_at column date.

Went over the business task and the information I had at hand and how that could be used to figure out how members and casual riders use the bike service differently

Came up with metrics to look at such as :

total number of rides per hour, per day of the month, per season, per day of the week, and for different bike types

Average ride length between members and casual

For every month in Excel created pivot tables and charts to go with the analysis on (this took the longest):

Total Rides per Weekday - calculated the total rides for members and casual and separated it by day of the week; used a cluster column chart

Average Ride Length - calculated the average ride length for members and casual and separated it by day of the week; used a cluster column chart

Total Rides per Hour - calculated the total rides for members and casual separated by the time of the day (24hr); used a line comparison chart

Total Rides per Day - calculated the total rides for members and casual separated by the day of the month; used a line comparison chart

Total Rides per Bike Type - calculated the total rides for members and casual separated by Bike type; used stacked column chart

I also created a Google docs Notes list where I wrote down the exact steps for each month (had a checklist) and included my insights for each month

Time Spent:

535 minutes or just under 9 hours to complete.

I originally wanted to use SQL but the files were too big to upload and I couldn't figure out how to utilize Google Cloud Platform. Instead I used R to analyze the data because it could handle all of the information quicker than Excel, and I wanted to work on my R skills. Below is my general process in R, I didn't include my mistakes/missteps or errors for the sake of brevity.

View my full code on my Github for this capstone project here .

Load all of the libraries I used: tidyverse, lubridate, hms, data.table

Uploaded all of the original data from the data source divytrip into R using read_csv function to upload all individual csv files and save them in separate data frames. For august 2020 data I saved it into aug08_df, september 2020 to sep09_df and so on.

Merged the 12 months of data together using rbind to create a one year view

Created a new data frame called cyclistic_date that would contain all of my new columns

Created new columns for:

Ride Length - did this by subtracting end_at time from start_at time

Day of the Week

Time - convert the time to HH:MM:SS format

Season - Spring, Summer, Winter or Fall

Time of Day - Night, Morning, Afternoon or Evening

Cleaned the data by:

Removing duplicate rows

Remove rows with NA values (blank rows)

Remove where ride_length is 0 or negative (ride_length should be a positive number)

Remove unnecessary columns: ride_id, start_station_id, end_station_id, start_lat, start_long, end_lat, end_lng

Calculated Total Rides for:

Total number of rides which was just the row count = 4,152,139

Member type - casual riders vs. annual members

Type of Bike - classic vs docked vs electric; separated by member type and total rides for each bike type

Hour - separated by member type and total rides for each hour in a day

Time of Day - separated by member type and total rides for each time of day (morning, afternoon, evening, night)

Day of the Week - separated by member type and total rides for each day of the week

Day of the Month - separated by member type and total rides for each day of the month

Month - separated by member type and total rides for each month

Season - separated by member type and total rides for each season (spring, summer, fall, winter)

Calculated Average Ride Length for:

Total average ride length

Type of Bike - separated by member type and average ride length for each bike type

Hour - separated by member type and average ride length for each hour in a day

Time of Day - separated by member type and average ride length for each time of day (morning, afternoon, evening, night)

Day of the Week - separated by member type and average ride length for each day of the week

Day of the Month - separated by member type and average ride length for each day of the month

Month - separated by member type and average ride length for each month

Season - separated by member type and average ride lengths for each season (spring, summer, fall, winter)

Then using all of this data I created my own summary in my case notes and took note of the: total rides for each variable, average ride lengths for each variable, and the difference between members versus casual riders. I originally wanted to create a report using R Markdown as well but for the sake of time (I had already spent over 20 hours on the project so far), I decided to skip this step, and write this article instead.

1045 minutes or about 17 and a half hours to complete.

While I learned the basics of Tableau in the Google Course I wanted more practice with visualizing data and creating dashboards.

To view my completed dashboard click here .

I created a separate R code (you can view it here on Github) that made some changes for specifically the Tableau portion.

For ride length I rounded the digits by 1, meaning my numbers were 29.8 or 12.5.

Revised how I created my "month" column. I used mutate() to create a column that had the month in ___ format and not number format. So instead of 01 it would say "January"

Cleaned the data: removed rows with NA values, removed duplicate rows, removed where ride_length was 0 or negative and removed unnecessary columns like: ride_id, start_station_id, end_station_id, start_lat, start_long, end_lat, end_lng

Created a new dataframe with this information so I could test the difference between the original data frame (cyclistic_date) that I used for my analysis and the data frame I would use for Tableau (cyclistic_tableau).

In this new data frame I removed more columns to make calculations quicker in Tableau. I removed: start_station_name, end_station_name, time, started_at, ended_at

Downloaded this data frame into a .csv file which I uploaded to Tableau

Created graphs similar to those I created in Excel but added a few:

Total Rides by Bike Type

Ride Length by Weekday

Total Rides by Weekday

Total rides by hour, total rides by month.

Then I created a basic dashboard with all of that information, a prototype for me to view while I was creating the final dashboard ( Figure 1 below).

Created a prototype mockup in Figma

Created a final version of the mockup in Figma

Edited Dashboard in Tableau to reflect design in Figma

Edited graphs in Tableau

Made bar graphs round

Added annotations

Highlights to specific important notes

Got rid of labels for visual purposes

Combined Figma and Tableau (used dashboard created in Figma as the background for my Tableau Dashboard) to create a final prototype ( Figure 2 below)

Made minor edits to design elements and created final dashboard ( Figure 3 - Cyclistic Dashboard V1 )

On April 24, 2023 I decided to update my dashboard (See Finished Project , image Final Dashboard - Cyclistic Dashboard V2 ). All of the analysis is the same. The only changes have been to the dashboard. Which include:

Adding horizontal grid lines to a few of the charts

Updating the tool tips.

Making all of the top metric values (e.g. Total Rides, Average Ride Length, etc.) interactive in Tableau instead of in Figma.

765 minutes or almost 13 hours to complete.

Tableau Prototype

Below was my first draft of the dashboard only using Tableau.

Prototype using Figma Background

Combined Figma and Tableau (used dashboard created in Figma as the background for my Tableau Dashboard) to create a final prototype.

Final Dashboard V1

Made minor edits to design elements and created final dashboard. This was the original final dashboard.

I am including the other tools I used.

Figma to create my background and help develop the dashboard aesthetics.

Google Docs helped me keep track of all of my documents for this project like:

Date Log - I wrote down what I did that day related to my project

Resources - A list of resources I frequently used

Case Notes - Notes for the case study including the final insights, what I was looking for, and anything else having to do with the case

Evernote to draft this article before I uploaded it here.

FINISHED PROJECT

Here is my finished project: Google Capstone Project (V2) . You can view the links to my R code on Github used for analysis here and the code for Tableau here .

Note: This is V2 with a few minor changes to the dashboard. Including:

SUMMARY OF DATA

Those who purchase single-ride or full-day passes are referred to as casual riders while those who purchase annual memberships are Cyclistic members .

Total Rides by User Type

Average Ride Length per User Type

Average Ride per Weekday

Members had more rides with 2,328,763 total rides or 56% and casual riders had 1,823,376 total rides or 43%.

Total Rides per Bike Type

Both casual riders and members used the classic bike the most with 1,777,593 rides or 43% of total rides, followed by docked bikes with 1,545,936 rides or 37% of total rides, and lastly with electric bikes at 828,610 rides or 20% of total rides.

Average Ride Length by User Type

The total average ride length was 24 minutes. For casual riders it was longer at 27 minutes while members was 14 minutes.

Average Ride Length per Weekday

For the average ride length per weekday both casual riders and members had an increase in the average ride length on the weekends. For both Sunday was the longest at 31 minutes.

Saturday was the most popular weekday combining casual riders and member rides with 784,239 rides or 19% of total rides. But for member rides only Wednesday was the most popular day with 356,060 rides, 5,407 rides more than Saturday.

5PM or 17:00 was the busiest hour for both members and casual riders with 426,685 rides or 10% of the total rides. Typically rides began increasing in the morning at 6AM and rose until 5PM then dropped afterwards. The afternoon was the busiest for both rider types with 1,905,797 rides or 45% of total rides. 4AM was the least popular hour.

July was the busiest month combining casual riders and member rides at 691,476 rides or 16% of total rides. While summer was the most popular season for both at 1,903,446 rides or 46% of total rides. Looking at just members August is actually the busiest month with 323,140 rides, 816 rides more than July. Winter is the least popular season and February is the least popular month.

Final Summary

The most popular bike among with riders was the classic.

Busiest time was afternoon and the peak time was at 5PM for both casual riders and members.

Busiest weekday was Saturday, casual riders used the service the most on the weekends.

Busiest season was Summer for both types of riders.

Most rides by User Type was members but casual riders weren't far behind.

The average ride length was 24 minutes but casual riders on average rode 23 minutes longer than members.

BUSINESS SUGGESTIONS

This was the hardest part for me for the whole project. I have never provided suggestions for a business nor worked in marketing. Any feedback here would be appreciated.

These are my suggestions for the marketing team to convert casual riders to annual members:

Personalize discounts and show perks in the membership program based on their preferences and riding habits.

Emphasize the benefits of memberships, including discounts during busy times of the year like during Summer, or on the weekends.

Have existing members to share their stories about how using Cyclistic's system has changed their life, to create a sense of community, offer a discount if they do so this will help encourage new riders to join the program.

WHAT I LEARNED

Below is what I learned/practiced from over 40 hours spent on this project:

Pivot Tables in Microsoft Excel

Practice using R for data analysis and cleaning specifically using the tidyverse package for data analysis

Graphs in Tableau, edited visual elements along with creating different charts and filters.

Design elements of an effective dashboard

Combining the design feature of Figma with the functionality of Tableau

R portion of my project I found Itamar's case study on Kaggle using R as well, a helpful resource.

Tableau portion I used Navneet Singh's Tableau Dashboard as inspiration.

• Data Analytics
• Portfolio Projects

Recent Posts

The Power of Collaborative Projects in Data Analytics

Deep Work Dashboard 2023

Behind the Scenes: Creating a SQL Course

Wow Kelly. This really is impressive. Glad to see you are really into this process. You have definitely found your niche!!

Here to help you grow

Whether you're looking to build your business, develop your career, or pick up a new digital skill, we can help you get started.

What can we help you with?

And what would you like to do?

• Show me everything
• Prepare for a new job
• Develop communication skills
• Increase my productivity
• Learn about digital marketing
• Learn coding & development skills
• Get started with artificial intelligence
• Get started with cloud computing
• Stay safe online
• Learn design skills
• Improve my digital wellbeing
• Champion diversity
• Learn about sustainability
• Understand my audience
• Start selling online
• Expand internationally
• Keep my business safe online

Grow your career

Whether you're writing your first CV or deepening your technical knowledge, our library is full of ways to sharpen your digital skillset.

Google Career Certificates

Earn a Google Career Certificate to prepare for a job in a high-growth field like Data Analytics, UX Design, and more.

Introductory digital skills courses

Get started with a range of digital skills, with entry level courses in everything from online marketing to coding.

Cloud computing fundamentals

From intro to advanced-level learning, find out more about cloud computing principles and career paths.

Google product trainings

Learn how to get the most out of the Google products you use, like Google Ads or Analytics.

Grow your business

From bringing your business online for the first time to growing its reach internationally, our library of online learning and tools can help you take your business further.

Your Digital Essentials Guide

Get an introduction to the products, tools and tips that can help you build an online presence for your small business.

Flexible online training

Learn online, at your own pace, with a library of training made to help strengthen your business with digital skills.

Resources for startups

Google for Startups connects you to the right people, products and best practices to help your business thrive.

Helpful tools for small business owners

Google Business Profile

Manage how your business shows up on Google Search and Maps to help new customers find you more easily.

Market Finder

Identify new potential markets and start selling to customers at home and around the world.

Growth stories

Meet people all over Europe who are using technology to adapt and grow their business or career.

About Grow with Google

Grow with Google is a programme that helps people to grow their careers or businesses by learning new skills and making the most of digital tools. We partner with governments and local organisations to develop digital skills and tools where they are needed most.

• Jobs Search
• _Fresher Jobs
• _By Industry
• __Engineering Jobs
• __Sales Jobs
• __Banking Jobs
• Career Tips
• _Cover Letter

Google Data Analytics Capstone

 Are you ready to dive into the realm of data analytics with one of the most prestigious names in the tech industry? 

Advertisement

Look no further than the Google Data Analytics Capstone course, offered through Coursera. This comprehensive program is designed to equip you with the skills and knowledge needed to excel in the dynamic field of data analysis.

Understanding the Course

The Google Data Analytics Capstone course is the culmination of the Google Data Analytics Professional Certificate program, which offers a series of courses covering essential topics in data analysis. This capstone project serves as the final step in demonstrating your mastery of the concepts learned throughout the program.

What You'll Learn

Through this course, you'll gain hands-on experience with real-world data analysis projects. You'll learn how to:

Apply Data Analytics Techniques: Dive deep into data analysis methodologies and techniques used by industry professionals.

Utilize Google Tools: Harness the power of Google Sheets, Google Data Studio, and other Google tools to analyze data effectively.

Solve Real-World Problems: Tackle real-life data challenges and develop practical solutions using your newfound skills.

Present Insights: Master the art of presenting data insights in a clear and compelling manner to stakeholders.

Why Choose This Course?

Industry-Relevant Curriculum: Developed in collaboration with Google, this course offers a curriculum that is directly aligned with industry standards and best practices.

Hands-On Learning: Dive into real-world projects and gain practical experience that will prepare you for success in the field.

Flexibility: With Coursera's online platform, you can learn at your own pace and on your own schedule, making it ideal for busy professionals or students.

Certification: Upon successful completion of the course, you'll receive a certificate from Google, validating your skills and expertise in data analytics.

Who Should Enroll?

Whether you're a seasoned data professional looking to upskill or someone completely new to the field, this course is designed for anyone interested in mastering the art of data analysis. Whether you're a business analyst, data scientist, marketer, or entrepreneur, the skills learned in this course are invaluable in today's data-driven world.

The Google Data Analytics Capstone course offers a unique opportunity to gain practical experience and expertise in data analysis under the guidance of one of the most innovative companies in the world. With a focus on real-world projects and industry-relevant skills, this course is your gateway to unlocking endless possibilities in the field of data analytics. Enroll today and embark on your journey to becoming a data analysis master.

Post a Comment

Contact form.

• Top Courses
• Online Degrees
• Find your New Career
• Join for Free

IBM Data Analyst Capstone Project

This course is part of IBM Data Analyst Professional Certificate

Taught in English

Some content may not be translated

Instructors: Rav Ahuja +1 more

Instructors

Instructor ratings.

We asked all learners to give feedback on our instructors based on the quality of their teaching style.

Financial aid available

53,064 already enrolled

(1,058 reviews)

Recommended experience

Intermediate level

It is highly recommend that you have completed all of the courses in the IBM Data Analyst Professional Certificate prior to starting this course.

What you'll learn

Apply different techniques to collect and wrangle data

Showcase your Data Analysis and Visualization skills

Create a data analysis report and a compelling presentation

Demonstrate proficiency with various Python Libraries

Skills you'll gain

• Data Analysis
• Python Programming

Data Visualization

• SQL and RDBMS

Details to know

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Build your Data Analysis expertise

• Learn new concepts from industry experts
• Gain a foundational understanding of a subject or tool
• Develop job-relevant skills with hands-on projects
• Earn a shareable career certificate from IBM

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 6 modules in this course

By completing this final capstone project you will apply various Data Analytics skills and techniques that you have learned as part of the previous courses in the IBM Data Analyst Professional Certificate. You will assume the role of an Associate Data Analyst who has recently joined the organization and be presented with a business challenge that requires data analysis to be performed on real-world datasets.

You will perform the various tasks that professional data analysts do as part of their jobs, including: - Data collection from multiple sources - Data wrangling and data preparation - Exploratory data analysis - Statistical analysis and data mining - Data visualization with different charts and plots, and - Interactive dashboard creation. The project will culminate with a presentation of your data analysis report for various stakeholders in the organization. The report will include an executive summary, your analysis, and a conclusion. You will be assessed on both your work for the various stages in the Data Analysis process, as well as the final deliverable. As part of this project you will demonstrate your proficiency with using Jupyter Notebooks, SQL, Relational Databases (RDBMS), Business Intelligence (BI) tools like Cognos, and Python Libraries such as Pandas, Numpy, Scikit-learn, Scipy, Matplotlib, Seaborn and others. This project is a great addition to your portfolio and an opportunity to showcase your Data Analytics skills to prospective employers.

Data Collection

Data Collection is the first step in solving any analysis problem and can be collected in many formats and from many sources. In the first module of the Capstone, we will collect data by scraping the internet and using web APIs.

What's included

1 video 2 readings 3 quizzes 5 app items 2 plugins

1 video • Total 3 minutes

• Course Introduction • 3 minutes • Preview module

2 readings • Total 7 minutes

• Introduction To Capstone Project • 5 minutes
• Syllabus • 2 minutes

3 quizzes • Total 24 minutes

• Graded Quiz: Collecting Data • 9 minutes
• Graded Quiz: Web Scraping • 6 minutes
• Graded Quiz: Exploring Data • 9 minutes

5 app items • Total 300 minutes

• (Optional) Hands-on Lab 1: Review Of Accessing APIs • 60 minutes
• Hands-on Lab 2: Collecting Data Using APIs • 60 minutes
• Hands-on Lab 3: Review Of Web Scraping • 60 minutes
• Hands-on Lab 4: Collecting Data Using Web Scraping • 60 minutes
• Hands-on Lab 5: Explore the Data Set • 60 minutes

2 plugins • Total 30 minutes

• API Access Details • 15 minutes
• About The Dataset • 15 minutes

Data Wrangling

In this module, you will be focusing on the cleaning of your dataset with various techniques. With these techniques you will be identifying duplicate rows, finding missing values, and normalizing the data.

6 readings 5 quizzes 1 app item

6 readings • Total 35 minutes

• Assignment Overview • 5 minutes
• Hands-on Lab 6: Finding Duplicates • 6 minutes
• Hands-on Lab 7: Removing Duplicates • 6 minutes
• Hands-on Lab 8: Finding Missing Values • 6 minutes
• Hands-on Lab 9: Imput Missing Values • 6 minutes
• Hands-on Lab 10: Normalizing Data • 6 minutes

5 quizzes • Total 36 minutes

• Graded Quiz: Duplicates • 6 minutes
• Graded Quiz: Removing Duplicates • 6 minutes
• Graded Quiz: Missing Values • 6 minutes
• Graded Quiz: Imputing Missing Values • 9 minutes
• Graded Quiz: Normalizing Data • 9 minutes

1 app item • Total 60 minutes

• Hands-on Lab: Data Wrangling • 60 minutes

Exploratory Data Analysis

In this module, begin working with the cleaned dataset from the previous module. You will now begin to analyze the dataset to find the distribution of data, presence of outliers and the correlation between different columns.

4 readings 3 quizzes 1 app item

4 readings • Total 35 minutes

• Hands-on Lab 11: Finding How The Data Is Distributed • 10 minutes
• Hands-on Lab 12: Finding Outliers • 10 minutes
• Hands-on Lab 13: Finding Correlation • 10 minutes
• Graded Quiz: Distribution • 6 minutes
• Graded Quiz: Handling Outliers • 12 minutes
• Graded Quiz: Correlation • 6 minutes
• Hands-on Lab: Exploratory Data Analysis • 60 minutes

In module 4 of the Capstone, you will be required to create visualizations using the developer survey data. The visualizations you create should highlight the distribution of data, relationships between data, the composition of data, and comparison of data.

9 readings 4 quizzes 1 app item

9 readings • Total 45 minutes

• Hands-on Lab 14: Histograms • 5 minutes
• Hands-on Lab 15: Box Plots • 5 minutes
• Hands-on Lab 16: Scatter Plots • 5 minutes
• Hands-on Lab 17: Bubble Plots • 5 minutes
• Hands-on Lab 18: Pie Charts • 5 minutes
• Hands-on Lab 19: Stacked Charts • 5 minutes
• Hands-on Lab 20: Line Charts • 5 minutes
• Hands-on Lab 21: Bar Charts • 5 minutes

4 quizzes • Total 24 minutes

• Graded Quiz: Visualizing Relationship • 3 minutes
• Graded Quiz: Visualizing Composition of Data • 12 minutes
• Graded Quiz: Visualizing Comparison of Data • 6 minutes
• Graded Quiz: Visualizing Distribution Of Data • 3 minutes
• Hands-on Lab: Data Visualization • 60 minutes

Building A Dashboard

In this module, you will create a dashboard using IBM Cognos Analytics. This platform will give you the ability to create various charts while assembling a dashboard that is appealing and easy to understand. Your dashboard will contain your data analysis, which should be intuitive and allow for the drill-down of data.

2 readings 1 peer review 1 plugin

• Module 5 Assessment Information • 2 minutes

1 peer review • Total 30 minutes

• Peer-Graded Assignment: Dashboards • 30 minutes

1 plugin • Total 45 minutes

• Peer-Graded Assignment: Building A Dashboard With IBM Cognos Analytics • 45 minutes

Final Assignment: Present Your Findings

You have analyzed the data in the previous modules, and now it is time to demonstrate your storytelling skills. In this module, you will create a compelling story that helps to clarify your analysis in an easy-to-understand presentation.

2 videos 4 readings 1 peer review 4 plugins

2 videos • Total 7 minutes

• Elements Of A Successful Data Findings Report • 4 minutes • Preview module
• Best Practices For Presenting Your Findings • 3 minutes

4 readings • Total 128 minutes

• Assignment Overview • 2 minutes
• Exercise: Preparing Your Presentation • 120 minutes
• Congratulations and Next Steps • 5 minutes
• Course Credits and Acknowledgements • 1 minute

1 peer review • Total 60 minutes

• Peer-graded Assignment • 60 minutes

4 plugins • Total 50 minutes

• Structure Of A Report • 15 minutes
• (Optional) Hands-on Lab 24: Getting Started With PowerPoint For The Web • 15 minutes
• (Optional) Hands-on Lab 25: Basics of PowerPoint • 15 minutes
• (Optional) Hands-on Lab 26: Save your PowerPoint Presentation as PDF • 5 minutes

IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world. For more information about IBM visit: www.ibm.com

Recommended if you're interested in Data Analysis

Data Visualization and Dashboards with Excel and Cognos

Data Visualization with Python

Python Project for Data Science

Data Analyst Career Guide and Interview Preparation

Why people choose coursera for their career.

Learner reviews

Showing 3 of 1058

1,058 reviews

Reviewed on Aug 29, 2022

excellent course, in this course you can develop the necessary skills to enter the world of data analysis

Reviewed on Oct 24, 2023

The final exam requires time and efforts to complete, yet it worths to demonstrate your skills. Highly recommeneded!

Reviewed on Mar 19, 2022

Amazing course

very helpful for those who needs to polish their skills and trying to landing their career in field of Data

New to Data Analysis? Start here.

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions

When will i have access to the lectures and assignments.

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

What is the refund policy?

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy Opens in a new tab .

More questions

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

google-data-analytics

Here are 73 public repositories matching this topic..., ksgr5566 / google-data-analytics.

Notes for the Google Data Analytics course.

• Updated Dec 25, 2021

katiehuangx / Google-Data-Analytics-Capstone

Exploratory Data Analysis on Bellabeat fitness tracker app using Python. Capstone project from Google Data Analytics Professional Certification.

• Updated Aug 10, 2021
• Jupyter Notebook

b06601024 / Coursera-Google-Data-Analytics

Google Data Analytics Professional Certificate

• Updated Jan 16, 2022

shivamgarg444 / Cyclistic-Case-Study

Case study under capstone project of Google Data Analytics Certificate

• Updated Jun 10, 2021

skramazan / GDA_Capstone_Project_Cyclistic_Bike-share

This analysis is for the Google Data Analytics Capstone Project (Cyclistic).

• Updated Dec 20, 2022

cosmoduende / r-google-location-history

Explore your activity on Google with R: How to analyze and visualize your Location History. Find out how and how much you have allowed Google to track you, using a copy of your personal data.

• Updated Aug 1, 2021

krishna0306 / Udemy-Courses-Stas-2023-Prices-Data_analysis

Udemy Course Data Analysis Explore the world of online learning with the Udemy Course Data Analysis project. Dive into the depths of Udemy's vast collection of courses to uncover insights about course prices, popularity, and more. Leveraging Python and data visualization techniques, this project provides a comprehensive overview of Udemy's course o

• Updated Aug 28, 2023

Gui-lherme-Oliv / Google_Data_Analytics-Estudo_de_caso_Bellabeat

Projeto final do programa Google Data Analytics, onde foi concluído um estudo de caso utilizando a linguagem R

• Updated Dec 2, 2023

marcoshsq / GoogleDataAnalyticsCapstone

This repository contains my three case studies for the Google Data Analytics Professional Certificate Capstone Project. 📈📊📉

• Updated Mar 25, 2024

sophiechin / Google-Data-Analytics-Professional-Certificate

This repository is created for the review of the Google Data Analytics Professional program. To complete the whole program, the Case Studies for the Google Data Analytics Capstone are also included.

• Updated Jul 19, 2023

NikoSeino / Bellabeat-case-study

Google Data Analytics capstone project

• Updated May 3, 2023

DmytroNorth / Data_Driven-Marketing_Strategies-SQL

Used bike-sharing company data to design marketing strategies aimed at converting casual riders into annual members.

• Updated Jul 21, 2021

elmaandimahmoud / Google_Data_Analytics_Capstone

A case study on the cyclistic data set

• Updated Mar 5, 2022

sam-is-curious / Google-Data-Analytics-Capstone-Project-Cyclistic-Bike-Share

Exploratory Data Analysis on the fictional company, Cyclistic, a bike-share company out of Chicago. "R" was used to complete this analysis for the Google Data Analytics Professional Certification.

• Updated Oct 25, 2022

jonavrilyo / Google-Data-Analytics-Case-Study-Cyclistic-Bike-Share

A case study on the fictional company Cyclistic, a bike-share company in the Chicago metropolitan area. RStudio was the main tool used to conduct analyses and create visualizations.

• Updated Apr 28, 2024

srivastav-gaurav / Case-study-Google-Data-Analytics-Bike_Share

• Updated Jul 15, 2021

morgan-turner / google-data-analytics-capstone

For my Google Data Analytics Professional Certificate capstone project, I used the tidyverse package in R to identify usage differences between members and casual riders in Cyclistic bike-share data.

• Updated May 23, 2022

AnuttaraR / google-bellabeat-capstone

Hello! Welcome to my first ever data analysis project! I am completing the last course of the Google Data Analytics Cetificate and I chose to do the "Case Study 2: Can a Wellness Company Play it Smart?" which pertains to the Bellabeat Capstone.

• Updated Aug 31, 2022

AayushSameerShah / Google-Data-Analytics-Certificate

This includes my Files and Case Studies done in the Google Data Analytics certificate.

• Updated Nov 6, 2021

sunooja-suhara / capstone_bike_share

Data Analysis of a Bike Share Company using R.

• Updated Aug 8, 2022

Improve this page

Add a description, image, and links to the google-data-analytics topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the google-data-analytics topic, visit your repo's landing page and select "manage topics."