31,000 transaction records across 3 relational tables including users, products, and sales. Records track point-based interactions and reward redemptions within a live digital community.
Use Cases
- Calculate customer churn by analyzing the time difference between entries in the dtVenda column.
- Determine product popularity by joining tb_vendas with tb_produtos on the idProduto key.
- Segment users into loyalty tiers based on the sum of pontosVenda per idUsuario.
Strengths
- Contains 31,000 rows in the tb_vendas table documenting point exchanges.
- Includes a tb_usuarios table with unique identifiers for program participants.
- Features a tb_produtos table listing items available for point redemption.
- Provides dtVenda timestamps for temporal analysis of user activity.