Upload Button Icon Add office photos

Magic Bus India Foundation

Compare button icon Compare button icon Compare

Filter interviews by

Magic Bus India Foundation Data Analyst Interview Questions and Answers

Updated 19 Mar 2025

Magic Bus India Foundation Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Hema Gupta

posted on 19 Mar 2025

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024, where I was asked the following questions.

  • Q1. What is the difference in excel and google sheets.
  • Ans. 

    Excel and Google Sheets are both spreadsheet applications, but they differ in features, collaboration, and accessibility.

    • Collaboration: Google Sheets allows real-time collaboration, enabling multiple users to edit simultaneously, while Excel requires file sharing.

    • Accessibility: Google Sheets is cloud-based, accessible from any device with internet, whereas Excel is primarily desktop-based.

    • Features: Excel offers advance...

  • Answered by AI
  • Q2. Measures of central tendency
  • Ans. 

    Measures of central tendency summarize a dataset's central point using mean, median, and mode.

    • Mean: Average of all values (e.g., (2+3+5)/3 = 3.33).

    • Median: Middle value when data is sorted (e.g., for 1, 3, 5, median is 3).

    • Mode: Most frequently occurring value (e.g., in 1, 2, 2, 3, mode is 2).

    • Used in various fields like statistics, economics, and psychology.

  • Answered by AI

Top trending discussions

View All
Interview Tips & Stories
2w
timepasstiwari
·
A Digital Markter
ChatGPT prepped me HARD for my interview!
Spent like two hours on chatgpt yesterday prepping for an interview. First, the usual, copy-pasted my resume and the job description, telling it to "upload this to your memory 'cause we are going to talk about it later". Then I grilled it with questions about stuff I didn't get in the job spec, and chatgpt helped me figure things out. I asked it to list the four or five key things they are looking for in the role. Then I told chatgpt to quiz me with ten questions, one at a time, to help me think about how I have gained experience in those areas. After the ten questions, it gave me strengths/weaknesses and a summary. Finally, I had chatgpt summarize each of my answers into three bullet points. Now have got a list of stories ready to go for any interview. No matter the question, I can steer the convo toward one of these success stories.
Got a question about Magic Bus India Foundation?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Company Website and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. How do you Handle Stress and Pressure?
  • Ans. 

    I manage stress through organization, prioritization, and maintaining a positive mindset, ensuring productivity under pressure.

    • I prioritize tasks by urgency and importance, using tools like to-do lists or project management software.

    • During a recent project deadline, I broke down the workload into smaller tasks, which helped me stay focused and reduce overwhelm.

    • I practice mindfulness techniques, such as deep breathing o...

  • Answered by AI
  • Q2. What is your Weakness and Strength?
  • Ans. 

    My strength lies in analytical thinking, while my weakness is over-analyzing data, which can delay decision-making.

    • Strength: Strong analytical skills - I can identify trends in large datasets quickly.

    • Example: In my last project, I uncovered a 15% increase in customer retention through data analysis.

    • Weakness: Tendency to over-analyze - Sometimes I get caught up in the details.

    • Example: I once spent too much time refining...

  • Answered by AI
  • Q3. Why do you want to Leave your job?

Interview Preparation Tips

Interview preparation tips for other job seekers - Review common interview questions, and Be prepare yourself for interview. End the interview with good impression.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Write code to calculate the number of people in a room at the end ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

I applied via Recruitment Consulltant and was interviewed before Aug 2021. There were 2 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 - One-on-one 

(1 Question)

  • Q1. What is your work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - I have 1year experiences with care India

Analyst Interview Questions & Answers

CARE user image Anonymous

posted on 24 Jun 2024

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

LR and finance related questions

Round 2 - One-on-one 

(1 Question)

  • Q1. Liquidity ratios

Interview Questionnaire 

2 Questions

  • Q1. What is your profile
  • Q2. Per annum expected salary
  • Ans. 

    I expect a competitive salary that reflects my experience and the industry standards for a senior associate role.

    • Based on my research, the average salary for a senior associate in this field ranges from $80,000 to $120,000.

    • Considering my 5 years of relevant experience and proven track record, I believe a salary in the range of $100,000 to $110,000 is appropriate.

    • I am open to discussing the full compensation package, in...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Job kyu jarurat kyu hai
  • Q2. Kya aapne pehle kahi Kam Kiya hai
  • Ans. 

    Haan, maine pehle kai jagah par kaam kiya hai, jahan maine team management aur leadership skills ko develop kiya.

    • Pehle maine ek software company mein team lead ke roop mein kaam kiya, jahan maine 10 logon ki team ko manage kiya.

    • Maine ek project par kaam kiya jismein humne deadline se pehle deliverables complete kiye, jo meri leadership skills ko enhance kiya.

    • Maine ek internship ke dauran team collaboration aur communic...

  • Answered by AI
