Cloudydata

🚀 Real SQL Interview Question Reported in a Swiggy Business Analyst Interview Question: Given an orders table with the following columns: driver_id order_time delivered_time Write an SQL query to calculate the average waiting/delivery time (in minutes) for each delivery partner. ✅ SQL Solution (MySQL) SELECT driver_id, AVG(TIMESTAMPDIFF(MINUTE, order_time, delivered_time)) AS avg_delivery_time FROM orders GROUP BY driver_id; 💡 Approach: • Calculate the time difference between order_time and delivered_time. • Convert the difference into minutes using TIMESTAMPDIFF(). • Group records by driver_id. • Use AVG() to find the average delivery time for each delivery partner. 📚 Concepts Tested: • Date & Time Functions • GROUP BY • Aggregate Functions (AVG) • Business Metrics React ♥️ for more real interview questions

Spyne is hiring Business Analyst 🚀 Min. Experience : 1 Year Location : Bangalore Apply link : https://spyneai.keka.com/careers/jobdetails/156284

Navi is hiring Business Analyst 🚀 Location : Bangalore Apply link : https://www.linkedin.com/jobs/view/4448516986/

Kapiva is hiring Data Analyst 🚀 Location : Bangalore Apply link : https://www.linkedin.com/jobs/view/4452960724/

🔥 Python Interview Concept You MUST Know: Lambda Functions Lambda Functions are one of the most frequently asked Python concepts in Data Analyst and Python interviews. They help you write short, anonymous functions in a single line, making your code cleaner and more concise. 📌 Key points: 🔹 lambda → Creates anonymous functions 🔹 Best for short, one-line operations 🔹 Often used with map(), filter(), and sorted() 🔹 Reduces the need for small helper functions 🔹 Improves code readability in functional programming 💡 Common interview use cases: ✅ Sorting with custom keys ✅ Filtering datasets ✅ Transforming values with map() ✅ Quick calculations ✅ Writing concise data-processing logic ❤️ React if you want more Python interview concepts explained in a simple way.

GIVA is hiring Business Analyst 🚀💎 Min. Experience : 1 Year Location : Bangalore Apply link : https://www.linkedin.com/jobs/view/4453116777/

Fampay is hiring Data Analyst 🚀 Experience : 2 Years Location : Bangalore Apply link : https://www.linkedin.com/jobs/view/4452371756/

🔥 SQL Interview Concept You MUST Know: CASE WHEN CASE WHEN is one of the most commonly used SQL concepts for creating conditional logic inside your queries. It lets you categorize, transform, and analyze data without modifying the original table. 📌 Key points: 🔹 CASE WHEN → Adds IF-ELSE logic to SQL 🔹 Creates custom categories based on conditions 🔹 Works with SELECT, ORDER BY, GROUP BY, and aggregates 🔹 Makes reports more meaningful and easier to understand 🔹 Ends with END to return the final result 💡 Common interview use cases: ✅ Categorizing customers by spending ✅ Creating salary or age bands ✅ Replacing NULL or missing values ✅ Building custom status labels ✅ Conditional aggregations using SUM() or COUNT() ❤️ React if you want more SQL interview concepts explained in a simple way.

Purplle is hiring Data Scientist 🚀 Min. Experience : 2 Years Location : Mumbai Apply link : https://app.turbohire.co/job/publicjobs/7hGGe0hK8Fez59vdYEKYl_aAayRIouekZ/DzcvWL9DucyMzENcVQuCffieAMMk9Y?so=li&src=linkedin

Cisco is hiring Business Analyst 🚀 Min. Experience : 1 Year Location : Bangalore Apply link : https://careers.cisco.com/global/en/job/CISCISGLOBAL2019147EXTERNALENGLOBAL/Business-Analyst?utm_source=linkedin&utm_medium=phenom-feeds

Clovity is hiring Data Analyst Freshers 🔥🚀 Location : Remote Apply link : https://www.linkedin.com/jobs/view/4451123334/

🔥 Python Interview Concept You MUST Know: List Comprehensions 📌 The most important patterns: 🔹 Basic List Comprehension → Create a new list in a single line 🔹 Conditional Filtering → Keep only the elements that match a condition 🔹 If-Else Expression → Transform values based on a condition 🔹 Nested List Comprehension → Work with 2D lists and matrices 🔹 Dictionary Comprehension → Create dictionaries efficiently 🔹 Set Comprehension → Generate unique values automatically 💡 Two keywords you'll use all the time: PART 1: for → Iterates through each element PART 2: if → Filters or transforms elements based on a condition 🚀 Beginner tip: Master normal for loops first, then List Comprehensions will become much easier to understand and use. ❤️ React if you want more Python concepts explained this way.

American Express is hiring Analyst 🔥 Experience : 0-3 Years Location : Gurugram Apply link : https://egug.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/26011956?utm_medium=jobboard&utm_source=LinkedIn

TP is hiring Reporting Analyst 🔥 Experience : Freshers / Experienced Location : Hyderabad Apply link : https://www.linkedin.com/jobs/view/4450288105/

PhonePe is hiring Analyst 🚀 Location : Bangalore Apply link : https://job-boards.greenhouse.io/embed/job_app?for=phonepe&gh_src=961e65dc3us&token=7750814003

EXL is hiring Executive 🚀 Experience : Freshers Location : Noida Apply link : https://fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_2/job/16107?utm_source=linkedin&utm_medium=jobboard&utm_source=linkedin&utm_medium=jobboard

Nua is hiring Product Analyst 🚀 Experience : 1-2 Year Location : Mumbai Apply link : https://www.linkedin.com/jobs/view/4447365213/

Angel One is hiring Data Analyst 🔥 Experience : 1-2 Years Location : Bangalore Apply link : https://www.linkedin.com/jobs/view/4446658627/

Curefit is hiring Product Analyst 🚀 Experience : 1-2 Year Location : Bangalore Apply link : https://www.linkedin.com/jobs/view/4446623617/