- The Query
- Posts
- 🤓 a NEW data analyst job board
🤓 a NEW data analyst job board
The Query
January 04, 2024
The Query (aka Kyle and Cody) here 👋
Here’s what we have for you today:
A special announcement 😄🚨
A peek behind the curtain at the Netflix analytics team 📊
A SQL lesson on window functions 💼
Gotta love a good SQL meme 🤣
🚨 special announcement 🚨
We’ve been working behind the scenes on something awesome…
We built a job board for data analyst!
We want to create the most useful, accurate, and comprehensive data job board in existence.
How?
By tailoring the experience specifically for data analyst.
For example, we have filters for the different types of data analyst job titles:
And if you’re looking for a job where you’ll use SQL and Power BI, there’s a filter for that too:
Since you’re a subscriber, you’re the first to know about this and we’d love for you to try it out.
We’re still working out the kinks, so please let us know if there are any bugs you find or features you think would be helpful to add (you can reply to this email).
There are over 50 open positions on the job board, but that’s just the start.
We’ll be updating the job board every Thursday and will be adding lots of new jobs from lots of new sources.
In future newsletters, we’ll talk about the process of building this job board.
It was a really fun data project (perfect for our portfolios).
Click here to check it out and see open data jobs!
select * from data-jobs
remote, data jobs
Because who likes writing SQL from a busy office?
freelance gigs
Need work experience? Get real experience with real projects.
Analytics BI Help — $100 fixed price (apply here)
Analytics Dashboard — $75-90 per hour (apply here)
Excel Dashboard — $$intermediate (apply here)
def content_spotlight(🔦):
Ever wonder what it’s like to work in analytics at Netflix?
Wonder no more, my friend!
If you’re like many readers of this newsletter, you’re working toward getting your first job as a data analyst.
As you prepare, it’s really helpful to read about what analytics is like at different companies because it’s like giving you a peak inside what your future will be like.
Netflix (part of the renowned FAANG) is world-class when it comes to technical roles, analytics included.
They have a technical blog where people that work in Analytics at Netflix write about what it’s like.
Give these two articles a read:
class MiniLesson:
How to Rank Values in SQL
Kyle here 👋 — Data analysts often have to rank data.
But this can be tricky because in SQL there are 3 ranking functions that do nearly the same thing.
The 3 functions I'm referring to are:
ROW_NUMBER
RANK
DENSE_RANK
So what’s different about them?
The main difference is in how they handle a tie (i.e. equal values).
Suppose you have a table called sales.
You want to rank the salespeople based on their sales amount.
The example data, query, and output are shown below with examples of each ranking function.
As you can see RANK, ROW_NUMBER, AND DENSE_RANK don't produce the same rankings.
ROW_NUMBER() assigns unique values to each row, even if the sales_amount is the same. It will not show any ties.
Use this if you want to make 100% sure you have a tie breaker.
RANK() assigns the same rank to the rows with the same sales_amount and leaves gaps in the ranking sequence.
This is similar to how a sporting event like golf would rank players in a tournament.
DENSE_RANK() assigns the same rank to the rows with the same sales_amount without leaving gaps in the ranking sequence.
Knowing the difference between these three can ensure you always use the right one!
import memes as 😂
content & resources 🤓
1. Become a Data Analyst Guide: Our full guide on what it takes to land a job as a data analyst.
2. Open Data Analyst Jobs: Find your next data job here!
3. Download our SQL Cheatsheet as a PDF and desktop wallpaper here.
That’s it for today.
Stay crunchin’ folks and see you next week!
— Kyle & Cody
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
What'd you think of today's newsletter? |