Given a dataset, how would you analyze it or solve the problem?
Use the provided relational dataset to produce a concise monthly analysis for January through March 2025. Include qualifying accepted records with matching event details, while retaining entities and months with no qualifying activity.
Output
- One row per entity and calendar month.
- Columns:
entity_name, segment, month, accepted_records, total_amount, prior_month_total, pct_change, and segment_rank.
- Include all entities for all three months, calculate percentage change only when the prior total is positive, rank entities within each segment and month by total amount descending, and order by
segment, month, segment_rank, and entity_name.
