Name: Bellabeat Case Study
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Bellabeat Case Study

Context

Bellabeat is a tech-driven companany that creates fashionable wellness products for women. Giving women the tools they need to take data driven actions to become the best version of themselves.
Urška Sršen: Bellabeat’s cofounder and Chief Creative Officer
Sando Mur Bellabeat’s cofounder; key member of the Bellabeat executive team

The Project is to analyze smart device usage of non Bellabeat consumers to gain insight of their usage and then apply that insight to a Bellabeat product. Data from the Fitbit dataset will be used to analyze.

Content

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 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.

Notes: setting up my R environment by loading the 'tidyverse' package and importing the Fitbit Fitness Tracker data from the Kaggle site.

Acknowledgements

Thank to Mobius, Fitbit and the Bellabeat
Photo by Emma Simpson on Unsplash

Inspiration

Questions to be answered:

What are some trends in smart device usage?
How could these trends apply to Bellabeat customers?
How could these trends help influence Bellabeat marketing strategy?

The Fitbit Tracker dataset does not does not have gender variable. This could be a concern since Bellabeat's consumer are women. Consequently, focus will be on activity and sleep.

Tables

Dailyactivity Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.dailyactivity_merged

48.42 kB
940 rows
15 columns

CREATE TABLE dailyactivity_merged (
  "id" BIGINT,
  "activitydate" TIMESTAMP,
  "totalsteps" BIGINT,
  "totaldistance" DOUBLE,
  "trackerdistance" DOUBLE,
  "loggedactivitiesdistance" DOUBLE,
  "veryactivedistance" DOUBLE,
  "moderatelyactivedistance" DOUBLE,
  "lightactivedistance" DOUBLE,
  "sedentaryactivedistance" DOUBLE,
  "veryactiveminutes" BIGINT,
  "fairlyactiveminutes" BIGINT,
  "lightlyactiveminutes" BIGINT,
  "sedentaryminutes" BIGINT,
  "calories" BIGINT
);

Dailycalories Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.dailycalories_merged

7.8 kB
940 rows
3 columns

CREATE TABLE dailycalories_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "calories" BIGINT
);

Dailyintensities Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.dailyintensities_merged

26.36 kB
940 rows
10 columns

CREATE TABLE dailyintensities_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "sedentaryminutes" BIGINT,
  "lightlyactiveminutes" BIGINT,
  "fairlyactiveminutes" BIGINT,
  "veryactiveminutes" BIGINT,
  "sedentaryactivedistance" DOUBLE,
  "lightactivedistance" DOUBLE,
  "moderatelyactivedistance" DOUBLE,
  "veryactivedistance" DOUBLE
);

Dailysteps Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.dailysteps_merged

8.33 kB
940 rows
3 columns

CREATE TABLE dailysteps_merged (
  "id" BIGINT,
  "activityday" TIMESTAMP,
  "steptotal" BIGINT
);

Heartrate Seconds Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.heartrate_seconds_merged

13.42 MB
2,483,658 rows
3 columns

CREATE TABLE heartrate_seconds_merged (
  "id" BIGINT,
  "time" VARCHAR,
  "value" BIGINT
);

Hourlycalories Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.hourlycalories_merged

35.45 kB
22,099 rows
3 columns

CREATE TABLE hourlycalories_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "calories" BIGINT
);

Hourlyintensities Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.hourlyintensities_merged

48.56 kB
22,099 rows
4 columns

CREATE TABLE hourlyintensities_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "totalintensity" BIGINT,
  "averageintensity" DOUBLE
);

Hourlysteps Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.hourlysteps_merged

46.88 kB
22,099 rows
3 columns

CREATE TABLE hourlysteps_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "steptotal" BIGINT
);

Minutecaloriesnarrow Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutecaloriesnarrow_merged

6.63 MB
1,325,580 rows
3 columns

CREATE TABLE minutecaloriesnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "calories" DOUBLE
);

Minutecalorieswide Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutecalorieswide_merged

1.58 MB
21,645 rows
62 columns

