joseh4 / BellaBeat_Analysis

This repository contains my analytics process for Google's Data Analysis capstone project
0 stars 0 forks source link

Avg Sedentary Minutes Activity to Calories Burned Correlation #1

Open joseh4 opened 3 months ago

joseh4 commented 3 months ago

Average Sedentary Minutes Activity to Calories Burned Correlation Avg Sedentary Minutes Activity to Calories Burned Correlation

joseh4 commented 3 months ago

Average Very Active Activity to Calories Burned Correlation Avg Very Active Activity to Calories Burned Correlation

joseh4 commented 3 months ago

first user's calories burned journey

Screenshot 2024-08-02 at 3 23 34 PM
joseh4 commented 3 months ago

first user's weight journey

Screenshot 2024-08-02 at 3 30 43 PM
joseh4 commented 3 months ago

Checking work for daily calories. Calories were split into hourly burned rates, so I wanted to join them into a daily burned view by user. This query is checking my work for calories summed correctly.

Checking_work_for_Daily_Calories_by User_1

joseh4 commented 3 months ago

Union tables. This query is to exemplify using the union function for my data. For the sake of understanding what is in each table, the columns have been written out. All columns were written out, so using the "*" character would have saved time, however, for you the reader, it is best to know what is being unionized.

SQL_Query_for_hourly_intensities

joseh4 commented 3 months ago

This query shows I am selecting the Id, ActivityDay, while summing calories for each user and grouping the days together. In this dataset, there are multiple day entries for each user, so summing the calories to give me one day was important to generate a daily report.

Query_Grouping_Calories_Burned_Daily