Data Analyst Interview Questions with Answers

1. How many report formats are available in Excel?

There are three report formats available in Excel; they are:
1. Compact Form
2. Outline Form
3. Tabular Form

2. What are sets in Tableau?

Sets are custom fields that define a subset of data based on some conditions. A set can be based on a computed condition, for example, a set may contain customers with sales over a certain threshold. Computed sets update as your data changes. Alternatively, a set can be based on specific data point in your view.

3. What is the difference between DROP and TRUNCATE commands?

DROP command removes a table and it cannot be rolled back from the database whereas TRUNCATE command removes all the rows from the table.

4. What is slicing in Python?

Ans: Slicing is used to access parts of sequences like lists, tuples, and strings. The syntax of slicing is-[start:end:step]. The step can be omitted as well. When we write [start:end] this returns all the elements of the sequence from the start (inclusive) till the end-1 element. If the start or end element is negative i, it means the ith element from the end.

5. What is the map() and filter() function in Python?

The map() function is a higher-order function. This function accepts another function and a sequence of ‘iterables’ as parameters and provides output after applying the function to each iterable in the sequence. The filter() function is used to generate an output list of values that return true when the function is called.

S&P Global is hiring Freshers!
Position: Data Analyst
Qualification: Graduate / Post Graduate or MBA
Salary: 5 - 9 LPA (Expected)
Experience: Freshers
Location: Gurgaon; Ahmedabad; Hyderabad, India

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

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

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

All the best 👍👍

American Express Global Business Travel hiring Data Scientist

Apply link: https://travelhrportal.wd1.myworkdayjobs.com/Jobs/job/India/Data-Scientist_J-74011

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

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

All the best 👍👍

BP hiring Data Analyst

Location: Pune, India

Apply link: https://bpinternational.wd3.myworkdayjobs.com/bpCareers/job/India---Pune/Process-Expert-Data_RQ092239/apply?source=LinkedIn

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

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

All the best 👍👍

JP Morgan Chase hiring Analytics Solutions – Analyst

Apply link: https://JPMorganChase.contacthr.com/147415388

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

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

All the best 👍👍

Uber hiring Data Scientist

Apply link: https://www.uber.com/global/en/careers/list/139871/

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

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

All the best 👍👍

Visa hiring Data Scientist

Apply link: https://jobs.smartrecruiters.com/Visa/744000056429732-data-scientist?source=LinkedIn

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

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

All the best 👍👍

Collegedunia is hiring Data Analyst 🚀

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

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

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

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

All the best 👍👍

StatusNeo is hiring Business Analyst 🚀

Experience : 1 Year
Location : Remote ( India )

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

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

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

All the best 👍👍

𝐄𝐘 𝐎𝐟𝐟 𝐂𝐚𝐦𝐩𝐮𝐬 𝐑𝐞𝐜𝐫𝐮𝐢𝐭𝐦𝐞𝐧𝐭 𝐃𝐫𝐢𝐯𝐞!
Position: Associate
Qualification: Graduate Degree
Salary: 4.6 - 6.8 LPA (Expected)
Experience: Freshers (0 - 1 Years)
Location: Across India

📌Apply Link: https://careers.ey.com/ey/job/Bengaluru-Associate-Experience-Management-Resource-Management-KA-560016/1199652401/

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

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

All the best 👍👍

Visa hiring Data Engineer

Apply link: https://jobs.smartrecruiters.com/Visa/744000058560574-data-engineer-python-sql-and-unix-big-data-

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

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

All the best 👍👍

Eurometer International hiring Data Scientist

Apply link: https://apply.workable.com/j/8076CA190C

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

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

All the best 👍👍

Aumni Techworks hiring Junior Data Analyst

Apply link: https://careers.aumnitechworks.com/jobs/XwtIkEVIyemx/jr-data-analyst

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

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

All the best 👍👍

Eclerx hiring Analyst

Location: Chandigarh, India

Apply link: https://fa-ewji-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/job/77453/?utm_medium=jobshare

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

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

All the best 👍👍

Atlassian - Work From Home!
Position: Finance/ Business Analyst/ Analytics & Data Science
Qualifications: Bachelor’s/ Master’s Degree
Salary: 15 - 34 LPA (Expected)
Experience: Freshers/ Experienced
Location: Work From Home (Remote)

📌Apply Now: https://www.atlassian.com/company/careers/details/19585

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

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

All the best 👍👍

GE HealthCare is hiring!
Position: Trainee Engineer
Qualification: Bachelor’s/ Master’s Degree
Batch: 2021/ 2022/ 2023/ 2024/ 2025
Experience: Freshers (0 - 1 Years)
Location: Bengaluru, India