CREATE TABLE minutecalorieswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "calories00" DOUBLE,
  "calories01" DOUBLE,
  "calories02" DOUBLE,
  "calories03" DOUBLE,
  "calories04" DOUBLE,
  "calories05" DOUBLE,
  "calories06" DOUBLE,
  "calories07" DOUBLE,
  "calories08" DOUBLE,
  "calories09" DOUBLE,
  "calories10" DOUBLE,
  "calories11" DOUBLE,
  "calories12" DOUBLE,
  "calories13" DOUBLE,
  "calories14" DOUBLE,
  "calories15" DOUBLE,
  "calories16" DOUBLE,
  "calories17" DOUBLE,
  "calories18" DOUBLE,
  "calories19" DOUBLE,
  "calories20" DOUBLE,
  "calories21" DOUBLE,
  "calories22" DOUBLE,
  "calories23" DOUBLE,
  "calories24" DOUBLE,
  "calories25" DOUBLE,
  "calories26" DOUBLE,
  "calories27" DOUBLE,
  "calories28" DOUBLE,
  "calories29" DOUBLE,
  "calories30" DOUBLE,
  "calories31" DOUBLE,
  "calories32" DOUBLE,
  "calories33" DOUBLE,
  "calories34" DOUBLE,
  "calories35" DOUBLE,
  "calories36" DOUBLE,
  "calories37" DOUBLE,
  "calories38" DOUBLE,
  "calories39" DOUBLE,
  "calories40" DOUBLE,
  "calories41" DOUBLE,
  "calories42" DOUBLE,
  "calories43" DOUBLE,
  "calories44" DOUBLE,
  "calories45" DOUBLE,
  "calories46" DOUBLE,
  "calories47" DOUBLE,
  "calories48" DOUBLE,
  "calories49" DOUBLE,
  "calories50" DOUBLE,
  "calories51" DOUBLE,
  "calories52" DOUBLE,
  "calories53" DOUBLE,
  "calories54" DOUBLE,
  "calories55" DOUBLE,
  "calories56" DOUBLE,
  "calories57" DOUBLE,
  "calories58" DOUBLE,
  "calories59" DOUBLE
);

Minuteintensitiesnarrow Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minuteintensitiesnarrow_merged

6.15 MB
1,325,580 rows
3 columns

CREATE TABLE minuteintensitiesnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "intensity" BIGINT
);

Minuteintensitieswide Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minuteintensitieswide_merged

305.68 kB
21,645 rows
62 columns

CREATE TABLE minuteintensitieswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "intensity00" BIGINT,
  "intensity01" BIGINT,
  "intensity02" BIGINT,
  "intensity03" BIGINT,
  "intensity04" BIGINT,
  "intensity05" BIGINT,
  "intensity06" BIGINT,
  "intensity07" BIGINT,
  "intensity08" BIGINT,
  "intensity09" BIGINT,
  "intensity10" BIGINT,
  "intensity11" BIGINT,
  "intensity12" BIGINT,
  "intensity13" BIGINT,
  "intensity14" BIGINT,
  "intensity15" BIGINT,
  "intensity16" BIGINT,
  "intensity17" BIGINT,
  "intensity18" BIGINT,
  "intensity19" BIGINT,
  "intensity20" BIGINT,
  "intensity21" BIGINT,
  "intensity22" BIGINT,
  "intensity23" BIGINT,
  "intensity24" BIGINT,
  "intensity25" BIGINT,
  "intensity26" BIGINT,
  "intensity27" BIGINT,
  "intensity28" BIGINT,
  "intensity29" BIGINT,
  "intensity30" BIGINT,
  "intensity31" BIGINT,
  "intensity32" BIGINT,
  "intensity33" BIGINT,
  "intensity34" BIGINT,
  "intensity35" BIGINT,
  "intensity36" BIGINT,
  "intensity37" BIGINT,
  "intensity38" BIGINT,
  "intensity39" BIGINT,
  "intensity40" BIGINT,
  "intensity41" BIGINT,
  "intensity42" BIGINT,
  "intensity43" BIGINT,
  "intensity44" BIGINT,
  "intensity45" BIGINT,
  "intensity46" BIGINT,
  "intensity47" BIGINT,
  "intensity48" BIGINT,
  "intensity49" BIGINT,
  "intensity50" BIGINT,
  "intensity51" BIGINT,
  "intensity52" BIGINT,
  "intensity53" BIGINT,
  "intensity54" BIGINT,
  "intensity55" BIGINT,
  "intensity56" BIGINT,
  "intensity57" BIGINT,
  "intensity58" BIGINT,
  "intensity59" BIGINT
);