Round 2 - Assignment 

Imandari se apna kam krke prekticl dikhana hoga

Intern Interview Questions & Answers

UNICEF user image Ziyodakhon Malikova

posted on 16 Apr 2024

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

(4 Questions)

  • Q1. What kind of market research tools I can apply?
  • Ans. 

    Market research tools include surveys, focus groups, social media analytics, and competitor analysis.

    • Surveys: Gather information directly from target audience through questionnaires.

    • Focus Groups: Conduct discussions with a small group of people to gather insights.

    • Social Media Analytics: Monitor and analyze social media platforms for consumer trends.

    • Competitor Analysis: Study competitors' strategies, products, and marke...

  • Answered by AI
  • Q2. Customer Relationship Management platform
  • Q3. Keyword research
  • Q4. Survey Tools (Survey Monkey, etc)

Interview Preparation Tips

Interview preparation tips for other job seekers - Be friendly, and prepared well based on job description that you are applying to
Are these interview questions helpful?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via devnetjobs and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. How can you be a good fit for this role
  • Q2. Other questions related to my previous job

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident while answering.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why TFi? Why social impact?
  • Ans. 

    TFi aligns with my passion for social impact, empowering communities through innovative solutions and sustainable practices.

    • TFi's mission resonates with my values of creating positive change in society.

    • The focus on sustainable development aligns with my belief in responsible resource management.

    • I admire TFi's commitment to leveraging technology for social good, such as their initiatives in education and healthcare.

    • Work...

  • Answered by AI
Round 2 - Aptitude Test 

Session plans for your role

Round 3 - Technical 

(2 Questions)

  • Q1. How would you behave in different situations
  • Ans. 

    I adapt my behavior based on the situation, ensuring effective communication and collaboration with others.

    • In a team setting, I encourage open dialogue and actively listen to others' ideas to foster collaboration.

    • During a conflict, I remain calm and seek to understand different perspectives before proposing a solution.

    • In high-pressure situations, I prioritize tasks and maintain focus to ensure timely and effective outc...

  • Answered by AI
  • Q2. How would your friends describe you?

Interview Preparation Tips

Interview preparation tips for other job seekers - Know the theory of change of the organisation very well and speak to someone in the company. It’s all behavioural
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview in Mar 2025, where I was asked the following questions.

  • Q1. Write a SQL query to fetch data
  • Q2. Write Python function for generating report in ERPNext
  • Ans. 

    A Python function for generating reports in ERPNext can automate data retrieval and formatting for business insights.

    • Use Frappe Framework: ERPNext is built on the Frappe framework, so utilize its ORM to fetch data from the database.

    • Define Report Structure: Create a function that defines the structure of the report, including headers and data fields.

    • Data Filtering: Implement filters to allow users to customize the repor...

  • Answered by AI

Magic Bus India Foundation Interview FAQs

How to prepare for Magic Bus India Foundation 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 Magic Bus India Foundation. The most common topics and skills that interviewers at Magic Bus India Foundation expect are Advanced Excel, Data Analysis, MIS, Reporting and Analytics.
What are the top questions asked in Magic Bus India Foundation Data Analyst interview?

Some of the top questions asked at the Magic Bus India Foundation Data Analyst interview -

  1. What is the difference in excel and google shee...read more
  2. Measures of central tende...read more

Tell us how to improve this page.

Overall Interview Experience Rating

3/5

based on 1 interview experience

Difficulty level

Moderate 100%

Duration

2-4 weeks 100%
View more

Interview Questions from Similar Companies

CARE Interview Questions
4.3
 • 39 Interviews
Teach For India Interview Questions
3.9
 • 28 Interviews
UNICEF Interview Questions
3.9
 • 27 Interviews
World Vision Interview Questions
4.3
 • 20 Interviews
View all

Magic Bus India Foundation Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

5.0

Work-life balance

2.0

Salary

1.0

Job security

4.0

Company culture

2.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Data Analyst

Noida

3-8 Yrs

Not Disclosed

Explore more jobs
Center Coordinator
72 salaries
unlock blur

₹1.4 L/yr - ₹3.7 L/yr

Trainer and Counselor
68 salaries
unlock blur

₹2.5 L/yr - ₹4.3 L/yr

Placement Officer
67 salaries
unlock blur

₹2.9 L/yr - ₹4.5 L/yr

District Livelihood Manager
60 salaries
unlock blur

₹4.2 L/yr - ₹7.8 L/yr

Counsellor cum Trainer
57 salaries
unlock blur

₹2.5 L/yr - ₹4.2 L/yr

Explore more salaries
Compare Magic Bus India Foundation with

The Akshaya Patra Foundation

4.5
Compare

CARE

4.3
Compare

Dr. Reddy's Foundation

3.9
Compare

World Vision

4.3
Compare
write
Share an Interview