BellaBeat Case Study Via Google
Analyzing products within Bellabeat and the customer use of these products.
@kaggle.tevontegriffin_bellabeat_case_study_via_google
Analyzing products within Bellabeat and the customer use of these products.
@kaggle.tevontegriffin_bellabeat_case_study_via_google
CREATE TABLE dailyintensities_merged (
"id" BIGINT,
"activityday" TIMESTAMP,
"sedentaryminutes" BIGINT,
"lightlyactiveminutes" BIGINT,
"fairlyactiveminutes" BIGINT,
"veryactiveminutes" BIGINT,
"sedentaryactivedistance" DOUBLE,
"lightactivedistance" DOUBLE,
"moderatelyactivedistance" DOUBLE,
"veryactivedistance" DOUBLE
);
CREATE TABLE dailyactivity_merged (
"id" BIGINT,
"activitydate" TIMESTAMP,
"totalsteps" BIGINT,
"totaldistance" DOUBLE,
"trackerdistance" DOUBLE,
"loggedactivitiesdistance" DOUBLE,
"veryactivedistance" DOUBLE,
"moderatelyactivedistance" DOUBLE,
"lightactivedistance" DOUBLE,
"sedentaryactivedistance" DOUBLE,
"veryactiveminutes" BIGINT,
"fairlyactiveminutes" BIGINT,
"lightlyactiveminutes" BIGINT,
"sedentaryminutes" BIGINT,
"calories" BIGINT
);
CREATE TABLE weightloginfo_merged (
"id" BIGINT,
"date" VARCHAR,
"weightkg" DOUBLE,
"weightpounds" DOUBLE,
"fat" DOUBLE,
"bmi" DOUBLE,
"ismanualreport" BOOLEAN,
"logid" BIGINT
);
Anyone who has the link will be able to view this.