Applied analytics and data science for business decisions
Frame the question, check the data, and explain what the results support.
WHAT THIS SITE IS ABOUT
As analysts, we can query data and make charts. However, the harder part usually is figuring out what the question really means, whether the data lines up, and what the results actually support.
This site focuses on the workflow between the data and the decision. I share practical SQL and Python walkthroughs that show how I frame the question, check the data, structure the analysis, and explain the results in a way that is clear enough to use.
WHAT YOU’LL FIND HERE
SQL
Readable queries for real business questions, with attention to definitions, grains, joins, edge cases, and reconciliation.
Python
Data checks, summaries, visuals, and workflows that show what the data supports and what still needs validation.
Business Thinking
Clear framing before code so assumptions are visible, definitions are explicit, and the analysis stays connected to the decision.
WHAT YOU WON’T FIND HERE
Deep Learning
No deep learning or AI infrastructure. Modeling appears when it serves a specific business question.
Advanced Statistics
No textbook lessons. Just enough statistical reasoning to think clearly about uncertainty and tradeoffs.
Isolated Concepts
No abstract examples or theory for its own sake. Everything ties back to a real dataset and business question.
WHO THIS IS FOR
This site is for people who know the tools but want a repeatable way to turn real business questions into defensible analysis. If you know the tools but sometimes get stuck on how to frame the problem, check the data, or explain the result, this is for you.
Aspiring data and business analysts who want a practical workflow.
Analytics professionals looking to deepen their technical workflow.
Analysts who know syntax, but struggle with definitions, grain, and messy data.
You can start with the latest posts or read more About how I approach data work.
PROJECTS AND NOTES
Articles on this site fall into two categories: Projects and Notes. Projects are hands-on walkthroughs built around a specific dataset, analysis, or technical problem. Notes are shorter pieces focused on ideas, methods, and lessons from practice.
Browse by category
Projects | Notes
LATEST POSTS
IN PROGRESS
CFPB Complaint Narratives (Credit Card Topic Modeling)
Building a repeatable text analytics workflow using CFPB credit card complaint narratives to identify common complaint themes.
Follow along on GitHub: tivonio/python-cfpb-complaint-nlp