Bellabeat Capstone Strategic Wellness Insights

Strategic Wellness Insights: Data-Driven Global Strategy for Bellabeat 🚀 How do you transform millions of rows of raw fitness data into a multi-million dollar growth strategy? In this video, I break down my comprehensive data analytics project for Bellabeat, a high-tech manufacturer of health-focused products for women . As a Chemical Engineer and Data Analyst, I bridge the gap between complex process engineering and smart wellness intelligence . This project demonstrates a full-cycle analytical approach—from rigorous SQL data engineering to executive-level strategic recommendations. Key Technical Highlights: The SQL Engine: I utilized Google BigQuery to build a robust ETL pipeline, handling the deduplication of over 1,400 records and performing complex type-casting to ensure absolute data reliability . Relational Modeling: To ensure mathematical accuracy, I developed a composite multi-key relational join (matching User ID + Date). I utilized a LEFT JOIN strategy anchored on activity tables to prevent the loss of valuable metabolic data from users who didn't wear devices to sleep . Predictive Power in Tableau: Using Tableau, I uncovered that METs (Metabolic Equivalent of Task) explain 43% of calorie burn variability (R 2 =0.4285), proving that intensity is far more important than simple step volume . Strategic Business Impact: Moving beyond "passive monitoring," this analysis provides Bellabeat with three actionable pillars for growth: 15-Minute HIIT Challenges: Maximizing caloric efficiency based on metabolic data . Smart Metabolic Alarms: Subtle alerts that trigger intensity spikes when metabolism slows down . Projected Results: These data-driven interventions are estimated to drive a 20% improvement in metabolic efficiency for the end-user . Timestamps: 0:00 - The Business Challenge: Unlocking Bellabeat’s Growth 0:30 - Tech Stack: SQL ETL Pipeline & Data Integrity 1:10 - Tableau Insights: METs vs. Daily Steps 1:50 - Strategic Recommendations & Product Evolution 2:30 - Conclusion: Data as a Language for Business Strategy -------------------------------------------------------------------------------- Looking for a Data Consultant? I help businesses turn raw data into strategic growth. If you're looking for a consultant who combines technical rigor with business intuition, let’s connect! 💼 Hire me on Malt: https://www.malt.es/profile/jessicareyes📊 View my Full Portfolio: https://www.linkedin.com/in/jessicareyes-d... "Data is the language of nature; analytics is our way of listening to it to improve lives." — Jessica, Business & Data Analyst . #DataAnalytics #SQL #Tableau #Bellabeat #BusinessIntelligence #DataScience #BigQuery #WomenInTech #WellnessTech