PrepNPlaced

PrepNPlaced pinned «Looking for Career Guidance from Industry Expert Data Analyst? Then do book free session with various Industry Experts 👇 https://explore.preplaced.in/idEtGt»

04:40

PrepNPlaced

Hey hustlers, very good afternoon, I hope you're doing great

Welcome Day 72 of the 𝗛𝘂𝘀𝘁𝗹𝗲𝗿𝘀𝗹𝗲𝗿𝘀 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝘁𝗼 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 challenge.

Today we'll learning CASE When in SQL. Use below tutorials for your learning ⤵️

https://youtu.be/C72qtLE9eVE?si=XiYMyFM2a5KUIVkN

https://youtu.be/mf_IFI3I7to?si=VbBGvnd_75kCwGLZ

Tutorial for SQL learning:
https://www.w3schools.com/sql/

I look forward to your responses.

Till then keep learning and keep exploring 🙌

YouTube

SQL Case When Statement | SQL Fundamentals | SQL Tutorial

In this video we will understand how to work with SQL case when statements . I the end we will discuss a use case as well.

👍4❤2👏1

2.4K views08:56

PrepNPlaced

PrepNPlaced pinned «Hey hustlers, very good afternoon, I hope you're doing great Welcome Day 72 of the 𝗛𝘂𝘀𝘁𝗹𝗲𝗿𝘀𝗹𝗲𝗿𝘀 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝘁𝗼 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 challenge. Today we'll learning CASE When in SQL. Use below tutorials for your learning ⤵️ https:…»

08:56

PrepNPlaced

How I’d Prepare for the Data Analyst role if I Interview Again🤔

Key Topics to Focus On:

👉 Data Analytics Fundamentals: Master SQL, Python, and visualization tools like Power BI.
👉 Problem-Solving Skills: Be ready for case studies and real-world problem scenarios.

👉 Domain Knowledge: Understand the latest trends and real-world applications in Data Analytics.

👉 Behavioral Questions: Prepare to discuss teamwork, leadership, and overcoming challenges.

My Interview Strategy:

📅 Structured Study Plan: Divide preparation into technical, problem-solving, and behavioral sections.

🎯 Mock Interviews: Practice with peers or mentors to simulate real conditions.

👨‍💻 Hands-On Practice: Work on real data sets and case studies to sharpen your skills.

Resources to Use:

💻 LeetCode & HackerRank: For SQL and Python practice.

📚 Coursera & Udemy: Great courses on Data Analytics and tools like Power BI.

📊 Kaggle & W3school: Projects and coding practice.

Leetcode, DataLemur, StrataScatch & SQLZoo: SQL challenges.

🔎 Glassdoor: Research common interview questions asked at each company.

Mistakes I’d Avoid:

⚠️ Cramming: Focus on understanding concepts, not just memorization.

💡 Overconfidence: Stay humble and open to learning, no matter how much you know.

🗣️ Ignoring Soft Skills: Communication and teamwork matter just as much as technical skills.

Preparing for Data Analytics Career Growth (Advancing in the Data Analytics Domain in 2025)

Master Advanced Analytics Tools: Focus on tools like Tableau, Power BI, and Python for advanced analytics and visualization.

Develop Data Storytelling Skills: Learn to communicate data insights effectively to both technical and non-technical audiences.

Work on Real-World Projects: Use platforms like Kaggle and GitHub to showcase your practical experience and portfolio.

Stay Updated on AI & Automation: Keep learning about the latest trends in AI and automation tools in data analytics.

Build a Strong Professional Network: Connect with industry leaders and participate in analytics communities for growth opportunities.

Want to elevate your interview prep? Try a free session with a mentor at Preplaced to identify your weak spots and boost your success: https://explore.preplaced.in/idEtGt

👍5❤1

1.89K views12:43

PrepNPlaced

Swiggy is hiring Lead Analyst

Our team is looking for a Lead Analyst with 2-3 years of experience.

