Preview Questions Data Analyst | Role Specific Skill

Question 1: Which of the following tools would be most effective for automating the generation of financial reports in BFSI?

Which action should you take?

Choose only one option

Power BI with scheduled refresh

Microsoft Word

R Markdown

Excel with manual pivoting

Question 2: When testing for the effectiveness of a new financial product, which statistical test would you use to compare more than two independent groups?

Which action should you take?

Choose only one option

Chi-square test

Paired t-test

Kruskal-Wallis H test

Z-test

Question 3: Which of the following is an appropriate method to identify trends in the credit default rates of loans over time in a financial institution?

Which action should you take?

Choose only one option

Principal component analysis

Time series decomposition

Regression analysis

K-means clustering

Question 4: To visualize the distribution of financial product sales across regions, which visualization technique would best show regional differences?

Which action should you take?

Choose only one option

Choropleth map

Heatmap

Line chart

Box plot

Question 5: How should duplicate records in a financial dataset be handled to avoid biases in analysis?

Which action should you take?

Choose only one option

Replace duplicates with averages

Keep all duplicates for historical reference

Retain only the first occurrence and remove others

Drop all duplicate rows without any analysis

Question 6: What is the most appropriate approach to document the steps involved in cleaning a complex financial dataset for reporting in BFSI?

Which action should you take?

Choose only one option

Create a step-by-step log of each transformation with date and reason

Use a high-level summary with key points

Provide only the final dataset with comments on issues encountered

Document the entire data cleaning process in a flowchart