Google Capstone Project

The final project of the Google Data Analytics Professional Certificate

The Course

Those who earn the Google Data Analytics Professional Certificatehave completed eight courses, developed by Google, that includehands-on, practice-based assessments and are designed to preparethem for introductory-level roles in Data Analytics. They are competentin tools and platforms including spreadsheets, SQL, Tableau, and R.They know how to prepare, process, analyze, and share data forthoughtful action.

The Curriculum :

• Foundations: Data, Data,Everywhere
• Ask Questions to Make Data-Driven Decisions
• Prepare Data for Exploration
• Process Data from Dirty to Clean
• Analyze Data to Answer Questions
• Share Data Through the Art of Visualization
• Data Analysis with R Programming
• Google Data Analytics Capstone: Complete a CaseStudy

Scenario for the Capstone Project

I am a junior data analyst working on the marketing analyst team at Bellabeat,a high-tech manufacturer of health focused products for women.Bellabeat is a successful small company,but they have the potential to become a larger player in the global smart device market.Urška Sršen,co-founder and Chief Creative Officer of Bellabeat,believes that analyzing smart device fitness data could help unlock new growth opportunities for the company.I have been asked to focus on one of Bellabeat’s products andanalyze smart device data to gain insight into how consumers are using their smart devices.The insights I discover will then help guide marketing strategy for the company.I will present mine analysis to the Bellabeat executive team along with mine high-level recommendations for Bellabeat’s marketing strategy.

Products :

• Bellabeat app : The Bellabeat app provides users with health data related to their activity, sleep, stress, menstrual cycle, and mindfulness habits. This data can help users better understand their current habits and make healthy decisions. The Bella beat app connects to their line of smart wellness products.
• Leaf : Bellabeat’s classic wellness tracker can be worn as a bracelet, necklace, or clip. The Leaf tracker connects to the Bellabeat app to track activity, sleep, and stress.
• Time : This wellness watch combines the time less look of a classic time piece with smart technology to track user activity, sleep, and stress. The Time watch connects to the Bella beat app to provide you with insights into your daily wellness.
• Spring : This is a water bottle that tracks daily water intake using smart technology to ensure that you are appropriately hydrated throughout the day. The Spring bottle connects to the Bella beat app to track your hydration levels.

Content :

• ASK
• PREPARE
• PROCESS
• ANALYZE
• SHARE
• ACT

! The whole process could be found here

Final Dashboard :

You also can play interactively with it here or load it from the workbook in the repository .

Suggestion to the business :

1. Calories :

• The people who are walking most and record the longest distance are not the ones that burn most calories.
• The people that burn most calories are the ones that are doing extremely intensive exercise.

Outcome : We could focus on the active, intensive exercising and even promote it. The graph could be found in the image “corr.png”

2.Only 1/3 of the days the users are reaching the minimum steps, which the doctors are advising for normal way of life and good health condition. ! This could be used in a commercial, where the data shows that more than half of the people are inactive. Also, it is good to be noted that this conclusion is drawn from people that already have taken the first step in their healthy life (buying a tracking gadget). This means that the real proportion of people, who not only do not look after their health, but also do not monitor their steps is significantly bigger. !

3. The Fit Bit Tracker have flawns - They record around 4/5 beats per minute, which is not logical nor normal. The only logical explanation is that we already have a flawn in the FitBit trackers. They do not record accurate the heart beating of a person. This is something that we can use. First of all to be sure that a correct monitoring is present in our devices. Second of all to show off a new functionality that seems not present in our exisiting competitors.

Sources :

• FitBit Fitness Tracker Data - https://www.kaggle.com/arashnic/fitbit