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,...
top of page
Blog
Search
Kelly Adams
Sep 304 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 53 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 144 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 248 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 225 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 124 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 155 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 12 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...
Kelly Adams
Feb 163 min read
Importance of Documentation as a Data Analyst
Documentation is a vital but it’s not talked about as much compared to the main analytical tools like SQL. I spend a lot more of my time...
bottom of page