Here are a dozen of the most common SQL interview questions you will see during an interview for a data professional role. I would highly suggest you attempt to answer the questions and write prospective queries for each question before you compare your answers to mine at the end...

After doing a little bit of research (AKA Googling), much of the financial advice seems to point you in one direction — open an IRA. Congrats! You made a significant step forward in your financial journey. Unfortunately, most of this discussion stops short of the next step — Which...

In every introductory statistics class, you are forced to learn about the basic descriptive statistics — mean, median, mode, and standard deviation. These calculations give you a quick summary of any dataset. The key word here is summary. In any summary, you zoom out to describe the dataset and...

The other day I was chatting with my father about the stock market when he mentioned that he liked General Electric ($GE) because it was cheap. I cringed immediately. Every time I hear someone use “cheap” to describe a stock it takes every ounce of my being not to...

I first ordered The Hundred-Page Machine Learning book back in May and am only just now finishing it up. In COVID-time, that was about 10 years ago. As you might have inferred, this book is NOT a quick read. What it lacks in easy reading, it makes up for...

In a world where everything is connected to the internet, and yes I mean everything (NSFW), the threat of being hacked is always present. The most recent notable security leak was with Robinhood. Bloomberg reported that “Almost 2,000 Robinhood Market accounts were compromised in a recent hacking spree that...

Agile can be defined as the ability to move quickly and easily. However, for those in tech they might associate agile with something else entirely. Agile methodology is a popular framework for managing software development projects. More specifically, it is a style of project management where you develop a...

While Voorhees, Statham, and Derulo all have their talents, both good and evil, I would propose that the best Json goes to the machine-readable file format. Json, or rather JSON, is an important acronym in the tech world. JSON stands for JavaScript Object Notation. It is frequently used by...

Coming out of college with a background in mathematics, I fell upward into the rapidly growing field of data analytics. It wasn’t until years later that I realized the incredible power that comes with the position. As Uncle Ben told Peter Parker (aka Spiderman), “With great power, comes great...

By Jeff Lundy I know a couple friends who model their retirement outcomes. Recently, I asked them what growth rate they assumed for investments. Interestingly, we all used a similar rate: 4%. That seems appropriately conservative, and by setting it low you bake in all kinds of uncertainties (taxes...