Baselight

Bellabeat Case Study

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

@kaggle.muhamedkhaleid_case_study_bellabeat_project

Sleepday Merged
@kaggle.muhamedkhaleid_case_study_bellabeat_project.sleepday_merged

  • 8.46 KB
  • 413 rows
  • 6 columns
id

Id

sleepday

SleepDay

hour

Hour

totalsleeprecords

TotalSleepRecords

totalminutesasleep

TotalMinutesAsleep

totaltimeinbed

TotalTimeInBed

1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM1327346
1503960366Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM2384407
1503960366Fri Apr 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM1412442
1503960366Sat Apr 16 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM2340367
1503960366Sun Apr 17 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM1700712
1503960366Tue Apr 19 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM1304320
1503960366Wed Apr 20 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM1360377
1503960366Thu Apr 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM1325364
1503960366Sat Apr 23 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM1361384
1503960366Sun Apr 24 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM1430449

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

Share link

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