Imagine you’re a competitive intelligence analyst at a credit card issuer trying to identify consumer pain points in the credit card market. How can public complaint data be used to spot emerging risks and opportunities? In this post, I explore complaint narratives from the Consumer Financial Protection Bureau’s (CFPB) Consumer Complaint Database with Python, turning a vague question into a more structured view of recurring complaint themes.
Continue readingPosts by Tivon Johnson
How to Turn a Vague Business Question into an Analysis Plan
Good analysis starts with the right question. This post outlines a six-step framework for turning a vague business question into an analysis plan that is measurable, scoped, and tied to a real decision.
Continue readingHow I Used SQL to Find Early Churn Warning Signs
A stakeholder wants to know what is actually driving churn and which signals show up early enough to act on. In this practical SQL walkthrough, I compare support tickets, product usage, and recorded churn reasons before churn, then segment the results by plan tier to show that Basic, Pro, and Enterprise follow different churn patterns.
Continue readingWe Lost Customers, But Not Revenue: Measuring Churn Three Ways in SQL
A stakeholder says we lost customers, but Finance says revenue is fine. In this practical SQL walkthrough, I measure churn three ways and combine them into a month-end scoreboard that shows how both statements can be true.
Continue readingHow I Debug Revenue Mismatches in SQL
Two dashboards disagree on revenue. Here is the exact SQL process I use to isolate definition and timeline mismatches.
Continue reading