Tag Archives: SQL

Mastering the Job Interview Process: A Guide for Data Science and Analytics Students 

Posted on by
screen shot of interview app

The most nerve-racking part of securing a job offer is the job interview process. After spending an entire year mastering technical concepts, building projects, and gaining hands-on experience, it all culminates in the crucial moments sitting across from potential employers. Whether you are applying for full-time roles or rotational programs, Continue reading Mastering the Job Interview Process: A Guide for Data Science and Analytics Students →

Getting Started with PostgreSQL and TablePlus 

Posted on by
code screenshot

Whether you’re looking to learn a new tool, practice your database and SQL skills, or integrate something different into your personal project, open-source tools such as PostgreSQL and TablePlus are a great place to start! Last year, a teammate introduced me to PostgreSQL using TablePlus, and it’s been my favorite Continue reading Getting Started with PostgreSQL and TablePlus →

Interview with Lizzie Mabe

Posted on by
Headshot of Lizzie

Lizzie Mabe is a data scientist at Well, a health tech company that uses AI to help users track their health and build healthy habits. She is also an IAA graduate (class of 2024) whom I’ve had the opportunity to connect with last December during mock interviews. Olivia: What do Continue reading Interview with Lizzie Mabe→

Data Preprocessing: SQL vs. Python

Posted on by

Raw data could be messy and inconsistent. Before any meaningful insights can be generated, the first thing we need to do is to clean and explore the data, which leads us to the important question: what tool should we use to facilitate this crucial step? Generally speaking, there are two Continue reading Data Preprocessing: SQL vs. Python→