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
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
Jun 14, 20244 min read
Maven Analytics - Live Show Notes - Level Up: From Analyst to Sr. Analyst 6-13-24
These are my personal notes from the Maven Analytics Mavens of Data Live Show, from the Level Up: From Analyst to Sr. Analyst episode on...
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
Apr 12, 20244 min read
The Power of Collaborative Projects in Data Analytics
Many aspiring data analysts, myself included, initially focus only on personal portfolio projects to improve their skills and showcase...
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
Mar 1, 20242 min read
A Day in My Life: The Lifecycle of a Data Project
Working at as a solo data analyst at a startup has it’s own unique challenges and rewards. It’s different from other analysts I know who...
bottom of page