📌Apply Link: https://careers.gehealthcare.com/global/en/job/R4021895/Trainee-Engineer

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

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

All the best 👍👍

✅ Tata CLiQ Internship, 2025!
Position: Intern - Data Analytics
Qualifications: Bachelor’s Degree
Salary: 5 LPA (Expected)
Batch: 2024/ 2025/ 2026/ 2027
Experience: Freshers
Location: India

📌Apply Now: https://cliqonnect.darwinbox.in/ms/candidate/careers/a681460ed6dd0b

Start your career in data analysis for freshers 😄👇

1. Learn the Basics: Begin with understanding the fundamental concepts of statistics, mathematics, and programming languages like Python or R.

Free Resources: https://news.1rj.ru/str/pythonanalyst/103

2. Acquire Technical Skills: Develop proficiency in data analysis tools such as Excel, SQL, and data visualization tools like Tableau or Power BI.

Free Data Analysis Books: https://news.1rj.ru/str/learndataanalysis

3. Gain Knowledge in Statistics: A solid foundation in statistical concepts is crucial for data analysis. Learn about probability, hypothesis testing, and regression analysis.
Free course by Khan Academy will help you to enhance these skills.

4. Programming Proficiency: Enhance your programming skills, especially in languages commonly used in data analysis like Python or R. Familiarity with libraries such as Pandas and NumPy in Python is beneficial. Kaggle has amazing content to learn these skills.

5. Data Cleaning and Preprocessing: Understand the importance of cleaning and preprocessing data. Learn techniques to handle missing values, outliers, and transform data for analysis.

6. Database Knowledge: Acquire knowledge about databases and SQL for efficient data retrieval and manipulation.
SQL for data analytics: https://news.1rj.ru/str/sqlanalyst

7. Data Visualization: Master the art of presenting insights through visualizations. Learn tools like Matplotlib, Seaborn, or ggplot2 for creating meaningful charts and graphs. If you are from non-technical background, learn Tableau or Power BI.
FREE Resources to learn data visualization: https://news.1rj.ru/str/PowerBI_analyst

8. Machine Learning Basics: Familiarize yourself with basic machine learning concepts. This knowledge can be beneficial for advanced analytics tasks.
ML Basics: https://news.1rj.ru/str/datasciencefun/1476

9. Build a Portfolio: Work on projects that showcase your skills. This could be personal projects, contributions to open-source projects, or challenges from platforms like Kaggle.
Data Analytics Portfolio Projects: https://news.1rj.ru/str/DataPortfolio

10. Networking and Continuous Learning: Engage with the data science community, attend meetups, webinars, and conferences. Build your strong Linkedin profile and enhance your network.

11. Apply for Internships or Entry-Level Positions: Gain practical experience by applying for internships or entry-level positions in data analysis. Real-world projects contribute significantly to your learning.
Data Analyst Jobs & Internship opportunities: https://news.1rj.ru/str/jobs_SQL

12. Effective Communication: Develop strong communication skills. Being able to convey your findings and insights in a clear and understandable manner is crucial.

Share with credits: https://news.1rj.ru/str/sqlspecialist

Hope it helps :)

𝐊𝐏𝐌𝐆 - 𝐎𝐟𝐟 𝐂𝐚𝐦𝐩𝐮𝐬 𝐑𝐞𝐜𝐫𝐮𝐢𝐭𝐦𝐞𝐧𝐭 𝐃𝐫𝐢𝐯𝐞!
Position: Analyst
Qualification: Bachelor's/ Master's Degree
Salary: 4 - 7 LPA (Expected)
Experience: Freshers (0 - 1 Years)
Location: Bangalore/ Gurgaon

📌Apply Now: https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_3/jobs/preview/30025089/?keyword=analyst&location=India&locationId=300000000296042&locationLevel=country&mode=location

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

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

All the best 👍👍

Want to practice for your next interview?

Then use this prompt and ask Chat GPT to act as an interviewer 😄👇 (Tap to copy)

I want you to act as an interviewer. I will be the
candidate and you will ask me the
interview questions for the position position. I
want you to only reply as the interviewer.
Do not write all the conservation at once. I
want you to only do the interview with me.
Ask me the questions and wait for my answers.
Do not write explanations. Ask me the
questions one by one like an interviewer does
and wait for my answers. My first
sentence is "Hi"

Now see how it goes. All the best for your preparation
Like this post if you need more content like this👍❤️

Barclays hiring Business Analyst - Data Insights

Location: Pune, India

Apply link: https://search.jobs.barclays/job/-/-/13015/80972772368?src=JB-12860

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

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

All the best 👍👍