Most of you will use Excel to manipulate and plot the data you pull with SQL. Eventually, you’re likely to create charts for presentations to your management. If you sort your data with “ORDER BY” when you pull it in SQL, you’ll save time. As a result, you can skip the “Sort and Filter” step
Month: September 2020
When to use more complex joins
As you pull your data more often, you may encounter situations where you need more complex joins than what we’ve previously discussed. Here are some examples: You’re looking for something that did not happen: e.g. products without orders in the past 7 days. In this case, you need an outer join. Specifically, you would pull
Define your own metrics: Operators & conditionals
As you become confident with pulling data, you’ll start wanting more control over the metrics you report on. Hence, you’ll want to define your own metrics. Therefore, you’ll want to learn how to use operators and conditional statements. This Kaggle notebook contains all the code you need to follow along with the examples. Run cells