Read Time: 3 minutes

Morning crunchers! The Query here — the data newsletter that's like a well-crafted visualization in Plotly for your data career, turning raw data into beautiful, interactive graphics that inform and inspire.

Here’s what we have for you today:

• A dashboard design guide and checklist for data analysts 💹 

• Analyze unicorn companies for your next portfolio project 🦄 

• How to extract part of a string in SQL ✂️

• A funny to brighten your day 🤣

def learn_data_analysis(👨‍💻):

1. The Ultimate Guide to Dashboard Design and Development

Picking the right visualization to create and how to design a dashboard are key concepts you’ll need to understand in your data analyst learning journey.

Prince Patni created an EPIC guide that goes super deep into building dashboards and even provides a checklist for the next dashboard you develop.

Check it out here.

select * from dataset-of-the-week

This week’s dataset of the week is the Unicorn Companies Dataset by Deep Contractor on Kaggle.

A unicorn company is a private company valued at over $1b.

The dataset contains all Unicorns as of last March.

There are many interesting analyses you could conduct for a portfolio project.

Try taking this dataset and slicing it up by country, city, etc. What can you learn?

What industry are the fastest-growing unicorns a part of?

Which investors have the highest number of unicorn investments?

class MiniLesson:

How to Extract Part of a String in SQL

In SQL, string functions like STRPOS() and SUBSTRING() can be used to manipulate and extract specific parts of text data.

When you want to return all characters to the right of a specific character within a string, you can combine these functions to achieve the desired result.

STRPOS() is a function that returns the position of the first occurrence of a specified substring within a given string.

In combination with other string functions like SUBSTRING(), you can extract parts of a string based on the position of a specific character.

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

We want to extract the file names, which are all characters to the right of the last / in the file_path column.

We can use the STRPOS() and SUBSTRING() functions in a query to achieve this:

In this example, the STRPOS(file_path, '/') function finds the position of the first occurrence of / in the file_path column.

We add 1 to this position to start from the character immediately after the /.

Finally, we use the SUBSTRING() function to extract the substring starting at the calculated position until the end of the string.

As a data analyst, understanding how to use string functions like STRPOS() and SUBSTRING() in SQL is essential, as it allows you to manipulate and extract specific parts of text data within your queries.

By combining these functions, you can perform complex text manipulation tasks, such as extracting characters to the right of a specific character, and enhance your data analysis capabilities.

import memes as 😂 

That’s it for today.

Stay crunchin’ folks and see you next week!

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