Add office photos
Filter interviews by
Knowlvers Consulting Data Analyst Interview Questions and Answers
Knowlvers Consulting Data Analyst Interview Experiences
1 interview found
I applied via Campus Placement and was interviewed before Mar 2021. There was 1 interview round.
(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 in a single query
Types of join include inner join, left join, right join, and full outer join
Join is performed using the JOIN keyword followed by the table name and ON keyword to specify the related column
Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2
- Q2. What is v lookup and hlookup?
- Ans.
VLOOKUP and HLOOKUP are Excel functions used to search for a specific value in a table and return a corresponding value.
VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
HLOOKUP searches for a value in the first row of a table and returns a value in the same column from a specified row.
Both functions require a lookup value, a table range, a column or...
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I was interviewed in Sep 2024.
(2 Questions)
- Q1. Load data from hdfs using python
- Ans.
Use PyArrow library to load data from HDFS in Python
Install PyArrow library using pip install pyarrow
Use pyarrow.hdfs.connect to connect to HDFS
Use pyarrow.parquet.read_table to read data from HDFS
- Q2. Query to find the top three salaried employees of each department
- Ans.
Query to find the top three salaried employees of each department
Use a SQL query with a window function like ROW_NUMBER() to rank employees within each department based on salary
Partition the data by department and order by salary in descending order
Filter the results to only include rows where the row number is less than or equal to 3
Skills evaluated in this interview
English, quant, logical reasoning
(2 Questions)
- Q1. Wacc, coc, beta
- Q2. Coc, equity, capm
I applied via campus placement at Indian Institute of Technology (IIT), Jodhpur and was interviewed in Jun 2024. There was 1 interview round.
(3 Questions)
- Q1. What is p value?
- Ans.
A p-value is a measure used in statistical hypothesis testing to determine the strength of evidence against the null hypothesis.
A p-value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.
A p-value is compared to a significance level (usually 0.05) to determine if the null hypothesis should be rejected.
A p-value less than the significance level indicates st
- Q2. Tell the output a**2
- Ans.
The output of a**2 is the square of the value of a.
The output is the value of a multiplied by itself
For example, if a = 3, then the output would be 9 (3*3)
- Q3. Difference between append() and concat
- Ans.
append() adds elements to a single DataFrame, while concat() combines multiple DataFrames.
append() is a method used to add rows to a DataFrame.
concat() is a function used to combine multiple DataFrames along a particular axis.
append() modifies the original DataFrame, while concat() returns a new DataFrame.
Example: df1.append(df2) vs pd.concat([df1, df2])
(5 Questions)
- Q1. Questions on DBMS,ML,SQL,PLSQL,OOPS
- Q2. What is polymorphism
- Ans.
Polymorphism is the ability of a function or method to behave differently based on the object it is acting upon.
Polymorphism allows objects of different classes to be treated as objects of a common superclass.
It enables a single interface to be used for different data types or classes.
Examples include method overloading and method overriding in object-oriented programming.
- Q3. Polymorphism is abstraction in object oriented lagnguage used for providing too may forms to single entity
- Q4. What is the major issue you faced inml project
- Q5. What is your biggest strength
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. Join and window functions
- Q2. Python questions and puzzles
Data Analyst Interview Questions & Answers
State Street Corporation
Harshil Sojitra
posted on 27 May 2024
I applied via campus placement at Institute of Management Nirma University, Ahmedabad and was interviewed in Nov 2023. There were 2 interview rounds.
40 questions are there. The que have different categories. Reasoning , critical thinking
(3 Questions)
- Q1. Tell me about your self
- Q2. Question based on the resume
- Q3. What are the project you have done?
Interview Preparation Tips
- DSA
- Basic coding
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
(1 Question)
- Q1. Asked about skillsets & tools used in the current job. I was asked basic questions on SQL & Tableau
Detailed interview on SQL, Tableau & Alteryx
Data Analyst Interview Questions & Answers
SBI Cards & Payment Services
Aniritha Krish
posted on 13 Nov 2024
It is conducted using Hakerrank ,20-60 mins duration
Interview Preparation Tips
Study hard that's it
(1 Question)
- Q1. Tell me about yourself
Basics in aptitude to be studied
Interview Preparation Tips
Knowlvers Consulting Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
People are getting interviews through
Data Analyst Interview Questions from Similar Companies
|
Business Analyst
28
salaries
|  ₹4.5 L/yr - ₹15 L/yr |
|
Consultant
8
salaries
| ₹12.5 L/yr - ₹18 L/yr |
|
Analyst
6
salaries
| ₹5.4 L/yr - ₹7.5 L/yr |
|
Analytics Consultant
4
salaries
| ₹16 L/yr - ₹21 L/yr |
McKinsey & Company
BCG
Deloitte
KPMG India
Calculate your in-hand salary
- Home >
- Interviews >
- Knowlvers Consulting Interview Questions >
- Knowlvers Consulting Data Analyst Interview Questions
