Premium 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

Clear (1)

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

I applied via Recruitment Consulltant and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about the tool you worked on?
  • Ans. 

    I worked on a data visualization tool for tracking sales performance.

    • The tool was built using Tableau and SQL.

    • It allowed users to view sales data by region, product, and time period.

    • Users could also create custom dashboards and reports.

    • The tool helped identify trends and opportunities for improvement.

    • I collaborated with the sales team to ensure the tool met their needs.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just tell about the flow of the tool and answer honestly.

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
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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

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

  • Answered by AI

Skills evaluated in this interview

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
-
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 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
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Dec 2022. There were 3 interview rounds.

Round 1 - Coding Test 

String Reverse Coding Test


User
Share Detail for coding test

ChatGPT
Certainly! I'd be happy to provide you with details for a coding test. Here's an example of a coding test description:

Title: String Reversal

Description:
Write a function that takes a string as input and returns the reverse of that string. The function should reverse the order of characters in the string and return the reversed string as the output.

Requirements:

The function should be named reverseString and take a single parameter, inputString, of type string.
The function should return a string.
The function should handle both uppercase and lowercase letters.
The function should preserve any whitespace or special characters in the input string.
The function should not use any built-in or library functions that directly solve this problem.
Example:
Input: "Hello, World!"
Output: "!dlroW ,olleH"

Note:

The input string can be of any length.
The input string may contain alphanumeric characters, whitespace, or special characters.
Evaluation Criteria:

Correctness of the solution.
Efficiency and clarity of the code.
Proper handling of edge cases and error conditions.
Adherence to coding best practices.
Please complete the task within 30 minutes and submit your solution as a single file. Feel free to use any programming language you are comfortable with.
Good luck!

Round 2 - Aptitude Test 

String Reverse Coding Test


User
Share Detail for coding test

ChatGPT
Certainly! I'd be happy to provide you with details for a coding test. Here's an example of a coding test description:

Title: String Reversal

Description:
Write a function that takes a string as input and returns the reverse of that string. The function should reverse the order of characters in the string and return the reversed string as the output.

Requirements:

The function should be named reverseString and take a single parameter, inputString, of type string.
The function should return a string.
The function should handle both uppercase and lowercase letters.
The function should preserve any whitespace or special characters in the input string.
The function should not use any built-in or library functions that directly solve this problem.
Example:
Input: "Hello, World!"
Output: "!dlroW ,olleH"

Note:

The input string can be of any length.
The input string may contain alphanumeric characters, whitespace, or special characters.
Evaluation Criteria:

Correctness of the solution.
Efficiency and clarity of the code.
Proper handling of edge cases and error conditions.
Adherence to coding best practices.
Please complete the task within 30 minutes and submit your solution as a single file. Feel free to use any programming language you are comfortable with. Good luck!





User
Share derail for amplitude test

ChatGPT
Certainly! Here's an example of a coding test description for an amplitude test:

Title: Finding Amplitude

Description:
Write a function that takes a list of integers as input and returns the amplitude of the list. The amplitude of a list is defined as the difference between the largest and smallest elements in the list.

Requirements:

The function should be named findAmplitude and take a single parameter, inputList, which is a list of integers.
The function should return an integer representing the amplitude of the input list.
The function should handle both positive and negative integers.
The function should handle an empty list as input and return 0 as the amplitude.
Example:
Input: [2, 5, 9, -1, 3, 7]
Output: 10

Explanation:
The largest element in the list is 9, and the smallest element is -1. Therefore, the amplitude is 9 - (-1) = 10.

Note:

The input list can contain duplicates.
The input list can be of any length.
Evaluation Criteria:

Correctness of the solution.
Efficiency and clarity of the code.
Proper handling of edge cases and error conditions.
Adherence to coding best practices.
Please complete the task within 30 minutes and submit your solution as a single file. Feel free to use any programming language you are comfortable with.
Good luck!

Round 3 - Group Discussion 

Certainly! Here's an example of a group discussion topic:

Topic: The Impact of Artificial Intelligence on the Job Market

Description:
In this group discussion, we will explore the impact of artificial intelligence (AI) on the job market. AI is rapidly advancing, and its integration into various industries and sectors has raised concerns about the future of work.

Points to consider:
Potential job displacement: Discuss how AI has the potential to automate tasks and replace human jobs in various fields. Explore which industries or job roles are most susceptible to automation and the potential consequences for workers.

Job creation: Explore the other side of the argument and discuss how AI can also create new job opportunities. Consider the emergence of AI-related roles such as data scientists, AI trainers, and AI ethicists. Discuss the skills and expertise required for these new job roles.

