Munich Re Data Analyst Interview Questions and Answers

Object oriented programming, logical technical

Q1. What is joins , ddl,dml,ddl,TCL command
Ans. 
Joins are used to combine rows from two or more tables based on a related column. DDL, DML, and TCL are SQL commands for data manipulation and transaction control.
• Joins are used in SQL to retrieve data from multiple tables based on a related column.

• DDL (Data Definition Language) commands are used to define the structure of database objects like tables, indexes, etc.

• DML (Data Manipulation Language) commands are used to ...read more
Answered by AI
Add your answer

Q1. In which situations what type of charts will be used
Ans. 
Charts are used to represent data visually. Different types of charts are used based on the type of data and purpose.
• Line charts for showing trends over time

• Bar charts for comparing values

• Pie charts for showing proportions

• Scatter plots for showing relationships between variables

• Heat maps for showing density or distribution

• Histograms for showing frequency distribution

• Box plots for showing distribution and outliers

• Gantt
Answered by AI
Add your answer
Q2. Few SQL Join questions
Add your answer

Q1. About job profile
Add your answer

Python coding , excel formulas and expertise required

Q1. KPIs used in the project
Ans. 
Key Performance Indicators (KPIs) are metrics used to evaluate the success of a project.
• KPIs are specific, measurable, achievable, relevant, and time-bound metrics used to track progress towards project goals.

• Examples of KPIs in a data analysis project could include data accuracy, completion time, client satisfaction, and cost savings.

• KPIs help in monitoring and improving the performance of the project team and ensurin
Answered by AI
Add your answer

Q1. Number of rows and columns that can be uploaded in Power BI
Ans. 
Power BI allows uploading up to 1 million rows and 1,500 columns in a dataset.
• Power BI allows uploading a maximum of 1 million rows in a dataset.

• Power BI allows uploading a maximum of 1,500 columns in a dataset.

• Exceeding these limits may result in performance issues.
Answered by AI
Add your answer

Q1. Describe your weakness and strengths
Ans. 
My weakness is overthinking, but my strengths include attention to detail, problem-solving skills, and strong analytical abilities.
• Weakness: tend to overthink situations, which can sometimes lead to indecision

• Strengths: attention to detail, able to identify patterns and trends, strong problem-solving skills, excellent analytical abilities
Answered by AI
Add your answer

Hackerrank test mostly on python and sql

Q1. SQL based questions
Add your answer
Q2. Python based questions
Add your answer

Need to build P&L statement. Fill in the excel sheet with formulae (YoY, Margins, EPS)

Q1. Difference between basic and diluted shares. What is EBITDA and EBITDA margin?
Ans. 
Basic shares are outstanding shares while diluted shares include potential shares from options and convertible securities. EBITDA is earnings before interest, taxes, depreciation, and amortization, while EBITDA margin is the ratio of EBITDA to revenue.
• Basic shares are the total number of outstanding shares of a company's stock, while diluted shares include potential shares from options and convertible securities.

• EBITDA...read more
Answered by AI
Add your answer
Q2. What is COGS? What are the revenue drivers in telecom industry?
Ans. 
COGS stands for Cost of Goods Sold. Revenue drivers in telecom industry include subscriber growth, data usage, and pricing strategies.
• COGS is the cost of producing and delivering a product or service

• In telecom industry, revenue drivers include subscriber growth, data usage, and pricing strategies

• Subscriber growth refers to the number of new customers or users

• Data usage refers to the amount of data consumed by customers

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

Aptitude test related to Financial statement

Q1. Financial ratios
Add your answer
Q2. Cash Flow Statement
Add your answer

Q1. 1.Valuation 2. Revenue drivers 3. DCF
Add your answer
Q2. DCF Valuation KPI
Add your answer