Hello fellow data cruncher!

The Query here 👋

Here’s what we have for you today:

• An EPIC financial dataset 📊

• A SQL tip using a little known function 👨‍💻

• Freshly posted data analyst jobs 💼

• A couple memes to put a smile on your face 🤣

Looking to become a Data Analyst? START HERE.

Quick Update: The Query newsletter will be moving to a bi-weekly schedule on Fridays. I'm currently focusing on some exciting projects and want to ensure each newsletter is high-quality and valuable.

By sending out two well-crafted newsletters a month, I will be able put more time into each edition. Thank you for your support, and I hope you continue to find the newsletter beneficial.

select * from data-jobs

remote, data jobs

Looking for a new job?

We cultivate the best data analyst jobs from around the internet to make your search easier.

Check out this week’s featured jobs.

1. Data Analyst @ Mediavina — $110-120k per year

2. BI Data Analyst @ Two95 International — $100k per year

3. Business Intelligence Engineer @ Zone & Co — $90-110k per year

freelance gigs

Need work experience? Get real experience with real projects.

1. Freelance data analyst — $80 fixed (apply here)

2. Create Excel Dashboard — $20-50 per hour (apply here)

3. Tableau consultant — $35-60 per hour (apply here)

def content_spotlight(🔦):

Ever wonder what goes on inside the mind of a Data Analyst hiring manager?…

You’re in luck if you have.

Trenton Huey is the Director of Data at Vida Health.

In this interview, he answers questions like:

• What skills/qualities do you look for when interviewing candidates for a data analyst position?

• What are common data analysis projects?

• If you had to start over your career, what would you do differently?

Enjoy!

dataset_of_the_week(🔢):

Every once in a while I come across a dataset that is just epic.

Finnhub released a massive dataset of ten years of stock financials data from 2010-2020.

It includes income statement, balance sheet, and cash flow statements for 10,000+ companies spanning a decade.

If you’re interested in financial data this is great resource!

class SQLMiniLesson:

Check Divisibility with MOD

Kyle here 👋 — As a data analyst, you may encounter situations where you need to determine if a number is divisible by another number.

This can be useful for a lot of things like checking if a number is odd or even.

In SQL, the MOD function can be a useful tool for achieving this goal.

The MOD function returns the remainder of a division operation, making it easy to check for divisibility.

It takes two arguments: the dividend and the divisor.

If the result is 0, it indicates that the dividend is divisible by the divisor.

Let's consider an example where we have a table named numbers with the following data.

We want to find the numbers in the table that are divisible by 5.

In this case, we can use the MOD function in combination with a WHERE clause.

In this example, the query uses the MOD function to filter the rows where the value is divisible by 5 (i.e., the remainder of the division by 5 is 0).

As a result, we get a list of numbers in our dataset that meet this condition, which are 20, 25, and 30.

Using the MOD function in SQL is handy tool for working with numerical data.

It allows you to quickly identify and filter rows based on divisibility, which can be helpful for various data analysis tasks, such as generating reports, identifying trends, or performing calculations on specific subsets of your data.

import memes as 😂 

content & resources 🤓 

1. YouTube Channel: Click here for videos on SQL and data analytics.

2. Become a Data Analyst Guide: Our full guide on what it takes to land a job as a data analyst.

3. Open Data Analyst Jobs: Find your next data job here!

4. Download our SQL Cheatsheet as a PDF and desktop wallpaper here.

5. LinkedIn: I regularly post data content on LinkedIn.

That’s it for today.

Stay crunchin’ folks and see you next week!

— Kyle

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -