Crif Solutions Business Analyst Interview Questions and Answers

Q1. What are window functions and asked to find out the highest salary from each department.
Add your answer
Q2. What is Vlookup and formula of it
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is used to search for a value in the first column of a table and return a value in the same row from a specified column

• The syntax of Vlookup is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search...read more
Answered by AI
Add your answer

Q1. What do you know about TU CIBIL
Ans. 
TU CIBIL is a credit information company in India that provides credit scores and reports to individuals and businesses.
• TU CIBIL stands for TransUnion CIBIL Limited.

• It is one of the leading credit bureaus in India.

• It collects and maintains credit information of individuals and businesses.

• Lenders use TU CIBIL reports to assess the creditworthiness of borrowers.

• A good credit score from TU CIBIL can help in getting better
Answered by AI
Add your answer
Q2. What is credit score
Ans. 
Credit score is a numerical representation of a person's creditworthiness, based on their credit history.
• Credit score ranges from 300 to 850, with higher scores indicating better creditworthiness.

• Factors that influence credit score include payment history, credit utilization, length of credit history, types of credit used, and new credit accounts.

• Lenders use credit scores to assess the risk of lending money to individu...read more
Answered by AI
Add your answer
Q3. How many credit bureau's are there
Add your answer

Q1. About data profiling
Add your answer
Q2. Data mapping questions
Add your answer

Q1. Problem solving questions
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Yet to receive call
Add your answer
Q2. Yet to confirm the dates
Add your answer

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

Topics were, DSA, SQL, PL/SQL, Data Augmentation

Customer churn classification using a classification ML model

Q1. Write a pseudo code for Bubble sort
Ans. 
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.
• Start with the first element and compare it with the next element, swapping if necessary

• Repeat this process for each pair of adjacent elements in the array until the entire array is sorted

• Continue this process for each element in the array until no more swaps are ne
Answered by AI
Add your answer
Q2. What is an API
Ans. 
An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other.
• APIs define the methods for requesting and receiving data between software applications

• APIs can be used to access data from external sources, such as social media platforms or weather services

• Examples of APIs include the Twitter API, Google Maps API, and Spotify API
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills and attention to detail
Answered by AI
Add your answer
Q2. Salaray compensation how much
Add your answer

Sql and aptitude questions

Q1. Question from resume amd project
Add your answer
Q2. Some questions on sql
Add your answer

Q1. Basic questions about resume
Add your answer

Q1. Workplace adjustment questions
Add your answer
Q2. Are you willing to work extra hours
Add your answer