top of page
Blog
Search
Kelly Adams
Nov 29, 20244 min read
SQL for Data Analysis Book Review
A review of the SQL for Data Analysis book going into what I liked, what I didn't, how I used it and who it's for.
Kelly Adams
Nov 15, 20245 min read
Building Better SQL Queries Through Understanding Data Structure
In data analysis, the focus is often on mastering tools or methods. But understanding the structure and flow of data is just as crucial,...
Kelly Adams
Sep 30, 20244 min read
What Tools I Use as a Data Analyst
I’ve talked a lot about what skills you should learn in some of my blog posts, specifically my How to Become a Data Analyst (Ultimate...
Kelly Adams
Sep 6, 202412 min read
My First Predictive Model: Code (Part 2)
In the first part of this blog series ( My First Predictive Model: Explanation Part 1 ), I explained my methodology to build my...
Kelly Adams
Jul 5, 20243 min read
How I Solve Business Problems with SQL
A common question I get asked is how I use analytical tools like SQL to make a business impact. I’m the only data analyst at a small...
Kelly Adams
May 24, 20248 min read
How I Saved 10 Minutes with a Python Script
I’ve been using Python more and more. I recently learned how to write SQL queries directly in a Python script (view that blog post here)....
Kelly Adams
May 22, 20245 min read
How to Run SQL in Python: Connecting to PostgreSQL and BigQuery
I’ve been wanting to use SQL in combination with Python for a while. As a data analyst I use SQL all the time and it’s great for getting...
Kelly Adams
Mar 15, 20245 min read
Behind the Scenes: Creating a SQL Course
Recently, I launched a free SQL course* on YouTube with Luke Barousse*. This project, which I've been working on for a few months,...
Kelly Adams
Nov 3, 20236 min read
How to Learn SQL
One of the most requested skills as a data analyst is SQL. According to datanerd.tech (an app built by Luke Barousse which collects data...
Kelly Adams
Oct 6, 20236 min read
The Reality of Using SQL Day-to-Day as a Data Analyst
I remember the first time I was handed real data at my job. I was feeling pretty confident with SQL due to my projects and courses. But...
bottom of page