Baselight

Bellabeat Case Study

I used in the case study (Excel, SQL, Sheets to Visualize)

@kaggle.muhamedkhaleid_case_study_bellabeat_project

Dailyactivity Merged
@kaggle.muhamedkhaleid_case_study_bellabeat_project.dailyactivity_merged

  • 32.38 KB
  • 940 rows
  • 16 columns
id

Id

activitydate

ActivityDate

weekday

Weekday

totalsteps

TotalSteps

totaldistance

TotalDistance

trackerdistance

TrackerDistance

loggedactivitiesdistance

LoggedActivitiesDistance

veryactivedistance

VeryActiveDistance

moderatelyactivedistance

ModeratelyActiveDistance

lightactivedistance

LightActiveDistance

sedentaryactivedistance

SedentaryActiveDistance

veryactiveminutes

VeryActiveMinutes

fairlyactiveminutes

FairlyActiveMinutes

lightlyactiveminutes

LightlyActiveMinutes

sedentaryminutes

SedentaryMinutes

calories

Calories

1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Tuesday131629921625133287281985
1503960366Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Wednesday107357721521192177761797
1503960366Thu Apr 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Thursday104607724301118112181776
1503960366Fri Apr 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Friday97626621329342097261745
1503960366Sat Apr 16 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Saturday12669883536102217731863
1503960366Sun Apr 17 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Sunday97056631338201645391728
1503960366Mon Apr 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Monday1301999315421623311491921
1503960366Tue Apr 19 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Tuesday15506101041550312647752035
1503960366Wed Apr 20 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Wednesday10544772428122058181786
1503960366Thu Apr 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Thursday981966151982118381775

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
);

Share link

Anyone who has the link will be able to view this.