Baselight

Bellabeat Case Study

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

@kaggle.muhamedkhaleid_case_study_bellabeat_project

Hourlysteps Merged
@kaggle.muhamedkhaleid_case_study_bellabeat_project.hourlysteps_merged

  • 37.62 KB
  • 22099 rows
  • 4 columns
id

Id

activity

Activity

hour

Hour

steptotal

StepTotal

1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM373
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1:00:00 AM160
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)2:00:00 AM151
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)3:00:00 AM
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4:00:00 AM
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)5:00:00 AM
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)6:00:00 AM
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)7:00:00 AM
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)8:00:00 AM250
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)9:00:00 AM1864

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

Share link

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