Corient Business Solutions Finance Accounts Analyst Interview Questions and Answers

Q1. What is difference between calculated column and measure
Ans. 
Calculated columns are pre-defined while measures are dynamic calculations based on user input.
• Calculated columns are computed during data modeling and added to the table

• Measures are computed on the fly based on user input and can be changed dynamically

• Calculated columns are used for static analysis while measures are used for dynamic analysis

• Examples of calculated columns include concatenation of columns, while measur
Answered by AI
Add your answer

Q1. How do you see yours self in 3 years
Add your answer

Q1. Questions regarding past work experience
Add your answer
Q2. How to handle a situation where you require a signature of important person who is in leave?
Ans. 
Delegate the task to a trusted colleague or use electronic signature if possible.
• Delegate the task to a trusted colleague who has the authority to sign in the absence of the important person.

• If electronic signature is an option, request the signature through email or a digital platform.

• If urgent, consider reaching out to the important person on leave through phone or email for alternative solutions.
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and experience working with large datasets

• I am proficient in statistical software such as R and Python

• I have a proven track record of delivering actionable insights to drive business decisions
Answered by AI
Add your answer

Q1. Lookup Function in Excel
Ans. 
Lookup function in Excel helps to find specific data in a table or range of cells.
• Lookup function can be used to search for a specific value in a table or range of cells.

• VLOOKUP and HLOOKUP are two commonly used lookup functions in Excel.

• Lookup functions can be used to retrieve data from another worksheet or workbook.

• Lookup functions can also be used to perform approximate matches or exact matches.

• Lookup functions can
Answered by AI
Add your answer

Q1. About Yourself, Resume related questions, Future career plans
Add your answer

Q1. Questions about your subjects and projects
Add your answer
Q2. Questions on your previous work experience
Add your answer

The aptitude test was to judge your critical thinking and assessing risk.

Q1. Tell us about the complete KYC process.
Ans. 
KYC process involves verifying the identity of customers to prevent fraud and money laundering.
• KYC process involves collecting personal information from customers, such as name, address, and identification documents.

• Verification of the information provided by customers is done through various means, such as document verification, in-person verification, and electronic verification.

• Once the information is verified, the ...read more
Answered by AI
Add your answer
Q2. Tell us about the adverse media.
Ans. 
Adverse media refers to negative news or information about an individual or organization that may impact their reputation.
• Adverse media includes news articles, social media posts, regulatory findings, and other sources of information that highlight potential risks or controversies.

• Analysts use adverse media screening tools to identify and assess any negative information that could pose a risk to a company's reputation ...read more
Answered by AI
Add your answer