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...
top of page
Blog
Search
Kelly Adams
May 248 min
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
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
May 103 min
How to Document Your Portfolio Projects
Recently, someone asked me “is there an ideal format for documentation of projects in a portfolio?” and “what type of information should...
Kelly Adams
Apr 264 min
How to Validate SQL Query Results
As a data analyst, how do I make sure my SQL queries return the correct results? Unlike in courses there’s no single correct answer. A...
Kelly Adams
Apr 124 min
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 269 min
Deep Work Dashboard 2023
This is a detailed article about my Deep Work Dashboard 2023 project where I analyzed my deep work data from 2023. I used the following...
Kelly Adams
Mar 155 min
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
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 212 min
Cover Letter Template
Below is the template I used when I was job searching for my first data analyst role. I didn’t include my full cover letter with my...
bottom of page