Sam Brand

Local LLMs for natural language processing on sensitive data

Use Ollama and Python to run Mistral locally for sentiment analysis and other NLP tasks.

Sentiment analysis with SQL and AI in BigQuery

Use SQL to access pre-trained AI models like Gemini so you can do sentiment analysis and other natural language processing tasks.

Histograms with SQL

Copy / paste and run these code snippets to do your own exploratory data analysis with SQL.

What do you want to learn?

Submit a response to let me know what most interests you.

Retention / Churn Analysis with SQL

Cohort retention is one of the most valuable tools in an analyst's toolbox. Here are a couple sample queries to get you started.

How to use BigQuery

Follow these instructions to set up BigQuery console and to run your first query, for free.

Best BigQuery Datasets

A list of the most useful public datasets available to query through BigQuery.

Funnels with SQL

Don't build funnels in SQL. Unless you have to.

I Learned SQL at the School of Stack Overflow

SQL is a super power. It can change your career. It changed mine.

Why Learn SQL

SQL is for analysts. Everyone is an analyst.

Case Study: Clipboard Health Lyft Pricing Exercise

Here is my answer to the Clipboard Health product case study. I didn't get the job.

SELECT FROM WHERE - Basic SQL Queries

Start here to run your first SQL queries on free public datasets.