Read Time: 3 minutes

Hey crunchers! The Query here — the data newsletter that's like the perfect QUERY for your data career, filtering out the unnecessary and providing you the insights that matter.

Here’s what we have for you today:

• 5 common analytics mistakes to be aware of

• A food-related dataset 🥓 

• A cool way to quickly round numbers in SQL

• Meme time ⏰ 

def learn_data_analysis(👨‍💻):

1. Don’t make these 5 data analysis mistakes

Olga Berezovsky runs Data Analysis Journal and wrote a post showing common mistakes Data Analysts make.

Be aware of these mistakes so you can avoid them:

• Weighted scoring

• Reporting non-significant data in percentages

• Complex dashboards

• Overloaded charts

• Dropping empty values

Learn more about these mistakes so you can avoid them here.

select * from dataset-of-the-week

If you’re just starting your data analytics journey, give this week’s Dataset of the Week a 👀:

Nutritional Facts for Most Common Foods by Niharika Pandit.

I’d use this dataset for an Excel-only project.

Here are a few questions to look into:

• How do the various food categories compare to each other?

• Are there any outliers in any of the categories?

• Which foods are the most nutrient-dense?

class MiniLesson:

A Simple Way to Round Numbers in SQL

As data analysts, working with numerical data often requires rounding numbers.

In SQL there are a handful of different ways to do this.

Today, we’ll be discussing two useful functions for rounding numbers: CEILING and FLOOR.

These functions allow you to round numbers up or down, respectively, to the nearest integer.

CEILING: This function rounds up a given number to the smallest integer that is greater than or equal to the number.

It can be useful when you need to round up quantities, prices, or other numerical values in your dataset.

FLOOR: This function rounds down a given number to the largest integer that is less than or equal to the number.

It can be beneficial for rounding down numerical values to ensure conservative estimations.

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

We want to calculate the rounded prices for each product, using the CEILING and FLOOR functions.

In this case, we can use the following SQL query:

In this example, the query uses the CEILING and FLOOR functions to round the prices up and down, respectively.

As a result, we can see the rounded prices for each product in our dataset.

As a data analyst, understanding how to use the CEILING and FLOOR functions in SQL will undoubtedly come in handy when you need to use them!

import memes as 😂 

Our Content & Resources 🤓 

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

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

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

That’s it for today.

Stay crunchin’ folks and see you next week!

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