Ganit Softech Senior Data Analyst Interview Questions and Answers

Question on Probability and basic aptitude questions

Q1. Question were related to Past projects
Add your answer
Q2. SQL and Excel medium level questions
Add your answer

Q1. What are joins,
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from th...read more
Answered by AI
Add your answer
Q2. Difference between having and where
Ans. 
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions, while 'where' is used with individual rows.
• HAVING is used to filter groups of rows based on aggregate functions, such as COUNT, SUM, AVG, etc.

• WHERE is used to filter individual rows based on specific conditions.

• HAVING is applied after the GROUP BY clause, while WHERE is applied before.

• Example: SELECT department, A...read more
Answered by AI
Add your answer
Q3. What are analytical functions explain all
Ans. 
Analytical functions are used in SQL to perform calculations across a set of rows related to the current row.
• Analytical functions operate on a group of rows and return a single result for each row.

• They can be used to calculate moving averages, running totals, rank, and percentiles.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG(), SUM(), AVG().
Answered by AI
Add your answer
Q4. What are triggers and how to create them and what is the use of triggers and explain when and how did you use triggers in your previous org
Ans. 
Triggers are database objects that automatically perform an action when a specified event occurs on a particular table or view.
• Triggers are used to enforce business rules, validate data, and maintain data integrity.

• They can be created using SQL commands like CREATE TRIGGER.

• Triggers can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

• An example of using triggers is to automatically upda...read more
Answered by AI
Add your answer

Q1. Sorting Question
Add your answer

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. Mostly they check your communication
Add your answer
Q2. About your previous experience
Add your answer

Just be confident

Same improve on communication skills

Q1. Be strong headed know from c ,python ,c++
Add your answer
Q2. Tell me about yourself
Add your answer

Need to complete online assessments

Q1. Technical round about the coding of SAS and SQL
Add your answer

Q1. Questions on past experience and SAS coding
Add your answer

Q1. About the job fitment
Add your answer

Q1. Salary discussion round
Add your answer

Q1. Cashflow, p&l, balancesheet questions, operating lease, financial lease, SLM & WDV type of depreciation
Add your answer