Baselight

Bellabeat Case Study

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

@kaggle.muhamedkhaleid_case_study_bellabeat_project

Hourlyintensities Merged
@kaggle.muhamedkhaleid_case_study_bellabeat_project.hourlyintensities_merged

  • 25.94 KB
  • 22099 rows
  • 5 columns
id

Id

activity

Activity

hour

Hour

totalintensity

TotalIntensity

averageintensity

AverageIntensity

1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12:00:00 AM20
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1:00:00 AM8
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)2:00:00 AM7
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 AM13
1503960366Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)9:00:00 AM301

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

Share link

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