KPMG India Senior Data Analyst Interview Questions and Answers

Data is a collection of facts, figures, or statistics that can be analyzed to gain insights and make informed decisions.

• Data can be structured or unstructured

• Data can be qualitative or quantitative

• Examples of data include customer demographics, sales figures, and website traffic

• Data can be analyzed using various tools and techniques to extract meaningful insights

Data management involves organizing, storing, protecting, and maintaining data to ensure its accuracy and accessibility.

• Identify the type of data and its source

• Establish a data governance framework

• Implement data security measures

• Use data management tools and software

• Regularly backup and archive data

• Ensure compliance with data regulations

• Monitor data quality and integrity

• Provide access to authorized users only

Data analytics is the process of examining data sets to draw conclusions about the information they contain.

• It involves collecting, cleaning, and transforming data

• Applying statistical and mathematical models to analyze the data

• Visualizing and presenting the results in a meaningful way

• Examples include predicting customer behavior, identifying trends, and optimizing business processes

Analytics helps us make data-driven decisions and improve business outcomes.

• Analytics provides insights into customer behavior and preferences.

• It helps identify trends and patterns in data that can be used to optimize business processes.

• Analytics can also be used to measure the effectiveness of marketing campaigns and other initiatives.

• It enables businesses to make data-driven decisions that lead to improved outcomes a...read more

SQL has four types of joins: Inner Join, Left Join, Right Join, and Full Outer Join.

• Inner Join returns only the matching rows from both tables.

• Left Join returns all the rows from the left table and matching rows from the right table.

• Right Join returns all the rows from the right table and matching rows from the left table.

• Full Outer Join returns all the rows from both tables, with NULL values in the columns where there...read more

Index in SQL is a database object that improves the speed of data retrieval operations.

• Index is created on one or more columns of a table.

• It stores a copy of the data in the indexed columns in a separate structure.

• This allows for faster search and retrieval of data.

• Examples of index types include clustered, non-clustered, and unique indexes.

Char is fixed length while varchar is variable length.

• Char takes up the same amount of space for each value, while varchar only takes up as much space as needed.

• Char is faster for fixed length data, while varchar is more flexible for variable length data.

• Example: char(10) will always take up 10 characters, while varchar(10) will only take up as much space as needed for the value.

• Example: char is commonly used for stori...read more

Substring is a part of a string that is smaller in length and extracted from the original string.

• Substring is a sequence of characters within a string.

• It can be extracted using string slicing or substring functions.

• For example, 'hello world'[0:5] will return 'hello'.

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization involves breaking down a database into smaller, more manageable tables

• Each table should have a primary key that uniquely identifies each record

• Data is then organized into related tables to minimize redundancy

• Normalization helps to prevent data inconsistencies and anomalies

• There are different level...read more