KPMG India Senior Data Analyst Interview Questions and Answers

Q1. SQL window function
Add your answer
Q2. Python data mining of unstructured data
Ans. 
Python data mining of unstructured data involves extracting valuable insights from text, images, videos, etc.
• Use Python libraries like NLTK, spaCy, and scikit-learn for text mining

• Utilize techniques like natural language processing (NLP) and machine learning for data extraction

• Preprocess data by tokenizing, stemming, and removing stop words before analysis
Answered by AI
Add your answer

Q1. Basic skill discussion
Add your answer
Q2. Basic work experience discussion
Add your answer

Q1. Behavioural questions
Add your answer
Q2. Questions to understand cultural fit
Add your answer

Q1. Questions on PowerBI & Power Query
Add your answer

Q1. Interpersonal communication skills
Add your answer

Q1. How many type of conections are available in Power BI?
Ans. 
There are four types of connections available in Power BI.
• Power BI Desktop Connection

• Power BI Service Connection

• Power BI Mobile Connection

• Power BI Gateway Connection
Answered by AI
Add your answer
Q2. What is incremental refresh in Power BI?
Ans. 
Incremental refresh is a feature in Power BI that allows you to refresh only a portion of your data instead of the entire dataset.
• Incremental refresh is useful for large datasets that take a long time to refresh.

• It allows you to refresh only the new or updated data since the last refresh.

• You can set up incremental refresh by defining a range of values for a column that represents the refresh window.

• For example, you can...read more
Answered by AI
Add your answer
Q3. Diffrence between direct connection and live connection?
Ans. 
Direct connection is a static connection to a data source, while live connection is a dynamic connection that updates in real-time.
• Direct connection requires data to be imported into the analysis tool, while live connection accesses data directly from the source.

• Live connection allows for real-time updates and analysis, while direct connection requires manual refreshing.

• Direct connection is useful for small datasets or...read more
Answered by AI
Add your answer
Q4. Where power pivot is available in Power bi?
Ans. 
Power Pivot is available in Power BI Desktop and Power BI Service.
• Power Pivot is a data modeling tool in Excel that allows you to create relationships between tables and perform complex calculations.

• In Power BI Desktop, you can access Power Pivot by going to the 'Data' tab and selecting 'Manage Relationships'.

• In Power BI Service, you can access Power Pivot by going to the 'Settings' menu and selecting 'Data Sources'.

• Po...read more
Answered by AI
Add your answer
Q5. Use of SELECTEDVALUE() fax function?
Ans. 
SELECTEDVALUE() is a DAX function used to return the value of a column if it has only one distinct value.
• Used in Power BI to retrieve the value of a column if it has only one distinct value

• Returns an error if the column has more than one distinct value

• Can be used in combination with IF statement to handle errors

• Example: SELECTEDVALUE('Table'[Column], 'No value found')

• Example: IF(ISBLANK(SELECTEDVALUE('Table'[Column])),...read more
Answered by AI
Add your answer
Q6. How can we create a dependent slicer in Power bi?
Ans. 
Dependent slicer in Power BI allows filtering of data based on selection in another slicer.
• Create two slicers, one for the main category and another for the sub-category.

• Add the main category slicer to the report page and select the sub-category slicer.

• Go to the Format pane and select the 'Edit interactions' option.

• Choose the 'Filter' option for the sub-category slicer.

• Now, when a main category is selected, the sub-cat...read more
Answered by AI
Add your answer
Q7. How many type of filters are available in Power bi?
Ans. 
There are three types of filters available in Power BI.
• Visual level filters

• Page level filters

• Report level filters
Answered by AI
Add your answer
Q8. How can we share a power bi report with an external user?
Ans. 
To share a Power BI report with an external user, we can use the Publish to Web feature or share it via email.
• Use the Publish to Web feature to generate an embed code that can be shared with external users

• Ensure that the report contains only non-sensitive data before using the Publish to Web feature

• Alternatively, share the report via email by granting access to the external user's email address

• The external user must ha
Answered by AI
Add your answer

Q1. Explain all types of joins
Ans. 
Different types of joins in SQL are inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns rows when there is a match in either table
Answered by AI
Add your answer
Q2. Difference between having and where
Ans. 
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.
• HAVING is used with GROUP BY to filter groups based on aggregate functions results

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROU...read more
Answered by AI
Add your answer

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Q1. What is DSA , sorting , difference between array and linked list
Ans. 
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
• DSA stands for Data Structures and Algorithms

• Sorting is the process of arranging data in a particular order

• Arra...read more
Answered by AI
Add your answer
Q2. Written a SQL query
Add your answer

Q1. Coding question like add numbers
Add your answer
Q2. Experience on your project
Ans. 
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
• Developed predictive models to forecast customer behavior and optimize marketing strategies

• Conducted market research to identify trends and opportunities for growth

• Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Answered by AI
Add your answer

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. 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
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

Q1. How good are you with numbers
Add your answer

Q1. Vlookup, pivot table, sumif, average, graphs
Add your answer

Q1. Do you know the role and responsibility of this position
Add your answer