Preqin Data Analyst Interview Questions and Answers

Q1. Walk through resume
Add your answer

Excel question, ask about your previous experience

In the aptitude test has 40 questions and give a answer in a proper manner l.

Q1. Myself introduction
Add your answer
Q2. What is past experience in working in last organisation
Ans. 
I have 2 years of experience working as a Data Entry Operator in my last organization.
• Entered and updated data into computer systems

• Verified accuracy of data entered

• Maintained confidentiality of sensitive information

• Assisted in organizing and maintaining files and records
Answered by AI
Add your answer

Q1. Tableau, python, previous projects
Add your answer
Q2. Natural language processing, regression
Add your answer

Clustering code on cricket anslytics

Audit assurance case study… examples and estimation

Focus on little bit of dynamic programming

Q1. Apache spark architecture and ecosystem along with memory management
Add your answer
Q2. SQL queries for manager salary
Add your answer
Q3. Python decorators --> @
Add your answer
Q4. RANK and other window functions
Add your answer
Q5. Joins along with use case
Ans. 
Joins are used in SQL to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Use cases for joins include combining customer data with order data, merging employee information with department details
Answered by AI
Add your answer

Q1. Why data analysis and data science
Ans. 
Data analysis and data science are crucial for extracting valuable insights from large datasets to drive informed decision-making.
• Data analysis and data science help in uncovering patterns and trends within data.

• They enable businesses to make data-driven decisions for improved efficiency and effectiveness.

• These fields also play a vital role in predictive analytics and forecasting.

• Examples include using machine learning...read more
Answered by AI
Add your answer
Q2. Why pgdm in business analytics
Ans. 
PGDM in Business Analytics provides specialized knowledge and skills for analyzing data to drive business decisions.
• Specialized curriculum focusing on data analysis techniques and tools

• Hands-on experience with real-world data sets

• Opportunities for networking with industry professionals

• Career advancement in the field of business analytics
Answered by AI
Add your answer

Q1. Name of two mid cap stocks?
Ans. 
Two mid cap stocks are Bajaj Finserv and Muthoot Finance.
• Bajaj Finserv is a financial services company with a market cap of around 1.5 lakh crore.

• Muthoot Finance is a gold loan company with a market cap of around 50,000 crore.

• Both stocks have shown consistent growth over the years and are considered good investment options.
Answered by AI
Add your answer
Q2. Suggest some conservative mutual funds?
Ans. 
Conservative mutual funds are low-risk investments that offer steady returns.
• Conservative mutual funds invest in low-risk securities such as bonds and blue-chip stocks.

• These funds are suitable for investors who want to preserve their capital and earn steady returns.

• Examples of conservative mutual funds include Vanguard Wellesley Income Fund, Fidelity Conservative Income Bond Fund, and T. Rowe Price Capital Appreciation
Answered by AI
Add your answer

Q1. Walk through resume
Add your answer

Excel question, ask about your previous experience