- 2-3 years of experience in data analysis or a related field
- Strong proficiency in data tools (SQL, Power BI, etc.)

Please review the job description in the application link. If this sounds like the perfect opportunity for you, apply now through the link below:
https://careers.swiggy.com/#/careers?src%3Dcareers=&search%3Dtitle:Analyst%26p%3DeyJwYWdlVHlwZSI6ImpkIiwiY3ZTb3VyY2UiOiJjYXJlZXJzIiwicmVxSWQiOjE0MDY2LCJyZXF1ZXN0ZXIiOnsiaWQiOiIiLCJjb2RlIjoiIiwibmFtZSI6IiJ9LCJwYWdlIjoiY2FyZWVycyIsImJ1ZmlsdGVyIjotMSwiY3VzdG9tRmllbGRzIjp7InNlYXJjaCI6InRpdGxlOkFuYWx5c3QifX0=

https://www.linkedin.com/posts/partho-sarathi-bhaduri_swiggy-careers-activity-7240335846661365761-rRhf

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46

👉Telegram Channel: https://t.me/dataanalyticsbuddy

Share this Opportunity with your friends and groups

All the best 👍👍

careers.swiggy.in

Swiggy Careers - Build, Scale, Deliver India's Everyday Needs

Swiggy Careers - Join India's leading food delivery platform. Explore tech, non-tech, and early career opportunities at Swiggy.

👍1

1.44K views18:14

PrepNPlaced

Digit Insurance Hiring Business Analyst 🚀

Digit Insurance is excited to announce an opportunity to join our dynamic team as a Business Analyst in Bangalore!

Are you passionate about data-driven decision-making, solving complex business problems, and delivering innovative solutions? If yes, we want to hear from you!

Role - Business Analyst
Location - Bangalore
Experience - 2 to 5 years of relevant experience
Mode - 5 days Work-from-Office

Key Responsibilities :
1. Meet with stakeholders to gather and document requirements.
2. Analyze business needs and translate them into clear, feasible solutions.
3. Document requirements and refine user stories.
4. Collaborate with developers and other stakeholders to ensure the CRM system meets business needs.
5. Conduct data analysis to support business decisions.
6. Provide training and support to end-users.
7. Develop and maintain documentation for business processes and system configurations.
8. Recommend improvements to business processes and CRM system functionalities.

Skillsets :
1. Hands-on experience in SQL query writing
2. Strong Communication Skills
3. Good Interpersonal Skills
4. Basic understanding of CRM tool

If you or someone you know may be interested in the role, send your resume to gauri.marathe@godigit.com now!

https://www.linkedin.com/posts/gaurimarathe2000_connections-hiring-hiringjobposts-activity-7240335999648546816-Ruhq

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46

👉Telegram Channel: https://t.me/dataanalyticsbuddy

Share this Opportunity with your friends and groups

All the best 👍👍

Gauri Marathe on LinkedIn: #connections #hiring #hiringjobposts #hiringpost #businessanalyst…

Hello #connections,

🚀 We’re Hiring! Business Analyst 🚀

Digit Insurance is excited to announce an opportunity to join our dynamic team as a Business…

👍1

1.3K views18:15

PrepNPlaced

Petpooja is hiring Interns in Data Science department. Specifically someone who has significant knowledge on Deep learning or LLM/RAG based projects.

Duration: 6 Months
Position: 10
Location: Ahmedabad (Work from Office)

https://jobs.klimb.io/petpooja/650d96e49311af435b875650?source=social_other&id=622327cb4d51af561200464a

https://www.linkedin.com/posts/akansha-raidas-799b3b15a_petpooja-intern-data-science-ahmedabad-activity-7241392893628698624-36q2

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46

👉Telegram Channel: https://t.me/dataanalyticsbuddy

Share this Opportunity with your friends and groups

All the best 👍👍

Klimb

Petpooja, Intern - Data Science, Ahmedabad, Gujarat, India

