Techwave Consulting Data Analyst Intern Interview Questions and Answers

Provided sales case study, asked to analyse the same ans provide insights

Q1. Tableau interview questioins
Add your answer
Q2. SQl based quetions
Add your answer

Q1. Prior Experience
Add your answer
Q2. Capital Market, Hedge Fund
Add your answer
Q3. Derivatives, Scenario-based question
Add your answer

Q1. Prior Experience
Add your answer
Q2. How do you handle escalations?
Ans. 
I handle escalations by addressing the issue promptly, involving necessary stakeholders, and providing regular updates.
• Address the issue promptly to prevent further escalation

• Involve necessary stakeholders to gather input and support

• Provide regular updates to all parties involved to ensure transparency and progress

• Implement solutions to prevent similar escalations in the future
Answered by AI
Add your answer
Q3. What was the toughest escalation I have ever managed
Add your answer
Q4. Excel - Index, Match, Lookups - XLookup, VLookup, HLookup
Add your answer
Q5. Job Description
Add your answer

Q1. Long term vs short-term securities
Ans. 
Long-term securities are investments held for an extended period, while short-term securities are held for a shorter duration.
• Long-term securities typically have maturity dates of over one year, such as bonds or stocks.

• Short-term securities have maturity dates of one year or less, like Treasury bills or certificates of deposit.

• Long-term securities offer higher potential returns but also higher risk, while short-term se...read more
Answered by AI
Add your answer
Q2. Data analysis, vizualization
Add your answer
Q3. Yield to Maturity, the relationship between yield and interest
Ans. 
Yield to Maturity is the total return anticipated on a bond if it is held until it matures.
• Yield to Maturity is the annual rate of return an investor can expect to earn if the bond is held until it matures.

• It takes into account the bond's current market price, par value, coupon interest rate, and time to maturity.

• Yield to Maturity helps investors compare different bonds and make informed investment decisions.

• For exampl...read more
Answered by AI
Add your answer
Q4. About my project
Add your answer
Q5. Job Description
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 and have completed multiple data analysis projects during my studies.

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

• I have experience in conducting market research and creating reports to help businesses make informed decisions.

• I am a q...read more
Answered by AI
Add your answer
Q2. What do you know about our client
Ans. 
Our client is a multinational technology company specializing in software development and cloud services.
• Our client is known for their popular operating system used by millions of people worldwide.

• They offer a wide range of productivity software and cloud services for businesses and individuals.

• The company was founded in the 1970s by Bill Gates and Paul Allen.

• They are also involved in hardware products such as laptops,
Answered by AI
Add your answer

Q1. Introduce yourself
Add your answer

It was an on campus recruitment drive with questions mostly on basic statistics and algebra.

In round 2 the interviewer asked to explain one of my project and then write code for longest common substring problem.

One Simple coding problem followed with couple of probability questions and explaining the Simple Linear model in detail.