Vahdam Teas Business Analyst Interview Questions and Answers for Experienced

Basics of python and sql asked

Q1. General things like HR round
Add your answer

Basic SQL queries to retrieve data.
Must know basic Pandas and python programming.

Q1. What are the ROC (Receiver Operating Characteristic) curve and AUC (Area Under the Curve) in the context of evaluating the performance of classification models?
Add your answer
Q2. What are your strenghts
Ans. 
I possess strong analytical skills, attention to detail, and effective communication abilities, making me a valuable data analyst.
• Analytical Skills: I excel at interpreting complex data sets, as demonstrated in my previous role where I identified trends that improved sales by 15%.

• Attention to Detail: My meticulous nature ensures accuracy in data reporting, which was crucial when I reduced errors in quarterly reports by...read more
Answered by AI
Add your answer

Q1. SQL Concepts, SQL Joins
Add your answer

Q1. Why I want to join here ?
Ans. 
I am passionate about data analysis and believe this company offers a great opportunity for growth and learning.
• I am excited about the company's innovative projects and the chance to work with cutting-edge technology.

• I admire the company's commitment to data-driven decision making and want to contribute to its success.

• I am impressed by the company's reputation in the industry and want to be a part of its talented team.

• ...read more
Answered by AI
Add your answer

It was a test on Expertise in SQL. Two Lenghty SQL questions in 30 Minutes Time.

Q1. SQL Based Questions
Add your answer
Q2. Basic Python Questions
Add your answer

Assessment on Sql Expertise, 2 lengthy sql questions in 30 mins time

Q1. Hard Questions on sql
Add your answer
Q2. Basic questions on Python
Add your answer

Q1. Securitisation and how it works.
Ans. 
Securitisation is the process of pooling various types of debt and selling them as securities to investors.
• Securitisation involves bundling together various types of debt, such as mortgages, auto loans, or credit card debt.

• These debts are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the underlying assets.

• Investors purchase these securities and receive payments based...read more
Answered by AI
View 1 more answer
Q2. Financial Ratios and how they work and what is a good number to have.
Ans. 
Financial ratios are tools used to evaluate a company's financial performance and health.
• Financial ratios are calculated using data from a company's financial statements.

• They help investors and analysts assess a company's profitability, liquidity, efficiency, and solvency.

• A good number for a financial ratio can vary depending on the industry and company size.

• For example, a current ratio of 2 or higher is generally cons...read more
Answered by AI
Add your answer
Q3. Random number crunching based on some scenario that needs you to make assumptions and get an answer
Add your answer
Q4. How an Excel function works. (Vlookup, Hlookup, Xlookup, IF/AND/OR)
Ans. 
Excel functions like Vlookup, Hlookup, Xlookup, IF/AND/OR are used for data lookup and logical operations.
• Vlookup: Searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Hlookup: Similar to Vlookup but searches for a value in the first row of a table.

• Xlookup: A more versatile version of Vlookup and Hlookup that can search both vertically and horizontally.

• IF: Retu...read more
Answered by AI
Add your answer

Q1. Personal Questions.
Add your answer
Q2. My expertise and proficiency of excel
Add your answer

Q1. No questions. Was confirmed my job
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics from XYZ University.

• I have 3 years of experience working as a data analyst at ABC Company.

• I am proficient in using statistical software such as R and Python for data analysis.

• I have a proven track record of delivering actionable insights to drive business decisions.
Answered by AI
Add your answer
Q2. Tell me about your background
Ans. 
I have a strong background in finance with a focus on data analysis and forecasting.
• Bachelor's degree in Finance from XYZ University

• 3 years of experience as a financial analyst at ABC Company

• Proficient in Excel, SQL, and data visualization tools like Tableau

• Strong analytical skills and attention to detail

• Experience in creating financial models and forecasting reports
Answered by AI
Add your answer