AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Hogarth Studios India
Compare
Filter interviews by
Hogarth Studios India Analyst Interview Questions and Answers
Hogarth Studios India Analyst Interview Experiences
1 interview found
Anonymous
Selected
I was interviewed before Dec 2023.
(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
(1 Question)
- Q1. Html and Css questions
Top trending discussions
Interview questions from similar companies
(2 Questions)
- Q1. SQL based questions
- Q2. Logic based questions
(2 Questions)
- Q1. Situation based questions
- Q2. Questions related to company
4 SQL questions, complexity 7/10
(2 Questions)
- Q1. Previous projects
- Q2. In and around ML models
(2 Questions)
- Q1. Usual, simple behavioural
- Q2. Expected package
Mamta Priyadarshi
Aptitude test was easy, you can prepare it with online available resources
We were asked to complete few games which were related to logical thinking
It was a common topic and was 1 hour long
(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...
Selected
General aptitude questions
Was given a topic and asked to talk about for 2 mins
(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...
- Q2. What do you expect from us?
I applied via Newspaper Ad
Basic coding questins
(1 Question)
- Q1. All based on my project
Interview Preparation Tips
Prepare well on Python, SQL and be good at solving analytical problems
(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
(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.
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.
(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
- 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
- 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.
(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
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
Selected
I applied via Referral and was interviewed before Jun 2023. There were 4 interview rounds.
Topics will be mainly SQL and few python questions. Duration-3min to 1hr
(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...
- 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,...
(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
(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
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.
Aptitude test :Numerical,Logical and Behavioral
Group discussion - Conducted among 6-12 people
(1 Question)
- Q1. Introduction,Guesstimates & basic programming
(1 Question)
- Q1. Project explanation:Final year project
(1 Question)
- Q1. General HR discussion: Intro,Reasons for joining here
Hogarth Studios India Interview FAQs
Tell us how to improve this page.
Hogarth Studios India Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Hogarth Studios India Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Lead Analyst
5
salaries
|  ₹9.5 L/yr - ₹15 L/yr |
|
Analyst
4
salaries
| ₹6.8 L/yr - ₹8.6 L/yr |
|
Project Manager
4
salaries
| ₹10.6 L/yr - ₹15.5 L/yr |
|
Senior Analyst
4
salaries
| ₹8 L/yr - ₹12 L/yr |
|
Senior Lead Analyst
4
salaries
| ₹11.8 L/yr - ₹11.8 L/yr |
Tekwissen
Softenger
XcelServ Solutions
Capital Numbers Infotech
- Home >
- Interviews >
- Hogarth Studios India Interview Questions >
- Hogarth Studios India Analyst Interview Questions
