Freecharge Business Analyst Interview Questions and Answers

Sql and excel then tableu

Q1. Sql and excel and basic questions
Add your answer

Q1. Longterm aspiration
Add your answer

Excel tests formulas of countifs sumifs

Q1. Why did you quit previous organization
Add your answer
Q2. How did you got to know about acko
Add your answer

Q1. Goden rules of accounts, types of interest?
Ans. 
Golden rules of accounts include debit the receiver, credit the giver, and debit what comes in, credit what goes out. Types of interest include simple and compound interest.
• Golden rules of accounts are basic principles of accounting that guide the recording of financial transactions.

• Debit the receiver means that when a business receives something, it records it as a debit entry.

• Credit the giver means that when a busine...read more
Answered by AI
Add your answer
Q2. Real account, nominal account and personal account. simple and compound interest
Add your answer
Q3. Golden rules of accounts
Ans. 
Golden rules of accounts are basic principles that guide the preparation and presentation of financial statements.
• Maintain accuracy and completeness of financial records

• Ensure consistency in accounting policies and methods

• Separate personal and business transactions

• Record all transactions in a timely manner

• Maintain proper documentation and records

• Ensure compliance with accounting standards and regulations
Answered by AI
Add your answer

Q1. SQL Queries for JOINS
Ans. 
SQL queries for JOINS
• Use INNER JOIN to retrieve rows from both tables that have matching values

• Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table

• Use FULL JOIN to retrieve rows when there is a match in either table
Answered by AI
Add your answer
Q2. QUERY FOR metrics given in the sheet
Ans. 
The query is asking for metrics provided in a specific sheet.
• Identify the specific sheet being referred to in the question

• Review the metrics listed in the sheet

• Analyze the relevance of each metric to the query
Answered by AI
Add your answer

This is a case study round revolve around a business problem in which we have to analyse data driven solutions.

General aptitude questions and excel questions

Q1. Knowledge of excel, guesstimate
Add your answer

Q1. Cultural fitment
Add your answer

Marketing campaign case study

Quantitative aptitude, verbal ability, critical reasoning

Q1. SQL: find store with highest AOV
Ans. 
Use SQL query to find store with highest Average Order Value (AOV).
• Use GROUP BY clause to group by store

• Calculate AOV by dividing total revenue by total orders

• Use ORDER BY and LIMIT to find store with highest AOV
Answered by AI
Add your answer
Q2. Generic behavioural questions
Add your answer

Q1. SQL, Python and Excel
Add your answer