KPMG India Senior Data Analyst Interview Questions and Answers

Q1. Questions on SQL, C++
Add your answer

Q1. Basics of power bi and sql
Add your answer
Q2. What are joins and types of join
Add your answer
Q3. How to add date table in power bi
Ans. 
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
• Create a new table in Power BI with a list of dates

• Add columns for day, month, year, etc. for additional analysis

• Establish relationships between the date table and other tables in the data model
Answered by AI
Add your answer

Q1. Sql scenario based question on joins
Add your answer
Q2. Window function questions
Add your answer
Q3. Performance tuning
Add your answer
Q4. Power bi dax question
Add your answer

A test designed to a determination a person ability in particular skill of field knowledge

Coding and decoding

Devolpment of a particular person group or situation over a period of time

Q1. Relating to a particular Subject art or carft or its techNical Terms
Add your answer

Is a situation faced when individuals collectively make a choice from alternative before them

A task or piEce of work allocated to someone a part of a job or course of study a home work assignment

Q1. InvolVoing or concerned with applied and industrial science
Add your answer

Coding interview test candidate technical knowledge coding ability creativity typically on a white board

Q1. Managing an organisation employees
Add your answer

Q1. Each player from one team is matched a single player from other team
Add your answer

The from are checked and returned to the census officer for coding

Basic aptitude questions liek tiem distance, percentage , ratio, work and hour

Excel, Numpy, Pandas, basic ML

Case study talking about how to optimise the supply chain using data analytics

Q1. Power BI Difference between ALL() and ALLSELECTED()
Ans. 
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
• ALL() removes all filters from the specified column or table.

• ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

• Example: ALL('Table') would remove all filters on the 'Table' in the query context.

• Example: ALLSELECTED('Column') would remove filte...read more
Answered by AI
Add your answer
Q2. Excel Difference between COUNT() and COUNTA()
Ans. 
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
• COUNT() counts only cells with numerical values.

• COUNTA() counts all non-empty cells, including text and errors.

• Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
Answered by AI
Add your answer

Q1. Resume based questions like explain the projects that you have done.
Add your answer
Q2. Sample dataset questions
Add your answer

Q1. A little about Alteryx.
Ans. SQL queries writing -join , like, limit, group by . Alteryx: basic join , transpose, Alteryx scheduler.
Answered Anonymously
Add your answer
Q2. Sql related queries.
Ans. Sql queries writing join like group by
Answered Anonymously
Add your answer