Filter interviews by
The question is asking about using joins and group by in data analysis.
Joins are used to combine data from multiple tables based on a common column.
Group by is used to group rows based on a specific column and perform aggregate functions on the grouped data.
Joins and group by are commonly used together to analyze data from multiple tables.
Examples of joins include inner join, left join, and right join.
Examples of aggre...
I applied via Approached by Company and was interviewed before Jan 2023. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed before Oct 2022. There were 3 interview rounds.
Top trending discussions
I was interviewed in Dec 2024.
-Basic Accounting questions like simple journals , Accounting principles and concepts.
-Basic Excel tasks like questions (commonly used simple formulas ,chart preparation, pivot tables
etc,)
-Email writing.
-Simple Aptitude and Logical Reasoning questions.
Prepare well and try to attend maximum questions with better accuracy. Overall aptitude test is simple.
I was interviewed in Dec 2024.
20 - MCQ test related C&C++ basic to advance
2 - coding questions -
1) create class which allows only one instance creation at a time if you try to create another before deleting existing object then class should throw exception..
2) find the distance between leftmost string and rightmost string(string's chars order doesn't matter) In a given long shuffled string.
Ex :-
Shuffled string = "xaxxcxbxxxcxxaxxbx"
target string= "abc"
Ans: 3
(Leftmost string is last index 6
Right most is 9 so 9-6=3)
Note:- other chars not necessarily 'x' it can be any
posted on 23 Jan 2025
Integrity and honesty
I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.
posted on 31 Dec 2024
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There were 6 interview rounds.
Conducting an interview session involves preparation, active listening, asking relevant questions, and providing a positive experience for the candidate.
Prepare by reviewing the candidate's resume and job description
Create a comfortable environment for the candidate to feel at ease
Ask open-ended questions to encourage detailed responses
Listen actively and take notes to remember key points
Provide clear information about...
Utilize networking, tailor your resume, apply to multiple positions, and follow up with potential employers.
Network with professionals in your desired field to learn about job opportunities.
Customize your resume and cover letter for each job application to highlight relevant skills and experiences.
Apply to a variety of positions to increase your chances of securing a job quickly.
Follow up with potential employers after...
How should I complete my assignments?
How can I effectively complete my tasks?
What training is available to help me perform my job?
I applied via Walk-in and was interviewed in Dec 2024. There were 2 interview rounds.
Process planning refers to the methodical approach of determining the best possible way to manufacture a product or deliver a service by considering various aspects such as resources, timelines, and methodologies involved in production or execution.
Implemented a new chemical process to increase efficiency and reduce waste.
Researched and analyzed current process to identify areas for improvement
Designed and tested new process using simulation software
Collaborated with production team to implement changes and monitor results
Achieved 20% increase in production output and 15% reduction in waste
Continuously monitored and optimized process for further improvements
I utilize a combination of project management tools and communication strategies to effectively manage my team and projects.
I prioritize tasks based on deadlines and importance
I regularly communicate with team members to ensure everyone is on the same page
I use project management software such as Trello or Asana to track progress and assign tasks
I adapt my management style to fit the needs and preferences of individual
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
The Aptitude Test session accesses mathematical and logical reasoning abilities
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for 'Vertical Lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
Reviewing and cleaning large datasets to ensure accuracy
Creating visualizations and reports to communicate insights
Collaborating with team members to identify trends and patterns
Presenting findings to stakeholders in meetings or presentations
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
Proficient in programming languages such as Python, R, SQL
Skilled in statistical analysis and data modeling techniques
Experience with data visualization tools like Tableau, Power BI
Knowledge of machine learning algorithms and techniques
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.
Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.
Pivot tables are commonly used in Excel and other spreadsheet program...
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
Group employees by department
Find the employee with the highest salary in each group
Retrieve the employee's name, salary, and department name
based on 16 reviews
Rating in categories
4-5 Yrs
Not Disclosed
2-4 Yrs
Not Disclosed
4-8 Yrs
Not Disclosed
Data Consultant
27
salaries
| ₹2.2 L/yr - ₹3.5 L/yr |
Data Analyst
22
salaries
| ₹1 L/yr - ₹3.8 L/yr |
Senior Data Analyst
4
salaries
| ₹6.2 L/yr - ₹6.2 L/yr |
Key Account Manager
3
salaries
| ₹5.2 L/yr - ₹5.2 L/yr |
Senior Data Consultant
3
salaries
| ₹5.5 L/yr - ₹6 L/yr |
Tata Group
Reliance Industries
Aditya Birla Group
Mahindra & Mahindra