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.
Funnels with SQL
Don't build funnels in SQL. Unless you have to.
Best BigQuery Datasets
A list of the most useful public datasets available to query through BigQuery.
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.
Share your email and I'll notifiy you when there's a new post
