Connecting the Dots

Everything is and can be connected, it is up to us to find the pattern.

Exploring ideas through data, code, and curiosity. A collection of projects, experiments, and lessons along the way.

see how

Case notes

Problems, approaches, and what I learned.

A few working examples, including the assumptions and limitations that shaped them.

Working example

A sales reporting exercise

Working example

Where is revenue changing, and which regions or products need a closer look?

Data
Illustrative retail orders, targets, products, and regional sales data.
Approach
I used a simple star schema and a small set of measures, then compared company-level totals with regional and product detail.
Notes
The exercise was a reminder that target definitions and comparison periods need to be settled before the dashboard layout.
  • Power BI
  • DAX
  • SQL
Working example

Which customer behaviors might be useful early signals of churn?

Data
Illustrative subscription, support, tenure, and account-activity records.
Approach
I cleaned the customer history and compared churn across a few cohorts, while keeping correlation separate from explanation.
Notes
Several segments looked worth investigating, but the sample was better suited to forming questions than making causal claims.
  • Python
  • pandas
  • Seaborn

Modeling exercise

A small analytics warehouse

Working example

How might several reporting sources be brought together without hiding their differences?

Data
Illustrative CRM, finance, and product-usage sources.
Approach
I defined the grain, sketched shared dimensions and fact tables, and added a few checks around incremental loading.
Notes
The difficult part was not the schema itself, but deciding where apparently similar business definitions were not actually the same.
  • SQL
  • Dimensional modeling
  • ETL

Side projects

Other things I make.

Data is the main thread, but not every useful or interesting idea begins with a dataset. This is room for the small tools, web experiments, and odd ideas I pursue on the side.

Small software

Tools for everyday friction

Focused utilities and interfaces built around a recurring annoyance, a missing shortcut, or a better way to do one thing.

Experiments

Ideas worth trying

Prototypes and browser-based explorations made to learn how something works, without needing to turn it into a data project.

Writing

Notes and observations.

Things I have noticed while working with reports, models, and imperfect data.

About & contact

A little context.

I work with analysis and business intelligence. Most of the interesting parts happen before a chart is finished: understanding the question, checking what the data can support, and deciding what should remain uncertain.

This site is where I keep examples and notes from that process. It also leaves room for side projects that come from a different kind of curiosity. None of them are final answers—just records of what I tried, what worked, and what I would reconsider.

Often using
SQL · Python · statistics
Working with
Star schemas · DAX · ETL
Thinking about
Power BI · dashboards · explanation
Still learning
Requirements · documentation · communication