DataFrenchy

Applying for jobs and not getting responses is mentally draining and exhausting. However, if this is happening, you might be having one of these issues: 1) You’re applying to any random job that looks good and not focusing on the ones that are the best fit. 2) Your resume isn’t communicating a strong message (check out our resume review service here: https://lnkd.in/eRCDntUh ) 3) You’re not adapting your applying methods. This data analytics job market isn’t the best, however, you must adapt as you see the trends. ♻️ Consider sharing this with others if you found it helpful

At DataFrenchy, we recommend that people utilize LinkedIn's search abilities to find data roles, which is why we created our free Job Board! We do the work in finding these data roles posted by recruiters and data professionals on LinkedIn. Feel free to get access and learn more about our Job Board here: https://lnkd.in/exbHprbf

Our Intro to SQL class starts in 90 minutes! Make sure to sign up here to save your seat for our free class: https://lnkd.in/etsDJPtN We’ll see you there!

Happy to announce our next FREE webinar, Break into Data in 2025! Led by Chris French, you will learn what it'll take to break into the data analytics industry. Topics like technical tools, interviewing, networking, and more will be covered. Our live classes/webinars are limited to 50 spots so click this link to learn more and sign up: https://lnkd.in/eK8RFGWn All of our upcoming classes can be found here: https://lnkd.in/eiWREy2w

Here’s a breakdown of SQL joins!

If you’re a frequent Excel user, you really should explore Power Query. A couple of years ago, I remember having to combine data from sources like PDFs, databases, and CSVs. Healthcare companies liked to make my life difficult lol. That’s when I found Power Query and my everyday work changed for the better. Whether you want to automate, clean data, or completely pivot your data, Power Query can truly elevate your Excel reporting. Anything else you’d add? ♻️ Please repost this if you found this helpful

Here are some remote data analytics roles we've found posted by recruiters and data professionals on LinkedIn: - Data Scientist- Brand Marketing at The Home Depot: https://lnkd.in/e8F9_HNa - Media Analyst at Vision Insights: https://lnkd.in/ebGAq37k - Risk and Controls Analyst, Cash App at Cash App: https://lnkd.in/eJB4w9nc - Senior Logistics Analyst at Harbor Freight Tools: https://lnkd.in/eUnDrzZ6 - Analyst, People Operations at American Cancer Society: https://lnkd.in/ePzd4CGM If you'd like to check out the other roles we have, feel free to get access to our FREE Data Analytics Job Board here: https://lnkd.in/exbHprbf

If you are learning SQL, you should focus on the fundamentals like the following: - SELECT/FROM - WHERE - AND/OR/BETWEEN/LIKE - NULL - SUM/COUNT/AVG/MIN/MAX - ORDER BY - GROUP BY - LIMIT - HAVING Learning these concepts will help you understand how to find and query data from a SQL database! You can learn these functions in our FREE Intro to SQL course here: https://lnkd.in/eMnFfykd

Check out our FREE SQL course here! https://lnkd.in/eMnFfykd

Using the fundamental functions in SQL is pretty straightforward. Here is a simple breakdown of them: - SELECT tells SQL what data you want to retrieve. - FROM tells SQL where to look for the data. - WHERE is used to filter records based on certain conditions. - Conditions like OR, BETWEEN, and others filter for what you are looking for. - Aggregate functions like COUNT, SUM, and AVG perform calculations. - ORDER BY is used to sort the results in ascending or descending order. - LIMIT restricts the number of rows returned by the query. - GROUP BY is used to group rows that have the same values in specified columns. - HAVING is like WHERE, but it’s used to filter groups created by GROUP BY. When working with SQL, try to think logically about what function would make sense for what you are trying to accomplish. With some practice and repetition, you can learn these concepts with ease. If you’d like to learn these fundamental functions in SQL, I am releasing my free Intro to SQL course tomorrow! I will link my newsletter in the comments as the 2,000+ people on it will get notified first. I will also link a free Intro to SQL live class I am doing next week! This gives you a chance to learn these concepts in a live, engaging environment. Feel free to reach out with any questions.