Upload Button Icon Add office photos
Engaged Employer

i

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

Huron Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Huron Data Analyst Interview Questions and Answers for Freshers

Updated 27 May 2024

Huron Data Analyst Interview Experiences for Freshers

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 27 May 2024

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

I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Almost everything on Power BI
Round 2 - One-on-one 

(1 Question)

  • Q1. Behavioral skills

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Write a query where all the customer name start with A
  • Ans. 

    Query to retrieve all customer names starting with A.

    • Use the SELECT statement to retrieve customer names.

    • Use the LIKE operator with the pattern 'A%' to match names starting with A.

    • Specify the table and column name where the customer names are stored.

    • Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';

  • Answered by AI
  • Q2. Write a query where we'll get state wise sales summary report. Actually in this query we have to join multiple table and finding the rank .

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was extremely easy and smooth.

Skills evaluated in this interview

I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 
Round 2 - 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

Interview Preparation Tips

Topics to prepare for Deloitte Data Analyst interview:
  • Procurement
  • Marketing
  • Career goal
Interview preparation tips for other job seekers - Location should be Delhi NCR,Monday would be good
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions liek tiem distance, percentage , ratio, work and hour

Round 2 - Coding Test 

Excel, Numpy, Pandas, basic ML

Round 3 - Case Study 

Case study talking about how to optimise the supply chain using data analytics

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Power BI Difference between ALL() and ALLSELECTED()
  • Ans. 

    ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.

    • ALL() removes all filters from the specified column or table.

    • ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

    • Example: ALL('Table') would remove all filters on the 'Table' in the query context.

    • Example: ALLSELECTED('Column') would remove filte...

  • Answered by AI
  • Q2. Excel Difference between COUNT() and COUNTA()
  • Ans. 

    COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.

    • COUNT() counts only cells with numerical values.

    • COUNTA() counts all non-empty cells, including text and errors.

    • Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Resume based questions like explain the projects that you have done.
  • Q2. Sample dataset 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 Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Expected salary

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - be what you are. be technically strong.

Interview Questionnaire 

1 Question

  • Q1. SQL, Power Bi, Python, Azure

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the Job Description properly. Clear you basics and prepare according to the JD

I applied via Walk-in and was interviewed in Apr 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Cut Cake in 3 cut to maximum pieces
  • Q2. Basic SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident even you don’t have experience in the relevant skill set.

You can be absorbed to much related profile of your interests.

They only check how better you represent yourself and your problem solving approach.

I applied via Company Website and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL, python, Tableau

Interview Preparation Tips

Interview preparation tips for other job seekers - Before interview don't learn new things, just revise what you already know. They will ask about your experience, projects and your contribution, the way you explain your previous projects will give a good understanding of what you know. They want to see if you are interested to improve your skills as you work, how curious you are. These things will give the recruiter some confidence in you to hire you.

Huron Interview FAQs

How many rounds are there in Huron Data Analyst interview for freshers?
Huron interview process for freshers usually has 2 rounds. The most common rounds in the Huron interview process for freshers are Technical and One-on-one Round.
How to prepare for Huron Data Analyst interview for freshers?
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 Huron. The most common topics and skills that interviewers at Huron expect are Computer science, Data Analysis, Data Mining, Javascript and MS SQL.
What are the top questions asked in Huron Data Analyst interview for freshers?

Some of the top questions asked at the Huron Data Analyst interview for freshers -

  1. What's your exposure to data science before this applicat...read more
  2. Almost everything on Power...read more
  3. Behavioral ski...read more

Tell us how to improve this page.

Huron Data Analyst Interview Process for Freshers

based on 1 interview

Interview experience

5
  
Excellent
View more
Huron Data Analyst Salary
based on 7 salaries
₹6 L/yr - ₹8 L/yr
At par with the average Data Analyst Salary in India
View more details

Huron Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

4.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Senior Analyst
156 salaries
unlock blur

₹3.8 L/yr - ₹15.6 L/yr

Senior Process Analyst
95 salaries
unlock blur

₹3 L/yr - ₹8 L/yr

Associate Consultant
87 salaries
unlock blur

₹2 L/yr - ₹11.1 L/yr

Associate
48 salaries
unlock blur

₹6 L/yr - ₹25 L/yr

Principal Consultant
45 salaries
unlock blur

₹14.5 L/yr - ₹35 L/yr

Explore more salaries
Compare Huron with

Deloitte

3.8
Compare

Ernst & Young

3.4
Compare

PwC

3.4
Compare

KPMG India

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