Sub-K IMPACT Solutions Senior Data Analyst Interview Questions and Answers

Questions mainly based on capital market

Q1. Question mainly based on 3 financial statements
Add your answer
Q2. Link between 3 financial statements
Ans. 
The link between the 3 financial statements (Income Statement, Balance Sheet, Cash Flow Statement) is that they are interconnected and provide a comprehensive view of a company's financial performance.
• Income Statement shows the company's revenues and expenses over a period of time, which affects the company's net income.

• Balance Sheet shows the company's assets, liabilities, and equity at a specific point in time, which...read more
Answered by AI
Add your answer
Q3. What is Interest coverage ratio
Ans. 
Interest coverage ratio measures a company's ability to pay interest on its debt with its earnings.
• Interest coverage ratio is calculated by dividing a company's earnings before interest and taxes (EBIT) by its interest expenses.

• A higher interest coverage ratio indicates that a company is more capable of meeting its interest obligations.

• A lower interest coverage ratio may signal financial distress and an increased risk ...read more
Answered by AI
Add your answer
Q4. What is GAAP & Non-GAAP EPS
Ans. 
GAAP EPS is based on generally accepted accounting principles, while Non-GAAP EPS excludes certain expenses or income that are not considered part of normal operations.
• GAAP EPS follows accounting standards set by regulatory bodies like SEC

• Non-GAAP EPS excludes items like one-time expenses or gains to provide a clearer picture of ongoing business performance

• Investors often consider both GAAP and Non-GAAP EPS when evalua
Answered by AI
Add your answer
Q5. What is amortisation
Ans. 
Amortisation is the process of spreading out the cost of an intangible asset over its useful life.
• Amortisation is similar to depreciation, but it is used for intangible assets such as patents, copyrights, and trademarks.

• It helps in matching the expense of the intangible asset with the revenue it generates over time.

• The amortisation expense is recorded on the income statement and reduces the value of the intangible asse...read more
Answered by AI
Add your answer

Q1. SQL Window functions
Add your answer
Q2. Excel computed fields in pivot tables
Ans. 
Excel pivot tables allow users to create computed fields using formulas.
• In Excel pivot tables, computed fields are created by adding a new field with a formula.

• Formulas can be simple arithmetic operations or more complex calculations.

• Computed fields can be used to perform calculations on existing data in the pivot table.

• Examples: calculating profit margin by dividing revenue by cost, calculating average sales per month
Answered by AI
Add your answer
Q3. Difference in precision and recall
Ans. 
Precision is the ratio of correctly predicted positive observations to the total predicted positives, while recall is the ratio of correctly predicted positive observations to the all observations in actual class.
• Precision focuses on the accuracy of positive predictions, while recall focuses on the proportion of actual positives that were correctly identified.

• Precision = TP / (TP + FP)

• Recall = TP / (TP + FN)

• Example: In...read more
Answered by AI
Add your answer

Q1. About past experience
Add your answer
Q2. Past project details
Add your answer