Mike's Comics
Mike's Comics is a fictional brick and mortar comic books store named after a friend. It's well established locally and looking to scale.
Why this Demo?
- I wanted a tangible example of the kind of service I can provide. This endeavor helped tremendously in clarifying what my keystone offering even is. Since I like comics, I generated a batch of sales transactions, ran an analysis on it and wrote the report.
-
This exercise has helped me frame the basic skeleton I intend to use
to help people either identify or solve whatever problem they might
have.
- Snapshot: Key weekly figures
- Momentum: How sales/trends are changing
- Monthly Pacing: Progress vs goals
- Annual Perspective: Context for growth
- Spotlight: Deep dive on a notable product/category
Data Schema Used
-
The data schema was
quite simple, but
offered enough opportunity for interesting things to show up in the
data.
timestampproduct_nameunit_pricequantitytotal_pricepayment_method