Add office photos
Filter interviews by
US MNC Data Analyst Interview Questions and Answers
US MNC Data Analyst Interview Experiences
1 interview found
Anonymous
I was interviewed in Feb 2023.
1. Ravi's salary, wgich is more than Rs.10,000, is 80% of Divya's salary. Jai's salary is 80% of Ravi's salary.
Quantity 1: Jai's salary.
Quantity 2: Ravi's salary.
1.Quantity 1 >Quantity 2
2.Quantity 1
3.Quantity 1 ≤Quantity 2
4.Quantity 1 Quantity 2
5.Quantity 1 =Quantity 2 or No relation can
be established.
2. The average marks of M, N and O are 428. The total marks of N and O is 854 and sum of marks of O and M is 914.
Quantity 1: The marks of M
Quantity 2: The marks of O
1.Quantity 1 >Quantity 2
2.Quantity 1
3.Quantity 1
4.Quantity 1 Quantity 2
5.Quantity 1 =Quantity 2 or No relation can be established.
3. Two pipes P and Q can fill the tank in 4 and 2 mins respectively.Both the pipes are opened simultaneously. The bucket is filed in 1 mins.
Quantity 1: If B is turned off after how many
minutes.
Quantity 2: If A is turned off after how many
minutes.
1.Quantity 1 >Quantity 2
2.Quantity 1
3.Quantity 1 ≤Quantity 2
4.Quantity 1 Quantity 2
5.Quantity 1 =Quantity 2 or No relation can be established.
4. (solve as per the direction given above)
1.We discussed about the problem so thoroughly.
2.on the eve of the examination.
3.that I found it very easy to work it out.
4.No error.
5. (solve as per the direction given above)
1. An Indian ship
2.laden with merchandise
3.got drowned in the Pacific Ocean.
4. No error.
1. What is a data structure?
2. What is an array?
3. What is a linked list?
by which command we can close the active workbook?
1. ctrl + w
2. ctrl+s
3. ctrl + f
4. ctrl + v
4.write a program to count the number of occurrences of character in a string in python?
5.Write a program to find factorial of a number in Python?
(1 Question)
- Q1. 1. Tell me something about your self? 2. What experience do you have that would be relevant to this role? 3. What is your strength? 4. What is your biggest dream in your life? 5. What are you expecting fro...
(1 Question)
- Q1. 1. What do you expecting form salary? 2. Do you have any questions? 3. Do you have any experience about this field? 4. Do you have any doubts?
Interview Preparation Tips
- Python
- SQL
- Excel
- Tabulue
- Power pi
2. Maintain good body language.
3. Do more practice.
4. Every time to update your profile good manner.
5. Make you prepare and strong your self to go an interview.
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(4 Questions)
- Q1. Was Given two small tables and was asked the total no of rows returned for each kind of join.
- 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.
- Ans.
Create calculated fields in Tableau to dynamically adjust to changing table columns.
Use calculated fields to reference specific columns by name instead of position.
Utilize parameters to allow users to select which columns to display.
Consider using custom SQL queries to dynamically adjust to changing table structure.
- Q3. Row level security
- Q4. Tell me about your project
- Ans.
Developed a predictive model to forecast customer churn for a telecommunications company.
Utilized machine learning algorithms such as logistic regression and random forest
Performed data preprocessing and feature engineering to improve model performance
Collaborated with business stakeholders to understand key drivers of churn
Achieved 85% accuracy in predicting customer churn
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Can you provide an overview of your background, including your past experiences and daily activities, as well as the tools you use in your routine?
- Ans.
I have a background in data analysis with experience in using tools like Python, SQL, and Tableau.
I have a degree in Statistics and have worked as a Data Analyst for 3 years.
My daily activities include cleaning and analyzing data, creating visualizations, and presenting insights to stakeholders.
I use Python for data manipulation and analysis, SQL for querying databases, and Tableau for creating interactive dashboards.
I...
- Q2. What are the concepts of advanced Excel and Power BI projects, and how are they utilized within a company or for clients?
- Ans.
Advanced Excel and Power BI are tools used for data analysis and visualization in companies and for clients.
Advanced Excel allows for complex data manipulation, analysis, and visualization using features like pivot tables, macros, and VBA programming.
Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities, connecting to various data sources.
These tools are u...
(2 Questions)
- Q1. Can you explain your project experience related to Advanced Excel and Power BI?
- Ans.
I have extensive experience in using Advanced Excel and Power BI for data analysis projects.
Created complex formulas and macros in Excel to automate data processing tasks
Designed interactive dashboards in Power BI to visualize and analyze data trends
Integrated data from multiple sources into Power BI for comprehensive analysis
Used Power Query and Power Pivot in Excel to manipulate and analyze large datasets
Provided dat...
- Q2. What are the concepts of credit and operations, particularly in relation to Know Your Customer (KYC) procedures and the privacy of client data?
- Ans.
Credit and operations concepts in relation to KYC procedures and client data privacy.
Credit refers to the extension of money or resources to a client based on their financial history and ability to repay.
Operations involve the day-to-day processes and procedures within a financial institution to ensure smooth functioning.
KYC procedures are used to verify the identity of clients to prevent fraud and money laundering.
Pri...
Interview Preparation Tips
I applied via AmbitionBox and was interviewed in Nov 2024. There were 3 interview rounds.
(1 Question)
- Q1. I have finished Btech in Cse AI&ML taken datascience course looking for job
NLP is my favorite subject. Is relatated medical and sign language. I have done reseach with mechien learning and AI TOOLS used for problem solving approach.
A group discussion was conducted on data-based management regarding Mr. Adani's food industry products in the state of Gujarat and their exports to other countries, utilizing data analytics.
Interview Preparation Tips
Sql python bigdata hadoop hive spark
1 hour simple coding python sql
(5 Questions)
- Q1. Advantages of sql
- Ans.
SQL allows for efficient data retrieval, manipulation, and analysis in relational databases.
SQL is widely used in querying databases to retrieve specific data.
It allows for data manipulation, such as adding, updating, and deleting records.
SQL can perform complex data analysis tasks, such as aggregations and joins.
It provides a standardized language for interacting with relational databases.
SQL is essential for generati...
- Q2. Advantages of python
- Ans.
Python is a versatile programming language known for its simplicity, readability, and vast library support.
Easy to learn and use, making it ideal for beginners and experienced programmers alike
Extensive library support for data analysis, machine learning, web development, and more
Strong community support with active forums and resources for problem-solving
Cross-platform compatibility allows for seamless integration wit...
- Q3. Spark and its benefits
- Ans.
Spark is a fast and powerful big data processing framework that offers benefits like speed, ease of use, and versatility.
Spark is known for its speed, as it can process data up to 100 times faster than traditional Hadoop MapReduce.
It offers ease of use with high-level APIs in Java, Scala, Python, and SQL, making it accessible to a wide range of users.
Spark is versatile, supporting various workloads such as batch proces...
- Q4. Why to leave the company
- Q5. Huddles of data engineer
- Ans.
Huddles of data engineers refer to collaborative meetings or discussions among data engineers to share insights, solve problems, and make decisions.
Huddles are typically informal and can be scheduled or ad-hoc.
They provide a platform for data engineers to brainstorm, troubleshoot, and exchange ideas.
Huddles may involve reviewing code, discussing data pipelines, or addressing technical challenges.
Effective huddles promo...
Skills evaluated in this interview
chakri ck
(2 Questions)
- Q1. About joins and sql and python
- Q2. About data analysis , model building
I applied via Walk-in and was interviewed in Nov 2024. There were 2 interview rounds.
Online aptitude test with maths and statistics and data analysis
(1 Question)
- Q1. Joins sql groups python numpy pandas
ananthakrishnan
Selected
I applied via Campus Placement and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. What is star topology
- Q2. Hybrid topology
Interview Preparation Tips
Aditya Nawale
Logical,verbal,quants
(2 Questions)
- Q1. What is lambda function
- Q2. What is subquary
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. How to perform Set Actions, LOD's
US MNC Interview FAQs
Tell us how to improve this page.
US MNC Interviews By Designations
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
|
Head Human Resources
6
salaries
|  ₹23 L/yr - ₹51 L/yr |
|
Cost and Progress Manager
4
salaries
| ₹13 L/yr - ₹15.5 L/yr |
|
Associate Manager
4
salaries
| ₹16.4 L/yr - ₹31 L/yr |
|
Senior Manager Technology
4
salaries
| ₹2 L/yr - ₹2 L/yr |
|
Senior SAP MM Consultant
4
salaries
| ₹14.8 L/yr - ₹15 L/yr |
Microsoft Corporation
Amazon
Apple
Calculate your in-hand salary
- Home >
- Interviews >
- US MNC Interview Questions >
- US MNC Data Analyst Interview Questions
