msa1979msa / SQL_analysis_activity

Daily_activity_project
0 stars 0 forks source link

SQL_analysis_activity

Daily_activity_project

Each dataset was cleaned using Excel. The following steps were taken within each dataset: Sorted and filtered data by Id to obtain how many unique users there were within the dataset. Formatted date data into MM/DD/YY date format and checked Id entries and other columns for LEN to make sure the data was correct and uniform in length

Uploaded FitBit Fitness Tracker Data into BigQuery

dailyActivity
dailyCalories
dailySteps
sleepDay
weightLoginfo