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

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

I applied via Walk-in and was interviewed in Apr 2022. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Steel rule short measurement ?
  • Q2. V block are use in .......?
  • Ans. 

    V blocks are used in machining and inspection processes to hold cylindrical workpieces securely in place.

    • V blocks are commonly used in milling, drilling, and grinding operations.

    • They are also used in inspection processes to ensure accurate measurements of cylindrical parts.

    • V blocks are typically made of hardened steel or cast iron and have a V-shaped groove to hold the workpiece.

    • They come in various sizes and angles to...

  • Answered by AI
  • Q3. Micrometre used and safety precaution
  • Ans. 

    Micrometre is a measuring tool used for precise measurements. Safety precautions include proper handling and storage.

    • Micrometre should be handled with care to avoid damage to the measuring surfaces

    • It should be stored in a protective case when not in use

    • Avoid exposing it to extreme temperatures or moisture

    • Regular calibration is necessary to ensure accurate measurements

    • Proper eye protection should be worn when using a mi...

  • Answered by AI
Round 2 - Case Study 

Practical training safaty 5s

Interview Preparation Tips

Interview preparation tips for other job seekers - Safaty relisted question. Cleaning work place. Safety work .. sefety exam
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Roc and auc related questions..core statistics and case studies
Round 2 - Coding Test 

Assessment for coding round

Round 3 - HR 

(1 Question)

  • Q1. Behavioral questions and compensation negotiation
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

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
No response

I applied via Job Fair and was interviewed in Mar 2023. There were 3 interview rounds.

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 - Aptitude Test 

It was all about maths , english and basic computer

Round 3 - Technical 

(2 Questions)

  • Q1. Golden rules of account
  • Ans. 

    Golden rules of account

    • Maintain accurate and up-to-date records

    • Separate personal and business finances

    • Reconcile accounts regularly

    • Keep receipts and invoices

    • Monitor cash flow

    • Follow accounting standards and regulations

  • Answered by AI
  • Q2. Explain depreciation
  • Ans. 

    Depreciation is the decrease in value of an asset over time due to wear and tear, obsolescence, or other factors.

    • Depreciation is a non-cash expense that reduces the value of an asset on the balance sheet.

    • It is calculated by dividing the cost of the asset by its useful life.

    • There are different methods of calculating depreciation, such as straight-line, declining balance, and sum-of-the-years-digits.

    • Examples of assets th...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

Interview Questionnaire 

1 Question

  • Q1. Related to accounts

Interview Preparation Tips

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

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 HR, Technical and One-on-one Round.
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
 • 602 Interviews
TVS Motor Interview Questions
4.0
 • 321 Interviews
Bajaj Auto Interview Questions
3.9
 • 274 Interviews
Ford Motor Interview Questions
4.3
 • 149 Interviews
Kia Motors Interview Questions
3.9
 • 134 Interviews
Honda Interview Questions
4.1
 • 100 Interviews
View all
Tata Motors MIS Analyst Salary
based on 10 salaries
₹2 L/yr - ₹7.5 L/yr
7% 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

4.0

Work-life balance

4.0

Salary

5.0

Job security

5.0

Company culture

4.0

Promotions

5.0

Work satisfaction

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

₹7 L/yr - ₹28.4 L/yr

Deputy General Manager
872 salaries
unlock blur

₹18 L/yr - ₹47.3 L/yr

Executive
817 salaries
unlock blur

₹2.4 L/yr - ₹12.2 L/yr

Sales Executive
440 salaries
unlock blur

₹0.8 L/yr - ₹6 L/yr

Territory Sales Manager
433 salaries
unlock blur

₹7.3 L/yr - ₹27 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