Upload Button Icon Add office photos

Tata Motors

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Tata Motors MIS Analyst Interview Questions and Answers

Updated 4 Aug 2024

Tata Motors MIS Analyst Interview Experiences

2 interviews found

MIS Analyst Interview Questions & Answers

user image Anonymous

posted on 4 Aug 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Gave some problems on EXCEL
  • Q2. A Sort summary about me.

Interview Preparation Tips

Interview preparation tips for other job seekers - Improve your skills instead of watching videos that How to clear interview.
And perform like it's your last chance to show off your skills,
Never miss a chance solve problems by that new things or way you learnt by your prectice, don't go with scripts while preparing for interview.
Just think if you can do that work in better and faster way than no one can replace you.
So improve and trust in your skills.

MIS Analyst Interview Questions & Answers

user image MAFIYA GAMER

posted on 31 Jul 2024

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

(2 Questions)

  • Q1. About your self
  • Q2. Whare live from
  • Ans. 

    The question is asking about where I currently live.

    • I currently live in New York City.

    • I have been living in this city for the past 5 years.

    • I live in a small apartment in Manhattan.

  • Answered by AI
Round 2 - Technical 

(3 Questions)

  • Q1. Pivot tabal function
  • Q2. Index match formula
  • Ans. 

    Index match formula is a powerful Excel function used to lookup values in a table.

    • Index match is used to find a value in a table based on row and column criteria.

    • It is more flexible and efficient than VLOOKUP function.

    • Syntax: =INDEX(array, MATCH(lookup_value, lookup_array, 0))

  • Answered by AI
  • Q3. Sumif's function
  • Ans. 

    SUMIF function adds up values based on a given condition in Excel.

    • Used in Excel to sum values that meet a specific criteria

    • Syntax: =SUMIF(range, criteria, [sum_range])

    • Example: =SUMIF(A1:A10, ">10", B1:B10) will sum values in B1:B10 where corresponding value in A1:A10 is greater than 10

  • Answered by AI

MIS Analyst Interview Questions Asked at Other Companies

asked in Swiggy
Q1. 1.what do you know about Swiggy and it's business model. 2.simple ... read more
asked in Swiggy
Q2. Write a query to find out students has greater than 80 marks and ... read more
Q3. How to start VBA code and what sub and what is sub called
asked in RBL Bank
Q4. Except excel what do you know Vba or python
Q5. What advanced Excel features, such as PivotTables, COUNTIFS, and ... read more

Interview questions from similar companies

I appeared for an interview before Feb 2016.

Interview Preparation Tips

Round: Test
Experience: It was mainly a logical ability test where u have to find a piture which represents the series of pictures, then followed HR questions
Tips: CAT material,

College Name: IIT Kharagpur

Interview Questionnaire 

1 Question

  • Q1. Technical

Interview Questionnaire 

3 Questions

  • Q1. What is job skills
  • Q2. Where job location
  • Q3. How much salary

Interview Questionnaire 

1 Question

  • Q1. Related to accounts

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic accounts knowledge required

I applied via Walk-in and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. User story prioritization techniques
  • Ans. 

    User story prioritization techniques

    • MoSCoW prioritization

    • Kano model

    • Value vs. Effort matrix

    • Buy a feature

    • Theme screening

    • Relative weighting

    • 100 dollar test

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepare all basics in BA

Skills evaluated in this interview

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

Its on python mostly to do with string manipulation, acces data from list, dataframe

Round 2 - HR 

(2 Questions)

  • Q1. Wht is your last ctc
  • Q2. How soon can you join
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - Group Discussion 

Questions asked on Alteryx functions

Round 2 - One-on-one 

(3 Questions)

  • Q1. Explain the previous projects where i used Alteryx
  • Q2. How multi formula used in Alteryx ?
  • Ans. 

    Multi formula tool in Alteryx allows users to apply multiple formulas to different fields in a single step.

    • The Multi formula tool in Alteryx is used to apply multiple formulas to different fields in a single step.

    • Users can add multiple formula expressions and assign them to specific fields in the data set.

    • This tool is helpful for performing complex calculations on multiple fields simultaneously.

    • Example: Using the Multi...

  • Answered by AI
  • Q3. Explain how can we build Alteryx application ?
  • Ans. 

    Alteryx applications can be built using the Alteryx Designer tool by creating workflows and configuring user inputs.

    • Use Alteryx Designer tool to create workflows for data processing

    • Configure user inputs such as text boxes, drop-down menus, and buttons

    • Utilize Alteryx Gallery to publish and share the application with others

  • Answered by AI

Skills evaluated in this interview

Round 1 - One-on-one 

(1 Question)

  • Q1. Be strong in your basics

Interview Preparation Tips

Interview preparation tips for other job seekers - Know about yourself and your profile very well before attending any interview

Tata Motors Interview FAQs

How many rounds are there in Tata Motors MIS Analyst interview?
Tata Motors interview process usually has 1-2 rounds. The most common rounds in the Tata Motors interview process are One-on-one Round, HR and Technical.
What are the top questions asked in Tata Motors MIS Analyst interview?

Some of the top questions asked at the Tata Motors MIS Analyst interview -

  1. Whare live f...read more
  2. Index match form...read more
  3. Sumif's funct...read more

Tell us how to improve this page.

Tata Motors MIS Analyst Interview Process

based on 2 interviews

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Maruti Suzuki Interview Questions
4.2
 • 592 Interviews
TVS Motor Interview Questions
4.0
 • 317 Interviews
Bajaj Auto Interview Questions
3.9
 • 269 Interviews
Ford Motor Interview Questions
4.3
 • 148 Interviews
Kia Motors Interview Questions
3.9
 • 132 Interviews
Honda Interview Questions
4.2
 • 99 Interviews
View all
Tata Motors MIS Analyst Salary
based on 10 salaries
₹2 L/yr - ₹7.5 L/yr
6% less than the average MIS Analyst Salary in India
View more details

Tata Motors MIS Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Senior Manager
6.2k salaries
unlock blur

₹6.9 L/yr - ₹28.4 L/yr

Deputy General Manager
912 salaries
unlock blur

₹13 L/yr - ₹47.3 L/yr

Executive
825 salaries
unlock blur

₹2.4 L/yr - ₹12.2 L/yr

Territory Sales Manager
430 salaries
unlock blur

₹7.3 L/yr - ₹27 L/yr

Manager
407 salaries
unlock blur

₹6.2 L/yr - ₹21 L/yr

Explore more salaries
Compare Tata Motors with

Maruti Suzuki

4.2
Compare

Mahindra & Mahindra

4.1
Compare

Mercedes-Benz Research and Development India

3.8
Compare

TVS Motor

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