Good morning data cruncher!

The Query here 👋

Here’s what we have for you today:

• A cool Amazon logistics dataset 📊

• A function for combining text in SQL 👨‍💻

• Interesting freelance projects 💼

• More hilarious memes 🤣 

Looking to become a Data Analyst? START HERE.

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 Intern @ Second Bind

2. Analytics Consultant @ Focus Strategies — $85-115k per year

3. Business Intelligence Manager @ Our Home

freelance gigs

Need work experience? Get real experience with real projects.

1. Amazon Orders Analysis — $200 fixed (apply here)

2. Data Studio Help — $100 fixed (apply here)

3. Power BI Dasboard — $58-96 per hour (apply here)

dataset_of_the_week(🔢):

It’s always exciting when data helps us uncover valuable insights.

This week's dataset takes us into the world of logistics and delivery operations.

Introducing the Amazon Delivery Dataset.

With data on over 43,632 deliveries across multiple cities, this dataset offers a comprehensive view of Amazon's last-mile logistics operations. It includes detailed information on order specifics, delivery agents, weather and traffic conditions, and delivery performance metrics.

This dataset is particularly fascinating as it allows for the exploration of critical research questions, such as identifying factors influencing delivery efficiency, pinpointing areas for optimization, and examining the impact of various variables on the overall customer experience.

class SQLMiniLesson:

A Function for Combining Text in SQL

Working with strings in SQL is one of the most common things you do as a data analyst.

As a part of that, you may need to combine the values of multiple columns or strings in your SQL queries.

One useful function for this purpose is the CONCAT function.

In this lesson, we'll introduce you to the CONCAT function and explain how it can be helpful in your SQL queries.

What is CONCAT?

The CONCAT function is used to concatenate (or join) two or more strings or column values together.

It returns a single string that is the result of combining the input strings in the order they are provided.

The basic syntax for the CONCAT function is:

CONCAT(string1, string2, ..., stringN)

Suppose we have a table called employees with the following columns: first_name, last_name, and email.

We want to create a query that returns a full name by combining the first_name and last_name columns.

In this query, we use the CONCAT function to join the first_name and last_name columns, separated by a space character.

The result is aliased as full_name.

By using this function, you can easily create new strings by joining existing ones, which can be useful for formatting.

P.S. Another cool thing CONCAT can do is create a unique key on your table. If none of the columns are unique by themselves but a combination of columns is unique, then you can just concatenate them together to create a unique key.

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

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