Analyze Free Trial Data and Present Insights

Take-home: given data related to a free trial, explore the data, identify key insights, and present them (then walk through it in a live review).

Asked as a take-home assignment followed by a live review. The work should demonstrate practical data exploration, metric definition, insight prioritization, and clear communication.

Requirements

1. Inspect and validate the supplied data, documenting relevant quality issues and assumptions.
2. Define the primary free-trial funnel metrics, including trial starts, activation, trial completion, and conversion to paid.
3. Calculate and segment the metrics to identify meaningful patterns, drivers, or user groups.
4. Present the most important insights with supporting analysis and visualizations.
5. Recommend actionable next steps and explain how you would measure their impact.
6. Be prepared to walk through your methodology, decisions, and conclusions in a live review.

Data Available

A dataset related to free-trial users and their activity is provided for exploration. Use the available tables, fields, and documentation to determine the appropriate grain, joins, time windows, and metric definitions. Do not assume business targets that are not supported by the data.