Name: Bellabeat Case Study
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Bellabeat Case Study

Bellabeat case study

This case study has been done by Irina Safronova as an end-of-certificate project for the Google Data Analytics Certificate.

As in this case study I used SQL for analysis, documentation is placed as attachments and consists of:

Presentation of the analysis (Bellabeat case study .pptx).
A summary of analysis (Bellabeat case study. Statement.pdf).
Documentation of any cleaning or manipulation of data (Bellabeat case study. Data cleaning and manipulation.odt).

Data sources used

FitBit Fitness Tracker Data (CC0: Public Domain, dataset made available through Mobius): This Kaggle data set contains personal fitness tracker from thirty fitbit users. Thirty eligible Fitbit users consented to the submission of personal tracker data, including minute-level output for physical activity, heart rate, and sleep monitoring. It includes information about daily activity, steps, and heart rate that can be used to explore users’ habits.

Tables

Bellabeat Query Average Min Results End Result

@kaggle.irinausername_bellabeat_case_study.bellabeat_query_average_min_results_end_result

12.85 KB
33 rows
13 columns


CREATE TABLE bellabeat_query_average_min_results_end_result (
  "id" BIGINT,
  "f0" DOUBLE,
  "averagedistancemonth" DOUBLE,
  "f1" DOUBLE,
  "averagecaloriesmonth" DOUBLE,
  "f2" DOUBLE,
  "averageveryactiveminutes" DOUBLE,
  "f3" DOUBLE,
  "averagefairlyactiveminutes" DOUBLE,
  "f4" DOUBLE,
  "averagelightlyactiveminutes" DOUBLE,
  "f5" DOUBLE,
  "averageactiveminutes" DOUBLE
);