Skills Required:Basic PythonMachine LearningDeep LearningBasic Understanding of TransformersBasic Understanding of LLMsBasic Understanding of Prompt WritingBasic Understanding of RAGsOne or more projects in Transformers, LLMs, RAGs, etc

👍1

1.38K views18:15

PrepNPlaced

Hiring Power BI Developer 💼

What you’ll do:
Develop impactful Power BI reports & dashboards
Collaborate with data engineers to turn raw data into meaningful insights
Create complex DAX calculations & optimize reports
Stay ahead of BI trends and best practices
What we’re looking for:
Strong experience in Power BI, DAX, and SQL
Great problem-solving and communication skills
Ability to work both independently and as part of a team

Send your resumes: hrindia@healthec.com

https://www.linkedin.com/posts/praveenaram_hiring-powerbideveloper-businessintelligence-activity-7241396255447212032-QhjK

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46

👉Telegram Channel: https://t.me/dataanalyticsbuddy

Share this Opportunity with your friends and groups

All the best 👍👍

Praveena Ramachandran on LinkedIn: #hiring #powerbideveloper #businessintelligence #dataanalytics #joinourteam | 31 comments

🚀 We’re Hiring! Power BI Developer 💼

Are you passionate about transforming data into actionable insights? Do you have the expertise to design stunning Power… | 31 comments on LinkedIn

👍2👎1

1.85K views18:16

PrepNPlaced

Spinny is hiring for Product Analyst
Experience: 1 - 3 years

Apply here: https://www.linkedin.com/jobs/view/4023103832/?alternateChannel=search

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaFZ2LbKGGGRCU0lnd46

👉Telegram Channel: https://t.me/dataanalyticsbuddy

Share this Opportunity with your friends and groups

All the best 👍👍

Spinny hiring Product Analyst in Gurugram, Haryana, India | LinkedIn

Posted 7:25:59 PM. If you’re as excited as we are about the power of data to transform businesses and build…See this and similar jobs on LinkedIn.

❤1👍1

2.01K views18:16

PrepNPlaced

𝗙𝗿𝗲𝗲 𝗔𝗜 𝗧𝗼𝗼𝗹𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗣𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆 🔥🔥🔥

https://www.linkedin.com/posts/mandarmpatil_productivity-ai-dailytasks-activity-7241634481466490880-M8Br

Mandar Patil on LinkedIn: #productivity #ai #dailytasks #efficiency #freetools #automation | 190 comments

Is Your Workflow Stuck in the Past? These Free AI Tools Will Supercharge Your Productivity!

Have you ever felt like your day is being eaten away by endless… | 190 comments on LinkedIn

👏1

2.2K views02:58

PrepNPlaced

Hey hustlers, very good evening, I hope you're doing great

Welcome Day 73 of the 𝗛𝘂𝘀𝘁𝗹𝗲𝗿𝘀𝗹𝗲𝗿𝘀 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝘁𝗼 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 challenge.

Today we'll learning CASE When Statement with Aggregate Group By in SQL. Use below tutorials for your learning ⤵️

https://youtu.be/Sk6pbUiCwD8?si=ngdvZw1fEtOzdIPQ

Tutorial for SQL learning:
https://www.w3schools.com/sql/

I look forward to your responses.

Till then keep learning and keep exploring 🙌

YouTube

CASE WHEN END STATEMENTS with Aggregates Group by IN SQL | Advanced SQL | Ashutosh Kumar

Sql one of the most important language asked in most of the analytics interviews,in this series i have discussed some advanced level sql concepts that are frequently asked in data analyst,business analyst interviews. In this video i have covered CASE WHEN…

👍2❤1

2.41K views12:54

PrepNPlaced

PrepNPlaced pinned «Hey hustlers, very good evening, I hope you're doing great Welcome Day 73 of the 𝗛𝘂𝘀𝘁𝗹𝗲𝗿𝘀𝗹𝗲𝗿𝘀 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝘁𝗼 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝘀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 challenge. Today we'll learning CASE When Statement with Aggregate Group By in SQL. Use below tutorials…»

12:54

PrepNPlaced