Bellabeat Case Study
an end-of-certificate project
@kaggle.irinausername_bellabeat_case_study
an end-of-certificate project
@kaggle.irinausername_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:
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.
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
);
Anyone who has the link will be able to view this.