Cleartrip Legal Advisor Interview Questions and Answers

Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
Add your answer
Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
Add your answer
Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.
Add your answer

Q1. Difference between rank and dense rank
Ans. 
Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.
• Rank assigns unique ranks to each distinct value in a dataset

• Dense rank does not leave gaps between ranks, assigning consecutive ranks to values with the same rank

• For example, if values are 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3
Answered by AI
Add your answer
Q2. How will merge multiple file in python
Ans. 
Merge multiple files in Python using pandas.concat() or pd.merge() functions.
• Use pandas.concat() function to merge multiple files vertically (row-wise).

• Use pd.merge() function to merge multiple files horizontally (column-wise) based on a common column.

• Ensure that the files have compatible column names and data types before merging.

• Handle any missing or duplicate values appropriately during the merging process.

• Consider ...read more
Answered by AI
Add your answer
Q3. Data frame explain in detail
Ans. 
A data frame is a two-dimensional data structure in which data is stored in rows and columns.
• Data frames are commonly used in programming languages like R and Python for data analysis.

• Each column in a data frame represents a variable, while each row represents an observation.

• Data frames can contain different types of data, such as numeric, character, and factor.

• Data frames can be created from various sources like CSV f
Answered by AI
Add your answer

Q1. When I initially joined my job right after college there was a point where I was constantly
Add your answer
Q2. It's a great organisation and I've learner a lot here but it's such a small company that it's difficult to find ways to move up ask yourself what makes you feel passionate or happy when you work😊
Add your answer
Q3. Opportunity great time interest must
Add your answer

Group discussion can also provide feedback to instructors on participant comprehension.

Q1. Tell me about yourself.
Add your answer

Q1. Introduction of yourself
Add your answer

Assignment of Google sheets

Q1. Self introduction
Add your answer
Q2. What do you know about analysis and logical reasoning
Ans. 
Analysis and logical reasoning involve examining data, identifying patterns, and drawing conclusions based on evidence.
• Analysis involves breaking down complex information into smaller components for better understanding.

• Logical reasoning is the process of using rational thinking to make sense of information and draw valid conclusions.

• Analytical skills are essential for interpreting data accurately and making informed d...read more
Answered by AI
Add your answer

Send assignment doings MS Excel

Q1. Asked about the previous project
Add your answer
Q2. What about your roles in previous company
Add your answer

The test lasted about an hour and included data structures, algorithms and basic problem solving.

Q1. What some projects you've worked on before and how have you helped improve efficiency?
Ans. 
I have worked on various data analysis projects, focusing on improving efficiency through data-driven insights and automation.
• Developed a dashboard for sales data analysis, reducing report generation time by 50%.

• Automated data cleaning processes, which decreased manual effort by 30 hours per month.

• Implemented predictive analytics for inventory management, leading to a 20% reduction in stockouts.

• Conducted A/B testing fo...read more
Answered by AI
Add your answer
Q2. Introduce yourself
Ans. 
Data Analyst with a passion for transforming data into actionable insights, skilled in SQL, Python, and data visualization tools.
• Educational Background: Bachelor's degree in Statistics, where I developed a strong foundation in data analysis techniques.

• Technical Skills: Proficient in SQL for database management and data extraction, and Python for data manipulation and analysis.

• Experience: Worked on a project analyzing c...read more
Answered by AI
Add your answer