Project Overview
Data analysis project examining 5 years of Amazon purchase history (42,000+ orders) for the Robbins family. Produced a mobile-optimized interactive spending report with visualizations.
Goal
Transform raw Amazon order data into an actionable, easy-to-read spending analysis with clear insights and no judgmental language.
Started
January 30, 2026
Days Active
55 days
Client
Robbins Family
Status
Delivered
Key Highlights
- •Analyzed 42,000+ row Amazon CSV (2020–2025)
- •Mobile-responsive HTML report with thumb-scroll UX
- •Multiple revision cycles refining tone and presentation
Expertise Delivered
Complexity
Moderate
2Complex
1Work Types
Feature
2Bug Fix
1Project Timeline— Started Jan 30, 2026
Jan 30, 2026
56h3 sessions
12:00 PMFeatureModerate
Robbins Family-Built mobile-responsive HTML report (single-column, thumb-scroll optimized)
-Embedded all 9 charts as images in self-contained HTML
-Collapsible sections, fade-in scroll animations, navigation dots
-Google Fonts integration, 17px body text, full-width charts
-1950s color palette carried over from PDF
-Packaged as deployable ZIP file
-Wrote step-by-step GitHub Pages deployment tutorial
htmlcssresponsive-designmobilegithub-pagesdeployment
10h of UX/UI Designer work
12:00 PMBug FixModerate
Robbins Family-Multiple revision cycles on tone (removed judgmental language, made fact-based)
-Added 3 new report sections: Executive At-A-Glance, Action Checklist, Note of Appreciation
-Renamed 'Other' category to 'DVD/CDs, Specialty Items, Misc.' with detailed breakdown
-Fixed page layout issues (Friends & Family title/chart/table alignment)
-Corrected data points (lifetime projection from $4.16M to $5.25M)
-Removed unnecessary sections (Orders vs Spending Comparison)
-Created professionally styled DOCX version with matching color scheme
-Added data labels to charts, expanded table column widths, added top-25 items by quantity
pythonreportlabpython-docxrevisionsformattingpdfdocx
14h of Senior Developer work
12:00 PMFeatureComplex
Robbins Family-Analyzed 42,000+ row Amazon order history CSV (2020-2025)
-Built product categorization engine (12+ categories from product names)
-Created 9 professional matplotlib charts (pie, bar, line, stacked, forecast)
-Custom 1950s-inspired color palette
-Generated 25+ page PDF report via ReportLab with cover page, TOC, executive summary
-Sections: spending overview, category breakdown, shipping destinations, 2025 review, top products, household benchmarks, cost optimization, 22-year spending forecast, action checklist
-Benchmark research comparing client spending to typical household costs
-Built inflation-adjusted 22-year forecast model with two scenarios
pythonpandasmatplotlibreportlabpdfdata-analysisvisualizationforecasting
32h of Data Analyst work