AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Lenovo
Compare
Filter interviews by
Lenovo Data Analyst Interview Questions and Answers
Lenovo Data Analyst Interview Experiences
1 interview found
James Stalon
(2 Questions)
- Q1. Sql rank order explain
- Ans.
SQL rank order function explanation
Rank order function in SQL assigns a rank to each row based on a specified column
It can be used to determine the top or bottom N records in a dataset
Example: SELECT column1, column2, RANK() OVER (ORDER BY column3 DESC) AS rank_order FROM table_name
- Q2. Merging two tables
- Ans.
Merging two tables involves combining data from both tables based on a common key.
Identify a common key between the two tables
Use SQL JOIN statements to merge the tables
Choose the appropriate type of join (e.g. inner join, outer join)
Consider the size of the tables and the performance implications of the merge
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Divya Shree
(2 Questions)
- Q1. What is join in sql
- Ans.
Join in SQL is used to combine rows from two or more tables based on a related column between them.
Join is used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q2. What is primary key
- Ans.
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is uniquely identified
It must contain unique values and cannot have NULL values
Primary key can be a single column or a combination of columns
Example: 'ID' column in a 'Users' table can be a primary key
Skills evaluated in this interview
Anonymous
(2 Questions)
- Q1. What is an inactive relationship in PBI
- Ans.
An inactive relationship in Power BI is a relationship that is not being used in any visualizations or calculations.
Inactive relationships can occur when a relationship is created but not utilized in any measures or visuals.
These relationships do not impact the data model or query performance, but can clutter the model view.
To remove an inactive relationship, you can delete it from the relationship view in Power BI.
Ina...
- Q2. Import vs Direct Query vs Live connection
- Ans.
Import vs Direct Query vs Live connection
Import: Data is imported into the tool for analysis, suitable for small datasets or when real-time data is not required
Direct Query: Data is queried directly from the source in real-time, suitable for large datasets or when up-to-date data is needed
Live connection: Data is connected live to the source, allowing for real-time updates and analysis without storing data locally
Skills evaluated in this interview
Selected
(1 Question)
- Q1. Asked to create a power bi dashboard
(1 Question)
- Q1. Had coding test on SQL and Python
Data Analyst Interview Questions & Answers
Whirlpool
POOJA DNYANESHWAR DEWALKAR
posted on 5 Jun 2024
Selected
I applied via Naukri.com and was interviewed before Jun 2023. There were 2 interview rounds.
SQL coding and MCQ duration 45 min
(2 Questions)
- Q1. Job responsibilities
- Q2. Power BI, tableau, SQL, python
Selected
I applied via LinkedIn and was interviewed before Dec 2022. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. About yourself n work profile
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed before May 2021. There were 2 interview rounds.
(1 Question)
- Q1. Explain IOT database
- Ans.
IOT database is a database that stores data generated by Internet of Things (IOT) devices.
IOT database is designed to handle large volumes of data generated by IOT devices.
It stores data in a structured format that can be easily queried and analyzed.
IOT databases often use NoSQL databases like MongoDB or Cassandra.
Examples of IOT databases include AWS IoT Core, Azure IoT Hub, and Google Cloud IoT Core.
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed in Dec 2024. There were 2 interview rounds.
How to ready for my work
(2 Questions)
- Q1. What type of work do you typically perform in an office setting?
- Q2. How to developed for in team working
Interview Preparation Tips
- Data Entry
15 statistical and logical questions
2 easy to medium coding problmes. e.g. swapping the array.
(2 Questions)
- Q1. What is regression ? how it works
- Ans.
Regression is a statistical method used to analyze the relationship between variables and predict outcomes.
Regression models the relationship between a dependent variable and one or more independent variables.
It works by finding the best-fit line that minimizes the sum of squared differences between the actual and predicted values.
Examples include linear regression, polynomial regression, and logistic regression.
- Q2. Questions on recent projects
(1 Question)
- Q1. Basic back ground check
Skills evaluated in this interview
Data Engineer Interview Questions & Answers
BSH Home Appliances Group
Preetham Abhi
posted on 2 Jan 2025
(1 Question)
- Q1. Data engineering related
(2 Questions)
- Q1. Introduce yourself
- Q2. Expectations
(1 Question)
- Q1. Offers and benefits
Lenovo Interview FAQs
Tell us how to improve this page.
Lenovo Interviews By Designations
- Lenovo Quality Engineer Interview Questions
- Lenovo Assembly Engineer Interview Questions
- Lenovo Associate Company Secretary Interview Questions
- Lenovo Backend Developer Interview Questions
- Lenovo Brand Promoter Interview Questions
- Lenovo Category Manager Interview Questions
- Lenovo Data Analyst Interview Questions
- Lenovo Data Engineer Interview Questions
- Show more
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
Lenovo Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Lenovo Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Regional Channel Manager
76
salaries
|  ₹12 L/yr - ₹36.5 L/yr |
|
Sales Executive
69
salaries
| ₹1.8 L/yr - ₹4 L/yr |
|
Technical Support Engineer
56
salaries
| ₹2.1 L/yr - ₹4.8 L/yr |
|
Area Sales Officer
54
salaries
| ₹4.1 L/yr - ₹8 L/yr |
|
Area Sales Manager
32
salaries
| ₹3.5 L/yr - ₹12 L/yr |
Dell
Helmerich & Payne
Acer India
ASUS
- Home >
- Interviews >
- Lenovo Interview Questions >
- Lenovo Data Analyst Interview Questions
