The Query (aka Kyle and Cody) here 👋

Here’s what we have for you today:

• Is pursuing a Data Analyst career even worth it? 🤔

• Simplify your CASE statements in SQL 💻

• One of these data jobs could be your next role! 💼

• A meme that I’ve definitely experienced 🤣

Looking to become a Data Analyst? START HERE.

select * from data-jobs

remote, data jobs

Because who likes writing SQL from a busy office?

Check out this week’s featured jobs.

1. Data Analyst, Sustainability @ Danaher — $50-75k per year

2. Data Analyst @ Podium — $mid-level (unlisted)

3. Senior Analyst, FP&A @ Vail Resorts — $75-95k per year

4. Analytics Engineer, Finance @ Descript — $150-190k per year

The feedback and ideas so far coming from you all about the job board has been fantastic! Keep it coming here.

freelance gigs

Need work experience? Get real experience with real projects.

1. PowerBI Analyst — $20-75 per hour (apply here)

2. BigQuery SQL Help — $10 fixed price (apply here)

3. Make Tableau Charts — $80 fixed price (apply here)

def content_spotlight(🔦):

Is pursuing a Data Analyst career even worth it? Are there really entry-level jobs? How is the pay?

Hear what people in the industry have to say — check out the comments and dialogue for this discussion here.

Here are a few highlights that stood out to me:

• “It takes a lot of persistence and luck. It took me 3 months of studying and learning SQL to land my current job. [...] The job posting stated that they wanted 3+ years of experience and a bunch of other things I did not have. But I applied anyways, got an initial interview, aced the technical and soft skills interviews and got the job.”

• “First, it’s not entry level. Find a company you like then work your way into the dept. second, I’d say pay is good, not full stack developer good, but I’m comfy”

• "It’s entirely possible. Majority of business don’t even have an analytics /research department yet. It will only grow from here. I taught it to myself for a year and got hired last October at a large company in my city. Learning more every day! Pay is good also depending on your employer of course.”

Overall, the sentiment is mixed. But by reading real conversations like this, you can learn a lot about whether pursuing this career is right for you!

class SQLMiniLesson:

Simplify Your CASE Statements

Kyle here 👋 — Did you know you can simplify your CASE WHEN statements in SQL?

This can make your life a lot easier when you have a lot of conditions.

I was writing SQL for years before I learned this.

Here's how…

A typical CASE statement for classifying countries would look something like this:

CASE WHEN country = 'United States' then 'US'
     WHEN country = 'Canada' then 'CA'
     ...
     ELSE 'Other' END as country_abbv

To reformat this in a simpler way you can write it like this (image below):

This simpler approach prevents you from having to write out the entire condition 'country =' for each statement.

Adding little shortcuts like this to your repertoire can make your life as a data analyst much easier!

One caveat is this will only work when your condition is a literal match like column = 'something'. It won't work with other types of comparison like greater than, LIKE, etc.

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. 

4. LinkedIn: We create content on LinkedIn daily. You can follow Cody here and Kyle here.

That’s it for today.

Stay crunchin’ folks and see you next week!

— Kyle & Cody

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