You are 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, cofounder and Chief Creative Officer of Bellabeat, believes that analyzing smart device fitness data could help unlock new growth opportunities for the company. You have been asked to focus on one of Bellabeat’s products and analyze smart device data to gain insight into how consumers are using their smart devices. The insights you discover will then help guide marketing strategy for the company.
The previous information was the guide used to create all of the files in this repo.
The first file we'll talk about is the SQL querie script I created on MySQL to create and clean all of the tables used in this project, it also serves as a registry of my process in case the code contains mistakes it makes it easier to correct, it contains the SQL commands used and annotations that indicate the purpose of the query. The following is a link to the file that contains the SQL script used to querie the tables in the dataset:
1.- SQL script .
The following files contain all of the R code used during the project, including the code for the R markdown report:
1.- R script used in the analysis .
2.- R markdown source code .
The following link will take you to the report made with R that contains a summary and description of all the steps taken during the project as well as the conclusions of the project and the recommendations for the company:
1.- R markdown report .
I want to say thanks to the Kaggle user who uploaded the dataset and allowed the general public to use it for the improvement of their data analyitics skills.
In order to make the following project I used the following resources:
1.- Dataset FitBit Fitness Tracker Data
2.- R plots: ggplot2
3.- Colors for my R plots: Colors in R
4.- R markdown commands: R markdown cheatsheet