Hey there, fellow internet wanderers. My name is Jon. I’m a co-founder here at Ollie. Ollie is a social platform that allows you to connect with people doing things that interest you or with people who need your help — like someone who needs help moving or someone looking for…

A Guide to Pivot Tables for Beginner Python Data Analysts — Pivot Table Explanation Pivot tables go hand-in-hand with data analytics, but understanding them can be challenging. In this article, I’ll explain them methodically, which may clarify the concept if you have found them difficult in the past. In a pivot table, each row represents a group of aggregated data, and each column represents…

How Case Statements and Date Calculations Are Used in Business Reporting — When learning SQL, it often feels like you spend most of your time manipulating large blocks of code, moving them around (when joining), or consolidating them (when aggregating). But in the real world, SQL queries are driven by minutia at the field level. These field-level details are mainly crafted using…

A Straightforward Guide to Scope In Python for Coders On The Go — What is scope? In Python, scope is the context in which a variable is defined, and this context determines how a variable can be used throughout the code. There are three areas where you can define a variable: Outside a function. Inside a function. Inside a nested function (a function inside another function). …

An exploratory data analysis of how well talent predicted victory or defeat in college football — and what it means for TCU’s hopes of winning it all — A rare level of competitiveness between teams made the 2022 college football season especially thrilling. There were upsets. Fields were stormed. Goalposts were dislodged. And Michigan beat Ohio State in the horseshoe. And then there was the curious case of Texas Christian University making it to the college football playoff.

Learn The Advantages of SQL’s Least Popular Join — A lateral join combines two tables using a different syntax than typical joins. In a lateral join, the right-hand table is expressed as a subquery, and the join condition is specified within the WHERE clause of this subquery. If that sounds confusing, don’t worry. Succinctly describing how lateral joins work…

Sometimes you need a NoSQL database, but all you have is PostgreSQL — Software developers and data engineers often overlook the native JSON data type that many SQL databases support (like PostgreSQL, for example). Doing so is a mistake; Having the ability to store JSON within a SQL table is a game-changer. The JSON data type allows you to blend the relational benefits…

A Beginner's Guide to SQL Aggregate Functions — Aggregates are one of the most powerful SQL features. They are integral to data analysis and are pretty fun to write! In the SQL world, aggregates are functions applied to a group of rows to retrieve a single "aggregate" value. …

Read this article if you want to know PostgreSQL conditionals 🤖 — Welcome to part four of my series on PostgreSQL functions. In this article, I will cover conditional expressions. As you probably know, Conditionals are one of the most helpful control structures in programming. So let’s dive in! If Then Basics For the first example, I’ll create a function that takes in a single…