Capstone project of the Google Data Analytics Professional Certificate (Case Study 2), following the six phases Ask, Prepare, Process, Analyze, Share and Act. Python handles data preparation, analysis and charts; reproducing the reference indicators in Tableau is planned as an independent check.
π Full report: report/analyze_report.md Β· PDF version Β· Decision log: docs/decision_log.md Β· Licences: LICENSE-content.md
Data source: the data were downloaded from the Kaggle data set FitBit Fitness Tracker Data (MΓΆbius). The Kaggle page credits the original authors (Furberg, Brinton, Keating and Ortiz) and links their Zenodo record. See Β§ 4 and Β§ 14.
Disclaimer: this is an independent educational project. It is not affiliated with, endorsed by or sponsored by Bellabeat, Fitbit, Google, Coursera or Kaggle.
Bellabeat makes health-focused smart products for women (Leaf tracker, Time watch, Spring bottle, Bellabeat app, membership). This project analyses public usage data from non-Bellabeat fitness trackers to identify usage trends. It then turns these trends into high-level marketing recommendations for one Bellabeat product.
Analyse how consumers use non-Bellabeat smart devices, apply the insights to one Bellabeat product, and give high-level recommendations to guide Bellabeat's marketing strategy. The stakeholders are UrΕ‘ka SrΕ‘en (cofounder, Chief Creative Officer), Sando Mur (cofounder) and the executive team.
- What are some trends in smart device usage?
- How could these trends apply to Bellabeat customers?
- How could these trends help influence Bellabeat marketing strategy?
- Data set used: FitBit Fitness Tracker Data on Kaggle (uploaded by MΓΆbius; licence shown on Kaggle: CC0). All files used in this project were downloaded from this page.
- Original source: the Kaggle page credits Robert Furberg, Julia Brinton, Michael Keating and Alexa Ortiz and links their Zenodo record, Crowd-sourced Fitbit datasets 03.12.2016β05.12.2016 (RTI International, doi:10.5281/zenodo.53894). It is cited for attribution only; nothing was downloaded from Zenodo.
- Scope used: export of 12 Apr β 12 May 2016, three files:
dailyActivity_merged(940 rows, 33 Ids),sleepDay_merged(413 rows, 24 Ids),hourlySteps_merged(22,099 rows, 33 Ids). - Main limitations:
- 33 Ids, where the source describes 30 consenting users; the Id column is an "export session ID".
- One month of 2016 data, collected through a survey on Amazon Mechanical Turk.
- No demographic variables, so the sex, gender or age of participants are unknown.
- Sleep data cover only 24 Ids.
- The sample is not representative of Bellabeat customers.
-
Download the data set from the Kaggle page. Place the folder
mturkfitbit_export_4.12.16-5.12.16indata/raw/, which is ignored by Git. -
Check that your files match the ones used here (SHA-256 of the Kaggle download used for this project):
File ( Fitabase Data 4.12.16-5.12.16/)SHA-256 dailyActivity_merged.csv4b8f557eb29cd929cee7cc2d2a5e7704578bbffbc42c352e7b0c42bc4f3c6ac8sleepDay_merged.csv2d4250ca47dfc74263f1b61fe4ba3e338c83faab0d352fb0fefa93464b170e53hourlySteps_merged.csv83b9c1acc782b58a75a550f2f1d4ee9da7723e0ec26798b502768420cf6d7316 -
Rebuild the prepared data. The script checks 18 expected counts and stops if the input differs. Add
--overwriteifdata/prepared/already contains its quality files.
python scripts/process/bellabeat_process.py --raw-dir "data/raw/mturkfitbit_export_4.12.16-5.12.16/Fitabase Data 4.12.16-5.12.16" --out-dir data/preparedExpected outputs, their hashes and column details: data/README.md. Analysis, charts and checks: Β§ 12.
Raw and prepared row-level data are not hosted in this repository. They can be rebuilt from the Kaggle download with the steps above. Only aggregated results (tables and figures) and processing logs without individual Ids are published. The reason is that the redistribution rights of the downloaded files are not sufficiently established (see docs/licensing_note.md).
- Python 3.14 with pandas, NumPy and matplotlib: cleaning, analysis and charts.
- Windows PowerShell 5.1: read-only inventory and quality checks.
- Tableau: planned independent reproduction of the reference indicators (not yet done).
- Markdown: report and documentation.
- Raw files are never modified: their SHA-256 hashes are compared before and after the run.
- Cleaning steps:
- US date formats parsed explicitly;
Idkept as text;- 3 exact duplicates removed from
sleepDay(413 β 410 rows), the only rows deleted; - hourly totals joined to daily data in a 1-to-1 merge, with the row count checked (940 before and after).
- Atypical values are flagged, never deleted: 72 days with 0 steps and 1,440 sedentary minutes (F1), 4 days with
Calories = 0(F3, kept as is), incomplete hourly coverage, and other flags F1βF9 and H1. - Controls run by the script: 18 expected counts, re-reading of the written files, unchanged totals. An independent verification script is also provided.
Details: report Β§ C, data/prepared/transformation_log_public.csv, data/prepared/quality_report_before_after.csv.
- Descriptive statistics only: no significance tests, no causal claims.
- Each result is reported two ways:
- pooled (every Id-day weighs 1);
- per-Id (each Id weighs 1).
- Sensitivity analyses: without the 72 F1 days (S-F1) and without the 4 F3 days (S-F3). A change of 5 % or more, or any change of conclusion, is flagged.
- External thresholds (10,000 steps, WHO 150 min/week, CDC 7 h of sleep) are used only as indicative reference points, with their sources checked.
Descriptive observations for this sample; not causal and not generalisable to Bellabeat customers.
- Activity data are recorded almost continuously; sleep data are not. All 33 Ids have activity data (median 31 of 31 days), but only 24 have any sleep record and only 12 have 20 nights or more. A sleep record exists for 43.6 % of days.
- Most classified time is sedentary or light.
- 81.3 % of classified minutes are sedentary, 15.8 % light, and 2.8 % fairly or very active.
- Sedentary minutes depend on whether sleep was recorded, so they are not directly comparable across all days.
- Daily steps vary widely.
- Median: 7,406 steps per day.
- 32.2 % of days reach 10,000 steps.
- Mean daily steps range from 7,638 (all days) to 8,271 (without the F1 days).
- Clear activity rhythm.
- Weekday peak at 17:00β19:00 (640 steps/h at 18:00).
- Weekend peak at 12:00β14:00 (639 steps/h at 13:00).
- Sunday is the least active day in every specification tested.
- Sleep. Among Ids with sleep records, the median time asleep is about 7 h 13, and 55.9 % of nights reach 7 hours.
- Steps and calories. Within each Id, days with more steps go with higher estimated calories (median r = 0.87 across 32 Ids). This is an association, not a causal link.
These recommendations are hypotheses derived from a small 2016 sample of non-Bellabeat users. They are not validated with Bellabeat customers and should be tested on Bellabeat's own data. Product focus: Leaf or Time, with the Bellabeat app. The final product choice is still open.
- Make consistent sleep tracking a central promise and an onboarding goal. Activity is recorded for all Ids but sleep only partially (24 of 33 Ids, 12 regularly). The data show that sleep is recorded less often, not why.
- Replace a single 10,000-step message with personalised, progressive activity goals. Activity levels differ widely between Ids, and only 32.2 % of days reach 10,000 steps, which is a popular target rather than an official guideline.
- Time reminders and content to the observed activity rhythm, then A/B test them. The weekday evening peak, the weekend midday peak and the low-activity Sundays are stable patterns. Whether users respond better to messages at those times is untested.
Full reasoning, evidence and limits: report Β§ 10.
bellabeat-case-study/
βββ README.md
βββ requirements.txt
βββ .gitignore Β· .gitattributes
βββ LICENSE (MIT, code) Β· LICENSE-content.md (licence scope, CC BY 4.0 content, third-party exclusions)
βββ report/analyze_report.md # full report: six case-study deliverables
βββ data/
β βββ README.md # sources, licences, how to obtain raw data
β βββ prepared/ # public transformation log + quality report (cleaned CSVs rebuilt locally, not published)
βββ scripts/
β βββ process/ # cleaning (bellabeat_process.py) and verification
β βββ analysis/ # descriptive analysis -> results/tables
β βββ visualization/ # charts -> results/figures
β βββ checks/ # read-only inventory and quality checks
β βββ publication/ # builds the *_public files (no raw rows, no individual Ids)
βββ results/
β βββ tables/ # aggregated tables (CSV), analysis_results.json, per-Id tables as *_public summaries
β βββ figures/ # six PNG charts
βββ docs/
β βββ decision_log.md # validated decisions and script provenance
β βββ licensing_note.md # rights by content type (licence not yet chosen)
β βββ raw_file_inventory_public.csv # inventory of the 29 raw files (metadata only)
βββ tests/README.md # how to run the verification checks
python -m venv .venv.venv\Scripts\activatepip install -r requirements.txtThe commands below are run from the repository root.
1. Rebuild the prepared data from the Kaggle download: see Β§ 4.2. To check the input without writing anything, add --dry-run instead of --out-dir.
2. Analysis and charts (from the rebuilt prepared data):
python scripts/analysis/bellabeat_analyze.py --prepared-dir data/prepared --out-dir results/tablespython scripts/visualization/bellabeat_share_charts.py --prepared-dir data/prepared --out-dir results/figuresThe analysis script also writes per-Id tables (a1_usage_per_id.csv, a5_sleep_per_id.csv) and the cleaning script writes transformation_log.csv with Ids. These files stay local (ignored by Git); their public versions are rebuilt with:
python scripts/publication/make_public_versions.py3. Checks. verify_outputs.py requires the raw data and the run_metadata.json produced by step 1; counter_check.py requires the rebuilt prepared data. See tests/README.md.
python scripts/process/verify_outputs.pypython scripts/checks/counter_check.pyAll scripts were run on Windows with Python 3.14.7 and reproduced the original outputs byte for byte (expected hashes of the prepared files in data/README.md). Other platforms and versions have not been tested.
- Small, self-selected sample (33 Ids, recruited through Amazon Mechanical Turk); one month in 2016; Fitbit users only.
- No demographic data. The project makes no assumption about the sex, gender or age of participants, and does not equate them with Bellabeat's customers.
- Calories, intensity minutes and sleep are device estimates from undocumented algorithms. Sedentary minutes depend on sleep tracking.
- Participants are identified only by numeric session Ids, with no direct identifiers. Neither raw nor prepared row-level data are redistributed in this repository; published tables are aggregated, and the few Ids mentioned in processing logs are replaced by neutral references.
- Results are descriptive associations; the recommendations are hypotheses to test.
- MΓΆbius. FitBit Fitness Tracker Data [Data set]. Kaggle. https://www.kaggle.com/datasets/arashnic/fitbit (licence shown on Kaggle: CC0). Source of the files used in this project.
- Furberg R., Brinton J., Keating M., Ortiz A. (2016). Crowd-sourced Fitbit datasets 03.12.2016β05.12.2016 [Data set]. Zenodo. https://doi.org/10.5281/zenodo.53894 (licence shown on Zenodo: CC BY 4.0). Original source credited by the Kaggle page.
- Google / Coursera. Case Study 2: How can a wellness company play it smart? Google Data Analytics Professional Certificate (case brief; not redistributed here).
- Tudor-Locke C., Bassett D.R. (2004). How many steps/day are enough? Sports Medicine, 34(1), 1β8.
- World Health Organization (2020). WHO guidelines on physical activity and sedentary behaviour.
- Centers for Disease Control and Prevention. About Sleep. https://www.cdc.gov/sleep/about/
The data were downloaded from the Kaggle data set FitBit Fitness Tracker Data (MΓΆbius). Kaggle shows the licence CC0, and use of the site is subject to Kaggle's terms of use. The Kaggle page credits the original authors, Robert Furberg, Julia Brinton, Michael Keating and Alexa Ortiz (RTI International), and links their Zenodo record (https://doi.org/10.5281/zenodo.53894), which shows the licence CC BY 4.0. The Kaggle files have not been compared with the Zenodo archives, so this project does not claim that the Zenodo licence applies to the Kaggle copy. The original authors are credited in any case.
Changes made in this project: duplicate removal, date formatting, derived columns and quality flags, aggregation into statistics and charts. Raw and prepared row-level files are not distributed here (see Β§ 4.3).
- Code (
scripts/and the hand-written LaTeX sources inreport/latex/): MIT License, Copyright (c) 2026 LUMU BAMANA MANASSE. - Original report text, figures, aggregated tables and documentation: CC BY 4.0, Copyright (c) 2026 LUMU BAMANA MANASSE (author of the report; GitHub pseudonym MediJr).
- Third-party material is excluded from both licences: the data set, the case-brief scenario and questions, quotations, trademarks, the fonts embedded in the PDF and the software dependencies.
Exact scope: LICENSE-content.md. Background: docs/licensing_note.md.
This is an independent educational project for the Google Data Analytics Professional Certificate. It is not affiliated with, endorsed by or sponsored by Bellabeat, Fitbit, Google, Coursera or Kaggle. Their names are trademarks of their respective owners.





