README.md

Google Data Analytics Professional Certificate Capstone Project

This repository contains my Capstone Project part of the Google Data Analytics Professional Certification.

Case Study: How Can a Wellness Technology Company Play It Smart?

The project is described here. There are seven steps for a good data analysis according to the Google Certification:

1. Ask: a journal
2. Prepare: a journal
3. Process: a journal
4. Analyze: a journal
5. Share: a journal
6. Act: a journal

The code used can be found in this repository under notebooks. In a nutshell, I analyzed three different datasets, and I used many tools. Many more details in the journals above, but I can summarize it as:

Tools used	Goals	Code/Notebooks/Links
Bigquery, SQL, Python, Pandas, Matplotlib, Seaborn	Study the overall behavior of Fitbit consumers using the Fitabase dataset.	Cleaning data: Link to Kaggle Analyze data: Link to Kaggle
R, Tidyverse, ggplot2	Study the behavior of Apple watch consumers using the AppleWatchFitbit dataset. Study differences between women and men consumers.	Cleaning and Analyzing data: Link to Kaggle
Spreadsheets, Pivot tables	Study behavior of women/men Fitbit costumers related with their intellectual skills.	Cleaning and Analyzing data: Link to Google Sheets
Tableau, dashboards	Summarize and emphasize the previous findings using BI tools.	Fitabase viz: Link to Tableau ApplewatchFibit viz: Link to Tableau FitbitGrades viz: Link to Tableau

All the Kaggle notebooks are also stored in this repository's notebooks/ directory.