Add office photos
Filter interviews by
Guidehouse Data Analyst Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Anonymous
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Was Given two small tables and was asked the total no of rows returned for each kind of join. Add Answer
- Q2. In Tableau if the underlining table columns keep on changing than what can be done so that it wont affect on the view level. View Answers (1)
- Q3. Row level security Add Answer
- Q4. Tell me about your project View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Focus on SQL mainly on joins and be prepared to explain your project in detail.
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Explain all types of joins View Answers (1)
- Q2. Difference between having and where View Answers (1)
Skills evaluated in this interview
tejas jain
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Newspaper Ad and was interviewed in Aug 2024.
3 Interview Rounds
1
Aptitude Test Round
Three sections are there 1) Aptitude Test 2) SQL 3) DSA
2
Technical Round (2 Questions)
- Q1. What is DSA , sorting , difference between array and linked list View Answers (1)
- Q2. Written a SQL query Add Answer
3
HR Round (2 Questions)
- Q1. Coding question like add numbers Add Answer
- Q2. Experience on your project View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Power BI
Difference between ALL() and ALLSELECTED() View Answers (1)
- Q2. Excel
Difference between COUNT() and COUNTA() View Answers (1)
2
Technical Round (2 Questions)
- Q1. Resume based questions like explain the projects that you have done. Add Answer
- Q2. Sample dataset questions Add Answer
Skills evaluated in this interview
Shaonly Chowdhury
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Sql questions checking ur knowledge Add Answer
- Q2. Self join questions about sql Add Answer
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Tableau, SQL related question Add Answer
Monika Singh
Interview experience
Excellent
Difficulty level
Hard
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Jun 2024.
2 Interview Rounds
1
Assignment Round
Data related, aptitude, English
2
One-on-one Round (2 Questions)
- Q1. Asked for a quick intro Add Answer
- Q2. Basic to advance SQL question Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Indeed and was interviewed in Jan 2024.
2 Interview Rounds
1
HR Round (3 Questions)
- Q1. Basics of power bi and sql Add Answer
- Q2. What are joins and types of join View Answers (1)
- Q3. How to add date table in power bi View Answers (1)
2
Technical Round (4 Questions)
- Q1. Sql scenario based question on joins Add Answer
- Q2. Window function questions Add Answer
- Q3. Performance tuning Add Answer
- Q4. Power bi dax question Add Answer
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Easy
Duration
-
Result
Selected
3 Interview Rounds
1
HR Round (1 Question)
- Q1. How good are you with numbers Add Answer
2
Technical Round (1 Question)
- Q1. Vlookup, pivot table, sumif, average, graphs Add Answer
3
Behavioral Round (1 Question)
- Q1. Do you know the role and responsibility of this position Add Answer
Interview experience
Excellent
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Mar 2024.
3 Interview Rounds
1
Aptitude Test Round
Basic aptitude questions liek tiem distance, percentage , ratio, work and hour
2
Coding Test Round
Excel, Numpy, Pandas, basic ML
3
Case Study Round
Case study talking about how to optimise the supply chain using data analytics
Guidehouse Interview FAQs
How to prepare for Guidehouse Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Guidehouse. The most common topics and skills that interviewers at Guidehouse expect are Data Validation, Data Analysis, Analytics, Data Management and ETL.
Tell us how to improve this page.
Guidehouse Interviews By Designations
- Guidehouse AR Caller Interview Questions
- Guidehouse Accounts Receivable Caller Associate Interview Questions
- Guidehouse Associate Interview Questions
- Guidehouse Junior Associate Interview Questions
- Guidehouse Senior AR Caller Interview Questions
- Guidehouse Junior Accounts Receivable Caller Interview Questions
- Guidehouse Senior Associate Interview Questions
- Guidehouse Accounts Receivable Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
At
par with the average Data Analyst Salary in India
View more details
Guidehouse Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Associate
303
salaries
|  ₹2.2 L/yr - ₹6.6 L/yr |
|
Process Associate
205
salaries
| ₹2 L/yr - ₹7 L/yr |
|
Quality Analyst
204
salaries
| ₹4.1 L/yr - ₹9 L/yr |
|
AR Associate
182
salaries
| ₹2.2 L/yr - ₹4.6 L/yr |
|
AR Caller
149
salaries
| ₹1.2 L/yr - ₹5.2 L/yr |
Explore more salaries
Compare Guidehouse with
KPMG India
Compare
Deloitte
Compare
PwC
Compare
Ernst & Young
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Guidehouse Interview Questions >
- Guidehouse Data Analyst Interview Questions
Share an Interview