I took a course called Google Data Analytics Professional Certificate. This was my capstone project. I was tasked to analyze smart device usage data of competing brands in order to gain insight into how consumers use non-Bellabeat smart devices. I needed to choose one Bellabeat product to apply these insights to and create high level recommendations for their brand.
These were the questions I needed to answer with my analysis:
1. What are some trends in smart device usage?
2. How could these trends apply to Bellabeat customers?
3. How could these trends help influence Bellabeat marketing strategy?
Before proceeding, I would like to state limitations & assumptions in my case study.
Firstly, the Xiaomi dataset exhibited numerous instances of zero values. Although this dataset parallels the data collected by Fitbit, prompting its inclusion in this study, it remains unclear whether these zero values are accurate representations of the data or if there were issues during the data collection process. Due to the lack of definitive confirmation from the data source, it is prudent to acknowledge and cautiously consider the output of this dataset.
Secondly, the age demographic of the participants is not disclosed, which makes it challenging to determine a standard for healthy sleep duration. Because of this, this case study operates under the assumption that the participants are adults, recognizing that individual sleep requirements may vary based on age.
Moving forward, here are my answers to the case study's questions.
Step Count: The study analyzed step data from both Xiaomi and Fitbit datasets, revealing that the majority of users do not meet the recommended daily step count of 10,000 steps for optimal health benefits. Specifically, Xiaomi users predominantly walk less than 5,000 steps daily, while the Fitbit dataset indicates that most users walk between 7,000 and 8,000 steps daily.
Hourly Intensities: The Fitbit dataset demonstrates fluctuations in activity intensity throughout the day, with users being least active between 12 AM and 4 AM, corresponding to typical sleeping hours. Conversely, peak activity occurs from 5 PM to 7 PM, coinciding with post-work hours and pre-dinner time.
Total Steps vs. Calories: Analysis of the Fitbit dataset reveals a positive correlation between the total number of steps taken by users and the calories burned. This underscores the importance of physical activity in calorie expenditure and overall health.
Sleep: Insights from the Fitbit sleep dataset indicate that approximately half of the users fail to achieve the recommended 420 minutes (7 hours) of sleep per night, highlighting potential deficits in sleep duration among smart device users.
Step Count: Based on the trends, Bellabeat customers should be reminded to reach the step counts, have options to set daily step goals, and to have access to the health benefits of walking everyday so that they can see what reaching their step goals do for them.
Hourly Intensities: Understanding peak activity times can inform Bellabeat's approach to notifying customers about their activity levels, enabling tailored features aligned with users' daily routines.
Total Steps vs. Calories: Since there is a positive correlation of total steps and calories, Bellabeat can encourage walking more for the health of their customers as it encourages weight loss and ultimately contributes to the wellness of users.
Sleep: Bellabeat customers could benefit from insights into their sleep patterns, with the provision of reminders and educational content aimed at fostering healthy sleep habits.
I suggest adding features to the Bellabeat app:
Step Count: Allow users to have step goals and an avenue to receive a reminder to increase their steps at a certain time of the day. The app can also promote the health benefits of walking for women's wellness.
Hourly Intensities: The Bellabeat app can send a reminder to users to increase activity sometime from 5 - 7 PM. Since people are most active during these times, people may likely be more inspired to move since there is a pattern of movement at this time frame. The app can also contain the benefits of working out at different times. It has been found that morning workouts encourages weight loss while afternoon workouts gives performance boosts throughout the day.
Total Steps vs. Calories: Including daily calorie goals and progress trackers within the app can empower users to monitor their physical activity's impact on calorie expenditure, fostering a holistic approach to health management.
Sleep: Providing users with comprehensive sleep summaries and reminders to achieve adequate sleep duration can promote healthy sleep habits. The app can also include the benefits of sleeping properly and how it contributes to their health.
Ducharme, J. (2024, February 14). This is the best time of day to work out, according to Science. Time. https://time.com/5533388/best-time-to-exercise/
Meyer, A. (2023, June 23). What happens to your body when you walk 10,000 steps per day. EatingWell. https://www.eatingwell.com/article/8053585/what-happens-to-your-body-when-you-walk-10000-steps-per-day/
Mobius. 2024; March. FitBit Fitness Tracker Data, Version 2. Retrieved March 3, 2024 from https://www.kaggle.com/datasets/arashnic/fitbit.
Kuralbayev. B. 2021. Exported data from Xiaomi Mi Band fitness tracker. Version 1. Retrieved March 3, 2024 from https://www.kaggle.com/datasets/bekbolsky/exported-data-from-xiaomi-mi-band-fitness-tracker.