HP India
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Company Website and was interviewed in Dec 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Mar 2023. There were 2 interview rounds.
I applied via Walk-in and was interviewed before Dec 2020. There were 2 interview rounds.
Top trending discussions
I applied via Recruitment Consulltant and was interviewed before Jul 2021. There was 1 interview round.
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.
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
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
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
I applied via LinkedIn and was interviewed in Jan 2024. There was 1 interview round.
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
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
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
I applied via Naukri.com and was interviewed in Mar 2021. There were 4 interview rounds.
Skil set for My relevant job update
Communication discussion
based on 3 interviews
Interview experience
based on 9 reviews
Rating in categories
Technical Support Engineer
220
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
127
salaries
| ₹0 L/yr - ₹0 L/yr |
Area Sales Manager
78
salaries
| ₹0 L/yr - ₹0 L/yr |
Financial Analyst
74
salaries
| ₹0 L/yr - ₹0 L/yr |
Process Associate
63
salaries
| ₹0 L/yr - ₹0 L/yr |
Dell
Lenovo
Apple
Samsung