Skip to content

A complete and detailed case study on Bellabeat Wellness using SQL for cleaning, analysis, Tableau for visualization and PowerPoint for presentation slide

Notifications You must be signed in to change notification settings

tos-in1/Bellabeat_Wellness

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 

Repository files navigation

🌿 Bellabeat: Smart Device Usage Analysis

Business Summary

Bellabeat is a wellness-oriented tech company that manufactures smart health products tailored for women. While already being a successful small brand, Bellabeat aspires to become a larger player in the global smart device market. Its product suite includes the Bellabeat Leaf, Spring, and Time—designed to help users monitor daily activity, sleep, stress, and overall well-being.

⭕ Business Problem?

As Bellabeat looks to expand beyond its current success and compete in the global smart device market, one critical challenge stands in the way — a lack of broad consumer insight into how individuals use smart fitness devices. Without a clear understanding of user behaviors and habits, the company’s marketing strategies risk falling short in attracting new users, increasing product adoption, and positioning its offerings effectively in a highly competitive landscape.

🎯 Project Objective

As a data analyst, I was tasked with analyzing public smart device usage data (FitBit) to uncover patterns in users’ daily activiting. These insights will inform Bellabeat’s marketing team to align their strategies with actual user behavior and better position their products for broader adoption.

🔍 Key Business Questions

  1. WHAT are some trends in smart device usage?
  2. HOW could these activity trends help influence Bellabeat’s marketing strategy?

🧰 Tools Used

  • SQL (Google BigQuery)
  • Tableau Public
  • PowerPoint

🔍 Key Insights Discovered

  1. WHAT are some trends in smart device usage?

    • Users spend about 16Hrs of 24Hrs in sedentary behavior Image

    • Users who take more steps tend to burn more calories Image

    • Users are most active on Mondays, Tuesdays and Saturdays Image

      Image

      Image

💡 Strategic Marketing Recommendations

2. HOW could these activity trends help influence Bellabeat’s marketing strategy?

  • Since a higher percentage of users exhibit a sedentary behaviour, Bellabeat should integrating real-time inactivity alerts and encouraging movement through subtle prompts or short guided activities. This would help users stay active and reduce sedentary habits.

  • Bellabeat can launch community-based challenges that focus on daily or weekly step goals and calorie targets can drive user participation and brand loyalty. These challenges should be positioned as fun, rewarding, and backed by its wellness mission—offering badges, rewards, or discounts for completing milestones to keep users engaged.

  • Usage trends indicate that user activity tends to rise on Mondays, Tuesdays, and Saturdays. So Bellabeat can capitalize on this by scheduling key marketing initiatives—such as email campaigns, wellness tips, flash sales, or product announcements on these high-engagement days. This timing strategy increases the likelihood of user interaction and campaign visibility.

📊 View Presentation Slide

Click here to view Presentation slide

🧑‍💻 View SQL codes

Click here to view SQL codes

📝 View the entire process

Click here to view Medium Report

About

A complete and detailed case study on Bellabeat Wellness using SQL for cleaning, analysis, Tableau for visualization and PowerPoint for presentation slide

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published