Convergytics Solutions Data Analyst Interview Questions and Answers

Q1. What's is work experience.
Ans. 
Work experience refers to the practical knowledge and skills gained from employment in a specific field or industry.
• Work experience includes tasks, responsibilities, and projects completed in a professional setting.

• It can be gained through internships, part-time jobs, full-time positions, or volunteer work.

• Work experience helps individuals develop industry-specific skills, build a professional network, and gain a bette...read more
Answered by AI
Add your answer
Q2. Whats is sql and power bi.
Ans. 
SQL is a programming language used for managing and querying databases. Power BI is a business analytics tool for visualizing and analyzing data.
• SQL stands for Structured Query Language and is used to communicate with databases.

• SQL can be used to retrieve, update, and manipulate data in databases.

• Power BI is a data visualization tool that allows users to create interactive reports and dashboards.

• Power BI can connect to...read more
Answered by AI
Add your answer

Normal Group discussion

Q1. Cosing, project management etc
Add your answer

Q1. What is coalesce
Ans. 
Coalesce is a function used to return the first non-null value in a list of expressions.
• Coalesce function is commonly used in SQL to handle null values.

• It takes multiple arguments and returns the first non-null value.

• Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Answered by AI
Add your answer
Q2. What is repartition
Ans. 
Repartition is the process of redistributing data across partitions in a distributed system.
• Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

• It involves moving data between partitions based on certain criteria such as key values or hash functions.

• Repartitioning can be done in Spark using operations like repartition() or coalesce().
Answered by AI
Add your answer

Q1. Non repeatable character
Ans. 
A non repeatable character is a character that appears only once in a given string.
• Iterate through the string and count the frequency of each character

• Identify the characters that have a frequency of 1

• Return the first non repeatable character found
Answered by AI
Add your answer
Q2. Sort list without sort method
Ans. 
Sort list without using sort method
• Create a custom sorting function using loops

• Compare each element with every other element to determine the correct order

• Swap elements based on the comparison results
Answered by AI
Add your answer

Q1. Tableau difference between blend &join
Ans. 
Blend combines data from different data sources in a single view, while join combines data from the same data source.
• Blend is used when data comes from different data sources, join is used when data comes from the same data source

• Blend creates a relationship between data sources without actually merging the data, join merges the data based on a common field

• Blend can be used to combine data from different databases like...read more
Answered by AI
Add your answer

Q1. SQL-related questions working of self join and what will be used in case of 2nd max
Add your answer

Q1. SQL questions such as case statement, joins and advanced sql question.
Add your answer
Q2. PLSQL, tableau basic to advanced question
Add your answer

Q1. Bureau operations,credit data
Add your answer
Q2. Career goals and future plans
Add your answer

Q1. Only two rounds were there
Add your answer
Q2. Na rounds happened after two rounds
Add your answer

Normal Group discussion

Q1. Cosing, project management etc
Add your answer

Q1. Basic details as to why looking for a change
Add your answer

Q1. Intermediate questions for tableau, SQL
Add your answer

Q1. Managerial interview
Add your answer

Q1. Salary negotiation
Add your answer