Dataset: Bellabeat Case Study

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

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

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

12.8 MB
2483658 rows
3 columns


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

Hourlycalories Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.hourlycalories_merged

34.62 KB
22099 rows
3 columns


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

Hourlyintensities Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.hourlyintensities_merged

47.43 KB
22099 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

45.78 KB
22099 rows
3 columns


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

Minutecaloriesnarrow Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutecaloriesnarrow_merged

6.33 MB
1325580 rows
3 columns


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

Minutecalorieswide Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutecalorieswide_merged

1.51 MB
21645 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

5.87 MB
1325580 rows
3 columns


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

Minuteintensitieswide Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minuteintensitieswide_merged

298.52 KB
21645 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.16 MB
1325580 rows
3 columns


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

Minutesleep Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutesleep_merged

791.6 KB
188521 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.07 MB
1325580 rows
3 columns


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

Minutestepswide Merged

@kaggle.soroyac_fitbit_data_points_bellabeat.minutestepswide_merged

600.02 KB
21645 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

7.82 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.63 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
);