A/B testing and departmental growth.
This repository presents the analysis of an A/B test with an 110,000 customer base of a retail store.
Departmental growth is also analyzed, summarizing 8,234 sales transactions to
(i) display the department ranking in terms of growth, year-over-year (YoY),
(ii) reveal large-scale shifts in purchasing habits of subsets of customers, and
(iii) unveil overall trends across departments, to be mitigated and to be boosted, for future sales growth.
Tags: growth
, analytics
, ab-testing
![](https://private-user-images.githubusercontent.com/58894233/313550558-0f0291ad-678f-4691-af00-4a7caf108eef.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ1Mjk2NDQsIm5iZiI6MTcyNDUyOTM0NCwicGF0aCI6Ii81ODg5NDIzMy8zMTM1NTA1NTgtMGYwMjkxYWQtNjc4Zi00NjkxLWFmMDAtNGE3Y2FmMTA4ZWVmLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MjQlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODI0VDE5NTU0NFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWNmODMzYzhhZTJjZTVlM2M1YTMwNGM3NmI3MGQ0ZGUxMzQxM2JmMmY0Njc0MzhlOTQ1NTM3MDg2NDczYzY2YWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.v2n1Co8YCLlQB7INUpUWryuKq8GwebDAX8O9eSy6xfg)
Carving out predictability.
This repository uses seasonal patterns as a tool in identifying areas of what can be predicted within certain ranges. It is part of a study on marketplaces. Focusing on the issue of timeliness, a framework of analysis is proposed, designed to bring to light the points of match and contrast in the typical daily and weekly schedules of supply and demand.
The proposed approach enables an at-a-glance insight into the following questions:
« Are there any significant differences between preferred schedules on the supply and demand sides? »
« If so, when do the most critical disparities occur? »
Tags: product-analytics
, sql
, bigquery