SupplyCopia 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. 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

Q1. Tell me about your self.
Add your answer
Q2. What is your Salary expectation
Add your answer

Q1. Tell me about your self ?
Add your answer
Q2. Explain your previous role.
Add your answer
Q3. Difference between Adverse Event and Adverse reaction with example.
View 1 more answer
Q4. Seriousness criteria of cases Explain Congenital Anomaly.
Add your answer
Q5. In Pregnancy case related question.
Add your answer
Q6. Define Solicited report and Spontaneous report.
Ans. 
Solicited report is a report requested by an authority while spontaneous report is a voluntary report by an individual.
• Solicited report is requested by an authority or organization.

• Spontaneous report is voluntary and not requested.

• Solicited report is usually for a specific purpose or event.

• Spontaneous report is usually for unexpected events or adverse reactions.

• Examples of solicited reports include clinical trial repor...read more
Answered by AI
Add your answer

Tell about yourself ..?

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