Skills and education: Discuss the importance of skills development and education in adapting to the changing job market. Explore what skills will be in high demand in an AI-driven economy and how individuals and organizations can upskill or reskill to remain relevant.

Ethical considerations: Consider the ethical implications of AI in the job market. Discuss issues such as algorithmic bias, data privacy, and the responsibility of companies and policymakers in ensuring a fair and inclusive job market.

Job market transformation: Discuss the overall transformation of the job market due to AI. Explore how AI is reshaping traditional job roles, the gig economy, and the potential for new forms of work, such as remote work and flexible arrangements.

Guidelines:

Each participant should express their thoughts and ideas clearly and respectfully.
Encourage active listening and give everyone an opportunity to speak.
Support your arguments with relevant examples or data, if possible.
Be open to different perspectives and engage in constructive debate.
Evaluation Criteria:

Clarity of thought and expression.
Ability to articulate and support arguments.
Active participation and engagement with other participants.
Respectful and collaborative attitude towards the group discussion.
Please prepare your thoughts on the topic before the discussion. The group discussion will last for approximately 30 minutes. Good luck!

Interview Preparation Tips

Interview preparation tips for other job seekers - As a data science job seeker, here are some key pieces of advice to help you in your job search:

Develop a Strong Foundation: Ensure you have a solid understanding of the fundamental concepts and techniques in data science. This includes knowledge of statistics, mathematics, programming (Python and R are commonly used), machine learning algorithms, and data manipulation.

Build a Portfolio: Create a portfolio that showcases your data science skills and projects. This could include personal projects, Kaggle competition entries, or contributions to open-source projects. A portfolio demonstrates your practical experience and can set you apart from other candidates.

Gain Practical Experience: Seek out opportunities to work on real-world data science problems. Consider internships, freelance projects, or collaborations with researchers or companies. Practical experience not only enhances your skills but also demonstrates your ability to apply your knowledge to solve real problems.

Stay Updated: Keep up with the latest developments in the field of data science. Follow blogs, participate in online forums and communities, and attend conferences or webinars. Being aware of emerging technologies, techniques, and trends shows your dedication to continuous learning and growth.

Network: Build connections within the data science community. Attend industry events, join professional organizations, and engage with professionals through social media platforms like LinkedIn and Twitter. Networking can lead to valuable job opportunities, referrals, and insights into the industry.

Customize Your Applications: Tailor your resume and cover letter for each job application. Highlight relevant skills, projects, and experiences that align with the specific requirements of the position. A personalized application shows your attention to detail and genuine interest in the role.

Prepare for Interviews: Be prepared for technical interviews that assess your data science skills. Practice coding exercises, algorithmic problem-solving, and be able to explain your projects in a clear and concise manner. Additionally, be prepared to answer behavioral and situational questions to demonstrate your problem-solving, teamwork, and communication skills.

Continuously Learn and Improve: Data science is a rapidly evolving field, so embrace a growth mindset. Seek opportunities to learn new techniques, explore new domains, and expand your skill set. Take online courses, attend workshops, or pursue advanced degrees if necessary. Show that you are committed to staying ahead of the curve.

Emphasize Communication Skills: Data scientists are not just expected to analyze data but also effectively communicate their findings to non-technical stakeholders. Develop your ability to present complex concepts in a clear and concise manner, both verbally and in written form. Strong communication skills will make you a valuable asset to any organization.

Be Persistent and Resilient: The job search process can be challenging and may require time and perseverance. Don't get discouraged by rejection or setbacks. Learn from each experience, seek feedback, and continuously refine your approach. With persistence and a positive attitude, you'll increase your chances of landing a data science job.

Remember, the field of data science is highly competitive, so it's important to stand out from the crowd. By following these tips and continuously improving your skills, you can increase your chances of securing a rewarding job in data science. Good luck with your job search!
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
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.
Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

INTERVIEWS

Tredence

No Interviews

INTERVIEWS

IMS People

No Interviews

SALARIES

Lenovo

SALARIES

StrideOne

INTERVIEWS

IMS People

No Interviews

INTERVIEWS

Ziqitza Health Care

No Interviews

INTERVIEWS

Xava Web Services

No Interviews

INTERVIEWS

IMS People

No Interviews

INTERVIEWS

Edelweiss

No Interviews

DESIGNATION

Tell us how to improve this page.

Lenovo Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Join Lenovo Smarter Technology for All
Lenovo Data Analyst Salary
based on 19 salaries
₹4.8 L/yr - ₹16 L/yr
49% 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
76 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Executive
60 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Support Engineer
55 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Sales Officer
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Sales Manager
32 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Lenovo with

Dell

4.0
Compare

Helmerich & Payne

4.0
Compare

Acer India

4.2
Compare

ASUS

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