Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Hogarth Studios India Team. If you also belong to the team, you can get access from here

Hogarth Studios India Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Hogarth Studios India Analyst Interview Questions and Answers

Updated 26 Dec 2024

Hogarth Studios India Analyst Interview Experiences

1 interview found

Analyst Interview Questions & Answers

user image Anonymous

posted on 26 Dec 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Dec 2023.

Round 1 - HR 

(1 Question)

  • Q1. Tell me something 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 cost-saving opportunities for my previous employer

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Html and Css questions

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL based questions
  • Q2. Logic based questions
Round 2 - HR 

(2 Questions)

  • Q1. Situation based questions
  • Q2. Questions related to company
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

4 SQL questions, complexity 7/10

Round 2 - Technical 

(2 Questions)

  • Q1. Previous projects
  • Q2. In and around ML models
Round 3 - HR 

(2 Questions)

  • Q1. Usual, simple behavioural
  • Q2. Expected package
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude test was easy, you can prepare it with online available resources

Round 2 - Assignment 

We were asked to complete few games which were related to logical thinking

Round 3 - Group Discussion 

It was a common topic and was 1 hour long

Round 4 - One-on-one 

(1 Question)

  • Q1. They asked basic sql question like joins, windows function, subqueries. Also they asked one guestimate and a case study. Guestimate- No. of IPhone stores in delhi Case study - How to increase the profit of...
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Aptitude Test 

General aptitude questions

Round 2 - Group Discussion 

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

Round 3 - HR 

(2 Questions)

  • 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...

  • Answered by AI
  • Q2. What do you expect from us?
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Newspaper Ad

Round 1 - Coding Test 

Basic coding questins

Round 2 - Technical 

(1 Question)

  • Q1. All based on my project

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare all Data science topics
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

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

Round 3 - Technical 

(1 Question)

  • 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
Round 4 - Technical 

(1 Question)

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

I applied via campus placement at SRM Institute of Science & Technology, Chennai and was interviewed in Jul 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

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

Round 3 - Group Discussion 

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.

Round 4 - Technical 

(5 Questions)

  • Q1. Tell me about yourself
  • 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
  • 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
  • Q4. Many questions about projects mentioned in the resume.
  • Q5. Estimation and probability questions were asked to see the way you approach a question logically.
Round 5 - HR 

(4 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Be ready with your Resume.
Make your resume based on Data Analytics.
SQL and basics of python are the expected questions with some probability and logical questions.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2023. There were 4 interview rounds.

Round 1 - Coding Test 

Topics will be mainly SQL and few python questions. Duration-3min to 1hr

Round 2 - Technical 

(3 Questions)

  • Q1. What is CLT theorem and what are its uses
  • Ans. 

    CLT theorem states that the distribution of sample means approaches a normal distribution as sample size increases.

    • Central Limit Theorem (CLT) is a fundamental concept in statistics that states that the distribution of sample means approaches a normal distribution as the sample size increases.

    • It is used in hypothesis testing, confidence intervals, and in estimating population parameters.

    • CLT is essential in making infer...

  • Answered by AI
  • Q2. Asked to write SQL queries which uses join and window functions
  • Q3. Explain ML Data preparation and EDA steps in detail. What are major steps in preprocessing
  • Ans. 

    ML data preparation involves cleaning, transforming, and organizing data for analysis. EDA involves exploring and visualizing data to understand its characteristics.

    • Data cleaning: removing missing values, handling outliers, and dealing with duplicates

    • Data transformation: encoding categorical variables, scaling numerical features, and creating new features

    • Data organization: splitting data into training and testing sets,...

  • Answered by AI
Round 3 - One-on-one 

(3 Questions)

  • Q1. Mainly interviewer checked how sound I was in different concepts like statistics, ML
  • Q2. Asked simple DL questions
  • Q3. Guestimates- like how much milk is consumed in your city on average. Give an estimate and show your structured way of arriving at that value
Round 4 - HR 

(3 Questions)

  • Q1. Why you want to join our comany?
  • Q2. What made you leave your previous organization
  • Q3. Salary negotations

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Sri Venkateswara College of Engineering and Technology, Chittoor and was interviewed before Feb 2023. There were 5 interview rounds.

Round 1 - Aptitude Test 

Aptitude test :Numerical,Logical and Behavioral

Round 2 - Group Discussion 

Group discussion - Conducted among 6-12 people

Round 3 - Technical 

(1 Question)

  • Q1. Introduction,Guesstimates & basic programming
Round 4 - Technical 

(1 Question)

  • Q1. Project explanation:Final year project
Round 5 - HR 

(1 Question)

  • Q1. General HR discussion: Intro,Reasons for joining here

Hogarth Studios India Interview FAQs

How many rounds are there in Hogarth Studios India Analyst interview?
Hogarth Studios India interview process usually has 2 rounds. The most common rounds in the Hogarth Studios India interview process are HR and Technical.

Tell us how to improve this page.

Hogarth Studios India Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

MAQ Software Interview Questions
1.9
 • 98 Interviews
Apisero Interview Questions
4.3
 • 64 Interviews
Webkul Software Interview Questions
3.8
 • 54 Interviews
Softenger Interview Questions
4.2
 • 52 Interviews
View all
Hogarth Studios India Analyst Salary
based on 4 salaries
₹6.8 L/yr - ₹8.6 L/yr
18% more than the average Analyst Salary in India
View more details

Hogarth Studios India Analyst Reviews and Ratings

based on 3 reviews

2.4/5

Rating in categories

1.7

Skill development

2.7

Work-life balance

2.4

Salary

2.1

Job security

2.4

Company culture

1.0

Promotions

2.1

Work satisfaction

Explore 3 Reviews and Ratings
Lead Analyst
5 salaries
unlock blur

₹9.5 L/yr - ₹15 L/yr

Analyst
4 salaries
unlock blur

₹6.8 L/yr - ₹8.6 L/yr

Project Manager
4 salaries
unlock blur

₹10.6 L/yr - ₹15.5 L/yr

Senior Analyst
4 salaries
unlock blur

₹8 L/yr - ₹12 L/yr

Senior Lead Analyst
4 salaries
unlock blur

₹11.8 L/yr - ₹11.8 L/yr

Explore more salaries
Compare Hogarth Studios India with

Tekwissen

4.8
Compare

Softenger

4.2
Compare

XcelServ Solutions

4.5
Compare

Capital Numbers Infotech

4.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview