Israel Startup Jobs’ Post

🔍 The Last way to secure a job Data Analysts 📊 I find this unique way on the internet which will increase your chances of selection. We can use it when HR is not giving proper feedback after the interview..... 😊 Share your thoughts on this strategy !! !! Disclaimer: Created for fun purposes. !! #DataAnalyst #JobOpportunities #InterviewPrep #DataInsights #CareerBoost #SQL #Python #PowerBI #LastHomeForDataAnalysts

Sharing my recent technical interview experience for the Data Analyst role, hope it will help! Continued from the last post. The interview started with the mandatory question, "Tell me about yourself". Below are additional technical questions that were asked: 1. Two tables are given, TableA with columns (CustomerID, Name, Address, Email) and TableB with columns (CustomerId, Mobile, Age) Write a query to add the column "mobile" of Table2 into the Table1. 2. Find the distinct customers from the above result. 3. Count the number of distinct customers from the above result. 4. Define many to many relationship with an example. 5. What do you understand by procedures and functions? 6. Define Data Types of: Name, Mobile_No., Email, Date, Address, Age 7. Two tables are given, now find the common values in between them. 8. Difference between Inner Join and Left Join with example. 9. Asked about V-LookUp (as it was mentioned in my resume) PS: You should know about almost everything that is mentioned in your resume 🙂 10. How you removed duplicates present in your data using Excel? 11. Asked me to explain my Python project, then questioned me why I have particularly used Python in this project to perform data analysis? 12. Explain Exploratory Data Analysis (EDA). Let's connect and exchange our experiences and support each other on our data journey 🙌 #technicalinterview #dataanalyst #sql #python #advancedexcel

Great tips! Dissecting the initial problem into smaller steps is key

Here is my foolproof approach to ace SQL interview: (That landed me offers from Meta, Google, Amazon and more.) I recently did an analysis that showed • 95% of Data Scientist jobs require SQL • 67% of Data Analyst jobs require SQL But everyone knows SQL these days. So you won't land the job by being good at SQL. You need to be outstanding at SQL. What does this mean in your interview? ✅ You answer with a quick and structured approach ✅ You provide suggestions for improving the query ✅ You catch any errors before your interview does ——— Here is my 6-step framework to ace any SQL interview 1/ Reframe the question & ask clarifying questions 2/ State assumptions you have about the data 3/ Outline your approach and methodology 4/ Fill in your SQL query (talking aloud) 5/ Review your query: catch any errors 6/ Suggestions to improve the query

Here is my foolproof approach to ace SQL interview: (That landed me offers from Meta, Google, Amazon and more.) I recently did an analysis that showed • 95% of Data Scientist jobs require SQL • 67% of Data Analyst jobs require SQL But everyone knows SQL these days. So you won't land the job by being good at SQL. You need to be outstanding at SQL. What does this mean in your interview? ✅ You answer with a quick and structured approach ✅ You provide suggestions for improving the query ✅ You catch any errors before your interview does ——— Here is my 6-step framework to ace any SQL interview 1/ Reframe the question & ask clarifying questions 2/ State assumptions you have about the data 3/ Outline your approach and methodology 4/ Fill in your SQL query (talking aloud) 5/ Review your query: catch any errors 6/ Suggestions to improve the query 𝘔𝘰𝘳𝘦 𝘥𝘦𝘵𝘢𝘪𝘭𝘴 & 𝘦𝘹𝘢𝘮𝘱𝘭𝘦𝘴 𝘢𝘳𝘦 𝘪𝘯 𝘵𝘩𝘦 𝘤𝘢𝘳𝘰𝘶𝘴𝘦𝘭 𝘣𝘦𝘭𝘰𝘸 -- 𝘤𝘩𝘦𝘤𝘬 𝘪𝘵 𝘰𝘶𝘵! ——— ♻️ If you found this useful, please repost it. ❤️ I post about Data every day. Follow me for more!

There is a step marking in interviews. We should communicate, what we are thinking out loud. This will help interviewer to know our logical thinking process,and they might guide us too. Here is a detailed SQL interview guide:

Hey LinkedIn Fam! 🚀 Excited to embark on a journey of continuous learning and growth as I prepare for data analyst interviews! Join me as I tackle a question or two every day, covering a range of topics and difficulty levels in SQL and Python. I'll be sharing the questions, my approach, and the solutions right here on my LinkedIn page. Not only am I committed to sharpening my skills, but I also aim to support fellow aspiring data analysts in their interview preparation journey. Let's dive in together and elevate our capabilities! Question Link: https://lnkd.in/gTrPtYXB Approach: Using subquery MySql Query: SELECT employee_id FROM employees WHERE manager_id NOT IN(SELECT employee_id FROM employees) AND salary < 30000 ORDER BY employee_id ASC #DataAnalyst #InterviewPrep #SQL #Python #ContinuousLearning

In recent Data Engineer interviews, a common question involves using SUM() and CASE WHEN together in SQL queries. This technique, though not typically taught, is crucial for data analysis. Let's explore its simplicity and significance in interviews. 💡 🔍 Problem Statement: You're tasked with calculating the percentage of rows where the 'color' column equals 'red' in a dataset stored in a SQL table. SELECT   SUM(CASE WHEN color='red' THEN 1 ELSE 0 END) / COUNT(*) AS red_percentage FROM my_table; This code calculates the red percentage. You can extend this to analyze trends over time by grouping results by year or month. 📊 Mastering this technique not only showcases analytical skills but also highlights your ability to extract insights from data—essential in data engineering roles. 🚀 #interview #DataEngineering #TechTip #InterviewData #DataWorld #Learning #Data #interview

from my experience as I just started my journey as a data analyst who has been working on personal projects, I really recommend understanding the data you are working with because it boasts your confidence in your skills,it also makes the analysis interesting and makes you look forward to results/finding because of how invested you are.

Current state of an average person in Data Science job market - 500+ Applications 5 callbacks for interview 100 Rejection 395+ No-response i.e. no callback, no rejection, nothing This post is to let you know you aren't alone. I have talked to a dozen mentees over the last month who are facing the above This post is to let you know, sadly, this is common place. Hiring is cyclical - it will improve, but it will take time. This post is to let you know, it does get better. Keep working, get feedback, keep applying.