Portfolio Project · Data Analytics

Bellabeat Smart Device Behavioral Analysis

A behavioral analysis of Fitbit activity and sleep data designed to identify user patterns and translate them into practical product and marketing recommendations.

Overview

From wearable data to behavioral insight

The project explored activity, calories, sedentary time and sleep patterns captured by Fitbit devices. The goal was not only to summarize behavior, but to connect patterns with actionable ideas for Bellabeat's product and marketing strategy.

17source tables
4 weeksactivity window
Daily + hourlybehavior signals

Business Question

What the analysis needed to answer

Which habits and trends appear in smart-device usage, and how could those patterns inform marketing and engagement strategies for a women's wellness technology brand?

Data

Fitbit activity and sleep records

The dataset covered April 12 to May 12, 2016 and included daily and hourly activity information such as steps, calories, intensity, sedentary minutes and sleep. The work included format correction, duplicate removal, derived fields and weekday-level aggregation.

Analysis Process

Cleaning, derivation and comparison

Raw Fitbit tablesClean & validateDerived metricsWeekday averagesVisual analysisRecommendations

Key Findings

Behavioral patterns surfaced in the data

4,597–7,443daily steps across the week
17–18 hsedentary time per day
7:00–7:47hours of sleep per day
27–53 minawake in bed before sleep
1,853–2,004calories burned per day

Recommendations

Turning patterns into product ideas

01

Use inactivity reminders and short guided stretching prompts when sedentary periods become prolonged.

02

Personalize exercise suggestions using historical behavior and wellness objectives.

03

Explore messaging for office-based professional women, reflecting the high sedentary-time pattern in the sample.

04

Use sleep goals, gamification and educational wellness content to support engagement beyond activity tracking.

Stack

Tools & analytical skills

ExcelData CleaningExploratory AnalysisVisualizationBusiness Recommendations