Minutemetsnarrow Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutemetsnarrow_merged

6.46 MB
1,325,580 rows
3 columns

CREATE TABLE minutemetsnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "mets" BIGINT
);

Minutesleep Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutesleep_merged

810.6 kB
188,521 rows
4 columns

CREATE TABLE minutesleep_merged (
  "id" BIGINT,
  "date" VARCHAR,
  "value" BIGINT,
  "logid" BIGINT
);

Minutestepsnarrow Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutestepsnarrow_merged

6.37 MB
1,325,580 rows
3 columns

CREATE TABLE minutestepsnarrow_merged (
  "id" BIGINT,
  "activityminute" VARCHAR,
  "steps" BIGINT
);

Minutestepswide Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutestepswide_merged

614.42 kB
21,645 rows
62 columns

CREATE TABLE minutestepswide_merged (
  "id" BIGINT,
  "activityhour" VARCHAR,
  "steps00" BIGINT,
  "steps01" BIGINT,
  "steps02" BIGINT,
  "steps03" BIGINT,
  "steps04" BIGINT,
  "steps05" BIGINT,
  "steps06" BIGINT,
  "steps07" BIGINT,
  "steps08" BIGINT,
  "steps09" BIGINT,
  "steps10" BIGINT,
  "steps11" BIGINT,
  "steps12" BIGINT,
  "steps13" BIGINT,
  "steps14" BIGINT,
  "steps15" BIGINT,
  "steps16" BIGINT,
  "steps17" BIGINT,
  "steps18" BIGINT,
  "steps19" BIGINT,
  "steps20" BIGINT,
  "steps21" BIGINT,
  "steps22" BIGINT,
  "steps23" BIGINT,
  "steps24" BIGINT,
  "steps25" BIGINT,
  "steps26" BIGINT,
  "steps27" BIGINT,
  "steps28" BIGINT,
  "steps29" BIGINT,
  "steps30" BIGINT,
  "steps31" BIGINT,
  "steps32" BIGINT,
  "steps33" BIGINT,
  "steps34" BIGINT,
  "steps35" BIGINT,
  "steps36" BIGINT,
  "steps37" BIGINT,
  "steps38" BIGINT,
  "steps39" BIGINT,
  "steps40" BIGINT,
  "steps41" BIGINT,
  "steps42" BIGINT,
  "steps43" BIGINT,
  "steps44" BIGINT,
  "steps45" BIGINT,
  "steps46" BIGINT,
  "steps47" BIGINT,
  "steps48" BIGINT,
  "steps49" BIGINT,
  "steps50" BIGINT,
  "steps51" BIGINT,
  "steps52" BIGINT,
  "steps53" BIGINT,
  "steps54" BIGINT,
  "steps55" BIGINT,
  "steps56" BIGINT,
  "steps57" BIGINT,
  "steps58" BIGINT,
  "steps59" BIGINT
);

Sleepday Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.sleepday_merged

8 kB
413 rows
5 columns

CREATE TABLE sleepday_merged (
  "id" BIGINT,
  "sleepday" VARCHAR,
  "totalsleeprecords" BIGINT,
  "totalminutesasleep" BIGINT,
  "totaltimeinbed" BIGINT
);

Weightloginfo Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.weightloginfo_merged

7.81 kB
67 rows
8 columns

CREATE TABLE weightloginfo_merged (
  "id" BIGINT,
  "date" VARCHAR,
  "weightkg" DOUBLE,
  "weightpounds" DOUBLE,
  "fat" DOUBLE,
  "bmi" DOUBLE,
  "ismanualreport" BOOLEAN,
  "logid" BIGINT
);