Dataset: Bellabeat Case Study

About this Dataset

Bellabeat Case Study

In this case study, I tracked all 6 phases in the certification and I covered all questions that posted to me.
I used in the case study all of Excel, SQL in Big Query, and I make all visualize by spreadsheets because that is easy to connect with Big Query.

Tables

Dailyactivity Merged

@kaggle.muhamedkhaleid_case_study_bellabeat_project.dailyactivity_merged

32.38 KB
940 rows
16 columns


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

Heartrate Seconds Merged

@kaggle.muhamedkhaleid_case_study_bellabeat_project.heartrate_seconds_merged

4.42 MB
1048575 rows
4 columns


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

Hourlycalories Merged

@kaggle.muhamedkhaleid_case_study_bellabeat_project.hourlycalories_merged

26.47 KB
22099 rows
4 columns


CREATE TABLE hourlycalories_merged (
  "id" BIGINT,
  "activityho" TIMESTAMP,
  "hour" VARCHAR,
  "calories" BIGINT
);

Hourlyintensities Merged

@kaggle.muhamedkhaleid_case_study_bellabeat_project.hourlyintensities_merged

25.94 KB
22099 rows
5 columns


CREATE TABLE hourlyintensities_merged (
  "id" BIGINT,
  "activity" TIMESTAMP,
  "hour" VARCHAR,
  "totalintensity" BIGINT,
  "averageintensity" BIGINT
);

Hourlysteps Merged

@kaggle.muhamedkhaleid_case_study_bellabeat_project.hourlysteps_merged

37.62 KB
22099 rows
4 columns


CREATE TABLE hourlysteps_merged (
  "id" BIGINT,
  "activity" TIMESTAMP,
  "hour" VARCHAR,
  "steptotal" BIGINT
);

Sleepday Merged

@kaggle.muhamedkhaleid_case_study_bellabeat_project.sleepday_merged

8.46 KB
413 rows
6 columns


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

Weightloginfo Merged

@kaggle.muhamedkhaleid_case_study_bellabeat_project.weightloginfo_merged

7.63 KB
67 rows
9 columns


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