Amazon is hiring Business Analyst 🚀

Experience : 1 Year
Location : Bangalore

Apply link : https://www.amazon.jobs/jobs/2938031/business-analyst?cmpid=SPLICX0248M&utm_source=linkedin.com&utm_campaign=cxro&utm_medium=social_media&utm_content=job_posting&ss=paid

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Collegedunia is hiring Product Analyst 🚀

Qualification : Bachelor's degree
Experience : Freshers / Experienced
Location : Gurugram

Apply link : https://www.linkedin.com/jobs/view/4241209451

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

GlobalLogic is hiring Associate Analyst 🚀

Experience : Freshers
Location : Hyderabad

Apply link : https://www.globallogic.com/careers/associate-analyst-irc266833/?utm_source=LinkedIn&utm_medium=jobboard&utm_campaign=career

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

𝗠𝗼𝘀𝘁 𝗔𝘀𝗸𝗲𝗱 𝗦𝗤𝗟 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗮𝘁 𝗠𝗔𝗔𝗡𝗚 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀🔥🔥

1. How do you retrieve all columns from a table?

SELECT * FROM table_name;


2. What SQL statement is used to filter records?

SELECT * FROM table_name
WHERE condition;

The WHERE clause is used to filter records based on a specified condition.


3. How can you join multiple tables? Describe different types of JOINs.

SELECT columns
FROM table1
JOIN table2 ON table1.column = table2.column
JOIN table3 ON table2.column = table3.column;

Types of JOINs:

1. INNER JOIN: Returns records with matching values in both tables

SELECT * FROM table1
INNER JOIN table2 ON table1.column = table2.column;

2. LEFT JOIN (or LEFT OUTER JOIN): Returns all records from the left table and matched records from the right table. Unmatched records will have NULL values.

SELECT * FROM table1
LEFT JOIN table2 ON table1.column = table2.column;

3. RIGHT JOIN (or RIGHT OUTER JOIN): Returns all records from the right table and matched records from the left table. Unmatched records will have NULL values.

SELECT * FROM table1
RIGHT JOIN table2 ON table1.column = table2.column;

4. FULL JOIN (or FULL OUTER JOIN): Returns records when there is a match in either left or right table. Unmatched records will have NULL values.

SELECT * FROM table1
FULL JOIN table2 ON table1.column = table2.column;


4. What is the difference between WHERE and HAVING clauses?

WHERE: Filters records before any groupings are made.

SELECT * FROM table_name
WHERE condition;

HAVING: Filters records after groupings are made.

SELECT column, COUNT(*)
FROM table_name
GROUP BY column
HAVING COUNT(*) > value;


5. How do you count the number of records in a table?

SELECT COUNT(*) FROM table_name;

This query counts all the records in the specified table.

6. How do you calculate average, sum, minimum, and maximum values in a column?

Average: SELECT AVG(column_name) FROM table_name;

Sum: SELECT SUM(column_name) FROM table_name;

Minimum: SELECT MIN(column_name) FROM table_name;

Maximum: SELECT MAX(column_name) FROM table_name;


7. What is a subquery, and how do you use it?

Subquery: A query nested inside another query

SELECT * FROM table_name
WHERE column_name = (SELECT column_name FROM another_table WHERE condition);




Till then keep learning and keep exploring 🙌

BlackRock is hiring!
Position: Data Analyst
Qualification: Bachelor's Degree
Salary: 6 - 15 LPA (Expected)
Experience: Entry Level
Location: Bengaluru, India (Hybrid)

📌Apply Now: https://careers.blackrock.com/job/bengaluru/data-management-analyst/45831/81540166224

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

NielsenIQ is hiring!
Position: Junior Associate, Power BI
Qualification: Bachelor’s Degree
Salary: 6 - 10 LPA (Expected)
Experience: Entry Level
Location: Pune, India

📌Apply Link: https://jobs.smartrecruiters.com/NielsenIQ/744000063280269-jr-associate-bi

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Fam is hiring Product Analyst Intern 🚀

Experience : Freshers
Location : Bangalore

Apply link : https://jobs.lever.co/fampay/8838779b-4eb1-4150-8fa2-a4cd29cadcbe/apply?lever-source=LinkedIn

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Zelestra is hiring Junior Data Scientist 🚀

Qualification : Bachelor's degree
Experience : 0-2 Years
Location :; Gurugram

Apply link : https://careers.solarpack.es/job/Haryana-Junior-Data-Scientist/1162773055/

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Airtel is hiring Business Analyst 🚀

Experience with Excel ✅
Location : Gurugram

Apply link : https://www.linkedin.com/jobs/view/4241888047

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Roblox is hiring Business Analyst 🚀

Experience : 2+ Years
Location : Gurugram

Apply link : https://careers.roblox.com/jobs/6754913?gh_jid=6754913&gh_src=da92d0c91

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Razorpay hiring Analyst - Risk Management

Apply link: https://job-boards.greenhouse.io/razorpaysoftwareprivatelimited/jobs/4573732005

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

S&P Global is hiring Freshers!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree/ MBA
Salary: 5 - 9 LPA (Expected)
Experience: Freshers
Location: Gurgaon; Ahmedabad; Hyderabad, India

📌Apply Now: https://careers.spglobal.com/jobs/315425

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

DATA ANALYST Interview Questions (0-3 yr) (SQL, Power BI)

👉 Power BI:

Q1: Explain step-by-step how you will create a sales dashboard from scratch.

Q2: Explain how you can optimize a slow Power BI report.

Q3: Explain Any 5 Chart Types and Their Uses in Representing Different Aspects of Data.

👉SQL:

Q1: Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() functions using example.

Q2 – Q4 use Table: employee (EmpID, ManagerID, JoinDate, Dept, Salary)

Q2: Find the nth highest salary from the Employee table.

Q3: You have an employee table with employee ID and manager ID. Find all employees under a specific manager, including their subordinates at any level.

Q4: Write a query to find the cumulative salary of employees department-wise, who have joined the company in the last 30 days.

Q5: Find the top 2 customers with the highest order amount for each product category, handling ties appropriately. Table: Customer (CustomerID, ProductCategory, OrderAmount)

👉Behavioral:

Q1: Why do you want to become a data analyst and why did you apply to this company?

Q2: Describe a time when you had to manage a difficult task with tight deadlines. How did you handle it?

I have curated best top-notch Data Analytics Resources 👇👇
https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02

Hope this helps you 😊

Barclays is hiring!
Position: Business Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 8 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Mumbai/ Pune/ (Hybrid)

📌Apply Now: https://search.jobs.barclays/job/pune/business-analyst/13015/82125567984

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

S&P Global is hiring Freshers!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree/ MBA
Salary: 5 - 9 LPA (Expected)
Experience: Freshers
Location: Gurgaon; Ahmedabad; Hyderabad, India

📌Apply Now: https://careers.spglobal.com/jobs/315425

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