Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Lenovo Team. If you also belong to the team, you can get access from here

Lenovo Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Lenovo Data Analyst Interview Questions and Answers

Updated 30 Jun 2024

Lenovo Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image James Stalon

posted on 30 Jun 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(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

  • Answered by AI
  • 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

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. What is Data
  • Ans. 

    Data is a collection of facts, figures, or statistics that can be analyzed to gain insights and make informed decisions.

    • Data can be structured or unstructured

    • Data can be qualitative or quantitative

    • Examples of data include customer demographics, sales figures, and website traffic

    • Data can be analyzed using various tools and techniques to extract meaningful insights

  • Answered by AI
  • Q2. Data types

Skills evaluated in this interview

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

(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...

  • Answered by AI
  • 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

  • Answered by AI

Skills evaluated in this interview

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

Skil set for My relevant job update

Round 2 - Group Discussion 

Communication discussion

Round 3 - One-on-one 

(2 Questions)

  • Q1. About My profile and knowledge
  • Q2. About My attitude and experience
Round 4 - Technical 

(1 Question)

  • Q1. Excel formula and macro MS word and PowerPoint dashboard advanced Excel and power bi

Interview Questionnaire 

3 Questions

  • Q1. Rate yourself in ADVANCED EXCEL, AND SQL
  • Ans. 

    I rate myself 8/10 in Advanced Excel and 9/10 in SQL.

    • Advanced Excel: proficient in pivot tables, VLOOKUP, macros, and data visualization

    • SQL: skilled in writing complex queries, joins, subqueries, and stored procedures

    • Experience in using Excel and SQL together to analyze large datasets

  • Answered by AI
  • Q2. How to Work with dynamic data, how to remove duplicate data or fix the data
  • Ans. 

    To work with dynamic data, remove duplicates and fix errors, use data cleaning techniques.

    • Use software tools like OpenRefine or Excel to clean data

    • Identify and remove duplicate data using unique identifiers

    • Fix errors by standardizing data formats and using regular expressions

    • Use data validation to ensure accuracy and completeness

    • Create a data cleaning plan and document all changes made

    • Test the cleaned data to ensure it

  • Answered by AI
  • Q3. Difference between formula and a function
  • Ans. 

    Formula is a mathematical expression while function is a pre-built formula that performs a specific task.

    • Formula is a combination of mathematical operators and values used to calculate a result.

    • Function is a pre-built formula that performs a specific task, such as finding the average of a range of numbers.

    • Formulas can be customized and modified, while functions are fixed and cannot be changed.

    • Examples of functions incl

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident in your reply, communication is most important

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Introduction about our self
  • Ans. 

    I am a data analyst with 5 years of experience in analyzing and interpreting complex data sets to drive business decisions.

    • I have a strong background in statistical analysis and data visualization techniques.

    • Proficient in SQL, Python, and Tableau for data manipulation and reporting.

    • Experience in developing predictive models and conducting A/B testing to optimize marketing strategies.

  • Answered by AI
  • Q2. Complete discussion about projects

Interview Preparation Tips

Interview preparation tips for other job seekers - prepaire well
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed before Apr 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 

The diagonals AC and BD of a cyclic quadrilateral ABCD intersect each other at the point P. Then, it is always true that

Round 2 - One-on-one 

(2 Questions)

  • Q1. Nding Now DSA Data Structures Algorithms Interview Preparation Data Science Topic-wise Practice C C++ Java JavaScript Python Competitive Programming Machine Learning Aptitude Write & Earn Web Development P...
  • Q2. Everything you need to know about the job-search process itself.nding Now DSA Data Structures Algorithms Interview Preparation Data Science Topic-wise Practice C C++ Java JavaScript Python Competitive Prog...

Interview Preparation Tips

Interview preparation tips for other job seekers - Everything you need to know about the job-search process itself.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

It was not easy only people can clear who are better in pandas and numpy

Round 2 - Technical 

(1 Question)

  • Q1. Mostly focus on graphs and dp

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Dsa questions in java questions- dynamic programming

Round 2 - HR 

(2 Questions)

  • Q1. Resume based questions were asked
  • Q2. Expectatons from job
  • Ans. 

    I expect a challenging role where I can utilize my analytical skills to solve complex problems and contribute to the success of the organization.

    • Opportunity to work with large datasets and use statistical analysis to derive insights

    • Collaboration with cross-functional teams to drive data-driven decision making

    • Continuous learning and professional development opportunities

    • Clear communication of findings and recommendation

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about the project you have worked recently
  • Ans. 

    Developed a predictive analytics model to forecast customer churn for a telecom company

    • Used Python and SQL to clean and analyze customer data

    • Implemented machine learning algorithms such as logistic regression and random forest

    • Evaluated model performance using metrics like accuracy, precision, and recall

  • Answered by AI
  • Q2. What kind of forecasting have you done
  • Ans. 

    I have experience in time series forecasting using statistical models and machine learning algorithms.

    • Utilized ARIMA model to forecast sales data for a retail company

    • Implemented Prophet algorithm to predict stock prices for a financial institution

    • Used LSTM neural network for demand forecasting in supply chain management

  • Answered by AI
Round 2 - Assignment 

Excel assessment- was made to make a report from multiple sheets

Lenovo Interview FAQs

How many rounds are there in Lenovo Data Analyst interview?
Lenovo interview process usually has 1 rounds. The most common rounds in the Lenovo interview process are One-on-one Round.
What are the top questions asked in Lenovo Data Analyst interview?

Some of the top questions asked at the Lenovo Data Analyst interview -

  1. sql rank order expl...read more
  2. merging two tab...read more

Tell us how to improve this page.

Lenovo Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Lenovo Data Analyst Salary
based on 19 salaries
₹4.8 L/yr - ₹16 L/yr
46% more than the average Data Analyst Salary in India
View more details

Lenovo Data Analyst Reviews and Ratings

based on 3 reviews

5.0/5

Rating in categories

4.9

Skill development

4.8

Work-life balance

3.8

Salary

4.6

Job security

4.6

Company culture

3.7

Promotions

4.7

Work satisfaction

Explore 3 Reviews and Ratings
Regional Channel Manager
75 salaries
unlock blur

₹12 L/yr - ₹36.5 L/yr

Sales Executive
60 salaries
unlock blur

₹1.8 L/yr - ₹4 L/yr

Technical Support Engineer
57 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Area Sales Officer
53 salaries
unlock blur

₹4.1 L/yr - ₹8 L/yr

Software Engineer
33 salaries
unlock blur

₹9.6 L/yr - ₹24.1 L/yr

Explore more salaries
Compare Lenovo with

Dell

4.0
Compare

Helmerich & Payne

4.0
Compare

Acer India

4.3
Compare

ASUS

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