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://t.me/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://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Goldman Sachs senior data analyst interview asked questions

SQL

1 find avg of salaries department wise from table
2 Write a SQL query to see employee name and manager name using a self-join on 'employees' table with columns 'emp_id', 'name', and 'manager_id'.
3 newest joinee for every department (solved using lead lag)

POWER BI

1. What does Filter context in DAX mean?
2. Explain how to implement Row-Level Security (RLS) in Power BI.
3. Describe different types of filters in Power BI.
4. Explain the difference between 'ALL' and 'ALLSELECTED' in DAX.
5. How do you calculate the total sales for a specific product using DAX?

PYTHON

1. Create a dictionary, add elements to it, modify an element, and then print the dictionary in alphabetical order of keys.
2. Find unique values in a list of assorted numbers and print the count of how many times each value is repeated.
3. Find and print duplicate values in a list of assorted numbers, along with the number of times each value is repeated.

I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://t.me/DataSimplifier

Hope this helps you 😊

Deloitte is hiring Analyst 🚀

Experience : 2+ Years
Location :; Gurugram

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

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Apna Mart is hiring Data Analyst 🚀

Experience : 1 Year
Location : Bangalore

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

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

NTT DATA is hiring!
Position: Data Analyst
Qualification: Bachelor's/ Master’s Degree
Salary: 5 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India (Hybrid)

📌Apply Now: https://nttdata.eightfold.ai/careers/job/563327923717998?domain=nttdata.com&hl=en

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Top companies currently hiring data analysts

Based on the current job market in 2025, here are the top companies hiring data analysts:

## Top Tech Companies

- Meta: Investing heavily in AI with significant GPU investments
- Amazon: Offers diverse data analyst roles with complex responsibilities
- Google (Alphabet): Leverages massive data ecosystems
- JP Morgan Chase & Co.: Strong focus on data-driven banking transformation

## Specialized Data Analytics Firms

- Tiger Analytics: Specializes in AI/ML solutions
- SG Analytics: Provides data-driven insights
- Monte Carlo Data: Focuses on data observability
- CB Insights: Excels in market intelligence

## Emerging Opportunities

Companies like Samsara, ScienceSoft, and Forage are also actively recruiting data analysts, offering competitive salaries ranging from $85,000 to $207,000 annually.

I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://t.me/DataSimplifier

Like this post for if you want me to continue the interview series 👍♥️

Share with credits: https://t.me/sqlspecialist

Hope it helps :)

Thomson Reuters is hiring!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 6 LPA (Expected)
Experience: Experienced
Location: Bengaluru; Hyderabad, India

📌Apply Now: https://careers.thomsonreuters.com/us/en/job/JREQ191652/Data-Analyst

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Meesho is hiring!
Position: Associate
Qualifications: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://www.meesho.io/jobs/associate---category---meesho-grocery?id=5eb91540-9431-4bb6-9cba-83bbfe8fce1e

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

🎭 𝗥𝗲𝗲𝗹 𝘃𝘀 𝗥𝗲𝗮𝗹𝗶𝘁𝘆 𝗧𝗵𝗲 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗘𝗱𝗶𝘁𝗶𝗼𝗻

We often romanticize roles in tech. The truth? It's not always as shiny as it seems on the surface.

👨💻 𝗧𝗵𝗲 𝗥𝗲𝗲𝗹 𝗩𝗲𝗿𝘀𝗶𝗼𝗻:

"Just learn SQL, Python, and build a dashboard in Power BI or Tableau… and you're all set!"

It feels achievable. Even fun. And while these are important, they’re just the beginning.

💥 𝗧𝗵𝗲 𝗥𝗲𝗮𝗹𝗶𝘁𝘆 𝗖𝗵𝗲𝗰𝗸:
Most real-world data analyst roles demand far more:
🔹 Snowflake for data warehousing
🔹 Databricks for collaborative data engineering
🔹 AWS for scalable cloud computing
🔹 Git for version control
🔹 Airflow for orchestrating complex data pipelines
🔹 Bash scripting for automation and operations

📊 The transition from classroom projects to production environments is where most struggle — not because they aren’t smart, but because the expectations shift drastically.

💡 𝗠𝘆 𝗮𝗱𝘃𝗶𝗰𝗲 𝗳𝗼𝗿 𝗮𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗮𝗻𝗮𝗹𝘆𝘀𝘁𝘀?

Learn the basics, yes. But don't stop there.

🔍 Go beyond tutorials. Get comfortable with tools used in enterprise environments.

🛠️ Build side projects that mimic real data complexity.

🤝 Connect with professionals to understand the real challenges they face.

✅ This post isn't meant to discourage — it's a wake-up call.

The gap between “𝗥𝗲𝗲𝗹” 𝗮𝗻𝗱 “𝗥𝗲𝗮𝗹𝗶𝘁𝘆” is exactly where growth happens.

Visa is hiring Data Engineer

For 2022, 2023, 2024 grads
Location: Bangalore

https://jobs.smartrecruiters.com/Visa/744000063887675-data-engineer-0-5-1-5-years-of-experience-in-java-python-hadoop-spark-

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

EY is hiring!
Position: Data and Analytics
Qualifications: Bachelor's degree
Salary: 6 - 13 LPA (Expected)
Experience: Experienced
Location: Bangalore, India

📌Apply Now: https://careers.ey.com/ey/job/Bengaluru-Data-and-Analytics-Pricing-and-Commercial-Senior-KA-560016/1200004101/

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Swiggy is hiring Business Associate 🚀

Experience : 1-3 Years
Location : Bangalore

Apply link : https://careers.swiggy.com/#/careers?src=linkedin&p=eyJwYWdlVHlwZSI6ImpkIiwiY3ZTb3VyY2UiOiJsaW5rZWRpbiIsInJlcUlkIjoxOTUwNywicmVxdWVzdGVyIjp7ImlkIjoibGlua2VkaW4iLCJjb2RlIjpudWxsLCJuYW1lIjoiIn19&reqid=19507

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Lokal is hiring Product Analyst 🚀

Experience : 1 Year
Location : Bangalore

Apply link : https://www.instahyre.com/job-372728-product-analyst-at-lokal-bangalore/?utm_source=linkedin&utm_medium=listing&utm_campaign=linkedin_apply&utm_content=372728

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Redbus is hiring Product Analyst 🚀

Experience : 1 Year
Location : Bangalore

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

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

GlobalLogic is hiring Associate Analyst 🚀

Experience : 0-1 Year
Location : Gurugram

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

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

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Societe Generale is hiring!
Position: Business Analyst
Qualifications: Bachelor’s/ Master's Degree
Salary: 6.5 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India (Hybrid)

📌Apply Now: https://careers.societegenerale.com/en/job-offers/business-analyst-25000BM6-en

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Goldman Sachs is hiring!
Position: Analyst - Data Analytics
Qualification: Bachelor’s/ Master’s/ MBA
Salary: 6 - 10 LPA (Expected)
Location: Bengaluru, India

📌Apply Now: https://higher.gs.com/roles/145141

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Motorola Solutions is hiring!
Position: PowerBI Engineer/ Developer
Qualification: Bachelor’s/ Master’s/ MBA
Salary: 6 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://motorolasolutions.wd5.myworkdayjobs.com/en-US/Careers/job/PowerBI-Engineer_R54719

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