The Query (aka Kyle and Cody) here 👋

Here’s what we have for you today:

• Freshly-posted Remote data jobs and freelance gigs 💼

• An awesome Excel learning resource 📊

• A SQL function I use all the time for working with dates 📆

• A hilarious meme relating data to real life 🤣

Looking to become a Data Analyst? START HERE.

select * from data-jobs

remote, data jobs

Because who likes writing SQL from a busy office?

1. Data Analyst @ CDC Foundation — $60k per year (apply here)

2. Data Analyst @ TriWest — $68-77k per year (apply here)

3. Data Analyst @ Green Dot — $66-101k per year (apply here)

freelance gigs

Need work experience? Get real experience with real projects.

1. Build Dashboards from SQL — $20-50 per hour (apply here)

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

3. BI Dashboard Designer — $20-50 per hour (apply here)

def content_spotlight(🔦):

This week we are featuring a website with amazing Excel content called ExcelJet.

This site came highly rated by someone on Linkedin this week. I looked into it and I can say it is awesome!

They have all sorts of videos and tutorials with examples to help you master Excel.

Here’s a snapshot of the videos page to give you a taste:

I highly recommend checking out Excel Jet if you use Excel at all in your daily work. 📊

class MiniLesson:

The DATE_TRUNC Function

Kyle here 👋 — Data analysts often work with dates in their data. 

Knowing how to use the DATE_TRUNC function in SQL is important because it helps break down dates into useful time periods, like days or months. 

This makes analyzing trends and patterns in data much easier.

SQL Tip:

When using DATE_TRUNC, always specify two arguments:

1. Timestamp Column: The date or timestamp column that you want to truncate.

2. Time Unit: The unit to truncate to (e.g., year, month, day, hour).

This function returns a date truncated to the beginning of the specified time unit, making it easier to group and compare data across time periods.

SQL Code Example:

Let's assume we have a table sales with columns sale_date (a timestamp) and amount (sale amount). 

If you want to analyze monthly sales, you can use DATE_TRUNC to truncate sale_date to the month level:

In this query, DATE_TRUNC(sale_date, MONTH) truncates the sale_date to the first day of each month, and the SUM(amount) calculates the total sales for each month. 

The GROUP BY clause groups the results by the truncated date, allowing you to see the total sales for each month. 

Remember, the precision of DATE_TRUNC can be changed to other units like 'year', 'day', 'hour', etc., depending on your analytical needs!

import memes as 😂 

Excel can be just like real life!

content & resources 🤓 

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

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

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

4. Courses: Our course on showcasing your data portfolio is live!

That’s it for today.

Stay crunchin’ folks and see you next week!

— Kyle and Cody

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