• How can a wellness technology company play it smart？

Step 1. Ask

• What is the problem you are trying to solve?
  • Finding out how consumers use non-Bellabeat smart devices.
  • Selecting one Bellabeat product to apply these insights
• How can your insights drive business decisions?
  • Using the dataset of fitbit to find out trend and pattern of consumers using the smart device.
• Stakeholders
  • Urška Sršen: Bellabeat’s cofounder and Chief Creative Officer
  • Sando Mur: Mathematician and Bellabeat’s cofounder; key member of the Bellabeat executive team

Step 2. Prepare

• Data source : Amazon Mechanical Turk(Third-party data sources)
• Download : https://www.kaggle.com/datasets/arashnic/fitbit?resource=download
• Time period : 03.12.2016-05.12.2016 (2 monthes)
• Credibility : 30+ people attend
• Data content : physical activity, heart rate, carlories, and sleep monitoring, ID, timestamp

Step 3. Process

Use BigQuery to deal with these files. And use spreadsheet to analyze it.

Step 4. Analyze and share

Here is the link of my data analysis：https://docs.google.com/spreadsheets/d/1yOScd65EO1bLq3Y8JRujuAM2jEdPgh3oFS3ELGezcUM/edit?usp=sharing

• I use SQL to combine some data, and find the pattern that there are 54.5% users only use app to track their sleeping period, not many users use it to do the activities and weight tracking.

• We can also see the data in dailyActivity, most of users only do the lightlyActivity act, so it seems that there are so many users didn’t use the tracking app thoroughly.

• But we can find some patterns indicate that excercise more can help users burn their Calories, help them lower the BMI number.