Codify Software Services Junior Data Analyst Interview Questions and Answers

Q1. What is duel axis
Ans. 
Dual axis is a feature in data visualization where two different scales are used on the same chart to represent two different data sets.
• Dual axis allows for comparing two different measures on the same chart

• Each measure is assigned to its own axis, allowing for easy comparison

• Commonly used in tools like Tableau for creating more complex visualizations
Answered by AI
Add your answer
Q2. What is scatter plot
Ans. 
A scatter plot is a type of data visualization that displays the relationship between two numerical variables through dots on a graph.
• Scatter plots are used to identify patterns and relationships between variables.

• Each dot on the plot represents a single data point with the x-axis representing one variable and the y-axis representing the other variable.

• The pattern of the dots can indicate the strength and direction of ...read more
Answered by AI
Add your answer

Q1. What is blending
Ans. 
Blending is the process of combining multiple data sources or datasets to create a unified view.
• Blending involves merging data from different sources to gain insights or make decisions.

• It helps in creating a comprehensive dataset by combining relevant information from various sources.

• Blending can be done using tools like Tableau, Power BI, or Python libraries like Pandas.

• For example, blending sales data from CRM with c...read more
Answered by AI
Add your answer
Q2. What is joining
Add your answer

Q1. Tell me about your Project
Ans. 
Developed a predictive model to forecast customer churn for a telecommunications company.
• Used machine learning algorithms such as logistic regression and random forest

• Performed data preprocessing and feature engineering to improve model accuracy

• Collaborated with business stakeholders to understand key factors influencing customer churn
Answered by AI
Add your answer

Q1. Personal information related questions and degree related with also details in medical device and pharmacovigilance
Add your answer

Q1. Mostly medical device questions and pharmacovigilance
Add your answer
Q2. Details about pharmacovigilance
Add your answer
Q3. Details about medical device
Add your answer
Q4. It was Abbott Diabetic Care, so question was like any brief idea about diabetes , types of diabetes
Add your answer

Q1. What are the available data types in sql
Ans. 
The available data types in SQL include numeric, character, date/time, and boolean types.
• Numeric data types include integer, decimal, and floating-point types.

• Character data types include char, varchar, and text types.

• Date/time data types include date, time, datetime, and timestamp types.

• Boolean data type represents true or false values.
Answered by AI
Add your answer
Q2. What are the joins available in SQL
Ans. 
Joins are used to combine rows from two or more tables based on related columns.
• INNER JOIN: Returns records that have matching values in both tables.

• LEFT JOIN: Returns all records from the left table and the matched records from the right table.

• RIGHT JOIN: Returns all records from the right table and the matched records from the left table.

• FULL JOIN: Returns all records when there is a match in either left or right tab...read more
Answered by AI
Add your answer
Q3. What is Power bi
Ans. 
Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.
• Power BI is a Microsoft product used for data analysis and visualization.

• It allows users to connect to various data sources and create interactive reports and dashboards.

• Power BI offers a wide range of visualizations, such as charts, graphs, and maps, to present data in a meaningful way.

• Users can perfor...read more
Answered by AI
Add your answer

Q1. Tell me about ur projects
Add your answer

Quantitative, Verbal , numerical etc

Basic Programming questions

Q1. Reversing of String using C
Ans. 
Reversing a string in C using pointers and arrays.
• Use a pointer to the beginning of the string and another pointer to the end of the string.

• Swap the characters at the two pointers and move them towards each other until they meet in the middle.

• Repeat the process until the entire string is reversed.
Answered by AI
Add your answer

Time, arithmetic problems

Sql queries and python basics

Q1. Same advance sql and dashboards
Add your answer

Problem solving using sql and publishing dashboards

Q1. Salary negotiation
Add your answer

Tell about yourself ..?

Q1. About the projects that I have done .Regarding Sql
Add your answer