Credenca Data Solutions Private Limited Data Analytics Consultant Interview Questions and Answers

Based on my CV, they assigned me a task related to data migration.

Q1. Project reviews
Add your answer
Q2. Attendance regarding
Add your answer

Q1. How would you handle missing dataduring analysis?
Ans. 
Handling missing data involves identifying, assessing, and applying appropriate techniques to manage gaps in datasets.
• Identify missing data: Use methods like 'isnull()' in Python to find missing values.

• Assess the impact: Determine how missing data affects your analysis and results.

• Imputation: Replace missing values with mean, median, or mode. For example, use the median for skewed distributions.

• Remove missing data: If ...read more
Answered by AI
Add your answer
Q2. Explain the difference inner join and left join in SQL ? and example
Ans. 
Inner join returns matching records from both tables, while left join returns all records from the left table and matching from the right.
• Inner Join: Combines rows from two tables where there is a match in both tables.

• Left Join: Returns all rows from the left table and matched rows from the right table; unmatched rows from the right will show NULL.

• Example of Inner Join: SELECT * FROM TableA INNER JOIN TableB ON TableA....read more
Answered by AI
Add your answer
Q3. Which visualisation have tools used and how do you decide which chart to used for a given dataset?
Ans. 
Choosing the right visualization depends on data type, audience, and insights needed.
• Use bar charts for categorical comparisons (e.g., sales by region).

• Line charts are ideal for trends over time (e.g., monthly revenue).

• Pie charts can show proportions but are less effective for many categories.

• Scatter plots help identify relationships between two variables (e.g., age vs. income).

• Heatmaps visualize data density or correl...read more
Answered by AI
Add your answer

Q1. How do you handle conflicting stockholder requirements n a project?
Ans. 
I prioritize stakeholder requirements through effective communication, negotiation, and alignment with project goals.
• Identify and document all stakeholder requirements to understand the full scope.

• Facilitate meetings to discuss conflicting requirements and encourage open dialogue.

• Use prioritization techniques, such as MoSCoW (Must have, Should have, Could have, Won't have), to assess the importance of each requirement.

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