Hogarth Studios India Analyst Interview Questions and Answers

Mostly logical questions

Q1. They asked about my resume
Add your answer
Q2. They asked how to make a financial model
Add your answer

4 SQL questions, complexity 7/10

Q1. Previous projects
Add your answer
Q2. In and around ML models
Add your answer

Q1. Usual, simple behavioural
Add your answer
Q2. Expected package
Add your answer

Case Study and aptitude question

Question from resume and internship experience

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 Business Analytics

• I have experience using SQL, Excel, and Tableau for data analysis

• I have successfully identified trends and patterns in data to make informed business decisions
Answered by AI
Add your answer
Q2. Tell me about the time when you had to take responsibilities
Add your answer

General aptitude questions

Was given a topic and asked to talk about for 2 mins

Q1. Why LatentView?
Ans. 
LatentView offers a dynamic work environment with opportunities for growth and learning in the field of analytics.
• LatentView has a strong reputation in the analytics industry for delivering innovative solutions to clients.

• The company values continuous learning and development, providing employees with opportunities to enhance their skills.

• LatentView offers a collaborative work culture where employees can work on divers...read more
Answered by AI
Add your answer
Q2. What do you expect from us?
Add your answer

Basic coding questins

Q1. All based on my project
Add your answer

Prepare well on Python, SQL and be good at solving analytical problems

Q1. Mostly based on your resume, prepare to answer whatever you kept on resume. Still prepare well on Python, SQL... Go through AWS/Datawarehouse concepts if role is Data Engineering position
Add your answer

Q1. Lightly on Technical side, Mostly on testing how you're able to solve business problems
Add your answer

There were 48 questions to be done in 60 minutes.
the platform used was below average.
about 1400 gave the test

The Next round was a GD.
about 250 were shortlisted.
it was held in groups of 10 - 13.
there were 2 Panelists observing the body language, the fluency and time you speak for.
It is very important that you either start or conclude the GD.
leaves a good impression.

Q1. Tell me about yourself
Add your answer
Q2. What is Data Analysis?
Ans. 
Data analysis is the process of inspecting, cleaning, transforming, and modeling data to discover useful information.
• It involves collecting and organizing data

• It includes statistical analysis and visualization

• It helps in making informed decisions

• Examples include market research, financial analysis, and scientific research
Answered by AI
Add your answer
Q3. SQL Queries using Joins and sub-queries
Ans. 
SQL Queries using Joins and sub-queries
• Joins are used to combine rows from different tables based on a related column

• Sub-queries are queries nested within another query

• Joins and sub-queries can be used together to retrieve specific data from multiple tables
Answered by AI
View 1 more answer
Q4. Many questions about projects mentioned in the resume.
Add your answer
Q5. Estimation and probability questions were asked to see the way you approach a question logically.
Add your answer

Q1. Tell me about Yourself
Add your answer
Q2. Again Questions based on resumes
Add your answer
Q3. Some Regular HR Questions like why latent view, where to do you yourself in 5 years.....etc.
Add your answer
Q4. Any questions for me?
Add your answer