MassMutual Data Analyst Interview Questions and Answers

Q1. How you calculate the tdi and mdi of a customer in sql
Ans. 
To calculate TDI and MDI of a customer in SQL, you need to aggregate and analyze the customer's transaction data.
• Calculate Total Daily Income (TDI) by summing up the income of the customer for each day.

• Calculate Monthly Daily Income (MDI) by averaging the TDI for each day in a month.

• Use SQL functions like SUM, AVG, and GROUP BY to perform the calculations.

• Example: SELECT SUM(income) AS TDI, AVG(income) AS MDI FROM tran
Answered by AI
Add your answer

They asked about the sas,sql,and power bi

Q1. Technical.purely
Add your answer

Q1. Purely tech..and then you present a dashboard on power bi
Add your answer

Q1. Question related to SQL.
Add your answer
Q2. Concept of Data Warehousing.
Ans. 
Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.
• Data warehousing involves extracting data from multiple sources and consolidating it into a central repository.

• It is used for analytical reporting, business intelligence, and decision-making purposes.

• Data warehouses are designed for query and analysis rather than transaction processing.

• Examples of d...read more
Answered by AI
Add your answer

Sql questions based on aggregate and window

Q1. Sql on windows function
Add your answer
Q2. Python data and spark questions
Add your answer

Study hard that's it

Q1. Tell me about yourself
Add your answer

Basics in aptitude to be studied

Q1. Explain Data types in SQL?
Ans. 
Data types in SQL define the type of data that can be stored in a column of a table.
• Data types include integer, float, text, date, boolean, etc.

• Each data type has specific properties and constraints.

• Examples: INT for integers, VARCHAR for variable-length character strings.
Answered by AI
Add your answer
Q2. Explain the difference between DBMS and RDBMS?
Ans. 
DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.
• DBMS stands for Database Management System, which is a software system that allows users to interact with a database.

• RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.

• RDBMS e...read more
Answered by AI
Add your answer

It contained python coding questions as well as machine learning questions

Q1. Sql joins, python codes
Add your answer
Q2. Complete codes and correct erros
Add your answer
Q3. Machine learning
Add your answer

Case study related to my project and background and internship