Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Almonds Ai Team. If you also belong to the team, you can get access from here

Almonds Ai Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Almonds Ai Data Analyst Interview Questions and Answers

Updated 19 Dec 2024

Almonds Ai Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Palak tyagi

posted on 19 Dec 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Find the highest salary in SQL?
  • Ans. 

    Use the MAX() function in SQL to find the highest salary.

    • Use the MAX() function along with the column name that contains the salaries.

    • Example: SELECT MAX(salary) FROM employees;

    • Ensure you have the necessary permissions to access the salary data.

  • Answered by AI
  • Q2. VLOOKUP,COUNTIF ALL excel basic question
  • Q3. Power bi (schema and realtion questions)
Round 2 - Technical 

(2 Questions)

  • Q1. Apply index match and match function
  • Ans. 

    Index match and match functions are used in Excel to lookup values in a table.

    • Index match is used to lookup a value in a table based on row and column criteria.

    • Match function is used to find the position of a value in a range.

    • Example: =INDEX(A1:D10, MATCH(lookup_value, A1:A10, 0), MATCH(lookup_value, A1:D1, 0))

  • Answered by AI
  • Q2. Star and dimension schema and window function in SQL
  • Ans. 

    Star and dimension schema are used in data warehousing to organize data, while window functions in SQL are used for analytical queries.

    • Star schema is a type of schema where a central fact table is connected to multiple dimension tables.

    • Dimension schema is a type of schema where each dimension is represented by a separate table.

    • Window functions in SQL are used to perform calculations across a set of table rows related t...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Basic introduction and salary regarding

Interview Preparation Tips

Topics to prepare for Almonds Ai Data Analyst interview:
  • Window funtion
  • basic and advance excel
  • Powerbi

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is Balance sheet
  • Ans. 

    Balance sheet is a financial statement that shows a company's assets, liabilities, and shareholders' equity at a specific point in time.

    • It provides a snapshot of a company's financial position.

    • Assets are what the company owns, liabilities are what it owes, and shareholders' equity is the difference between the two.

    • The balance sheet follows the accounting equation: Assets = Liabilities + Shareholders' Equity.

    • It helps in...

  • Answered by AI
  • Q2. What is bond and types of bonds
  • Ans. 

    A bond is a fixed income investment where an investor loans money to an entity which borrows the funds for a defined period at a fixed interest rate.

    • Types of bonds include government bonds, corporate bonds, municipal bonds, and convertible bonds.

    • Government bonds are issued by governments to fund public spending.

    • Corporate bonds are issued by companies to raise capital for various purposes.

    • Municipal bonds are issued by l...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good and I perform well in the interview.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Referral and was interviewed in Dec 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

It would be a test based on excel

Round 3 - HR 

(2 Questions)

  • Q1. Tell me about yourself?
  • Ans. 

    I am a highly skilled and experienced Business Analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Business Administration with a focus on analytics.

    • I have worked for 5 years as a Business Analyst at XYZ Company, where I successfully implemented data-driven strategies to improve operational efficiency.

    • I am proficient in using various data analysis tools such as Excel, SQL...

  • Answered by AI
  • Q2. She will give some math problem
Round 4 - Behavioral 

(4 Questions)

  • Q1. What is business analyst and whats his role in an organization?
  • Ans. 

    A business analyst is responsible for analyzing business processes and identifying areas for improvement.

    • Gathers and analyzes data to identify problems and opportunities for improvement

    • Works with stakeholders to define business requirements and develop solutions

    • Creates reports and presentations to communicate findings and recommendations

    • Helps to implement and monitor changes to ensure they are effective

    • Examples: identi...

  • Answered by AI
  • Q2. He/she would give a situation and you need to explain the need of business analyst here
  • Q3. He/she would give a math problem to solve
  • Q4. Profit n loss question

Interview Preparation Tips

Topics to prepare for Sciative Solutions Business Analyst interview:
  • Excel
  • Advanced Excel
  • Accounting
Interview preparation tips for other job seekers - Prepare for excel and some math problems like profit n loss, avg, etc
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
-

I appeared for an interview before Mar 2023.

Round 1 - Assignment 

Apptitude test and Excel Test

Round 2 - One-on-one 

(3 Questions)

  • Q1. Interview was done by CEO of the Company
  • Q2. About yourself, past experience
  • Q3. Some Apptitude and excel questions
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Campus Placement and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Aptitude test was basically on excel , creating pivot table , etc

Round 2 - Group Discussion 

Group discusion was ok

Round 3 - HR 

(2 Questions)

  • Q1. Normal question about yourself , internships , role you want
  • Q2. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Sciative was very unfair with the interview process , we had submitted our resume and after screening only 20 -30 students were shortlisted for the interview but , later on they allowed even other students to sit for the interview , even those who were not shortlisted and therefore the girl who got selected was not even on the shortlist .
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Sql and excel basics required
  • Q2. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - basic understanding for sql and excal and maybe python would be helpfull
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Focuis on math and on science language

Round 2 - Coding Test 

Focus on mathematics

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Excel, Maths and LOgical Questions

Round 2 - HR 

(1 Question)

  • Q1. About Experience and Projects
Round 3 - Behavioral 

(1 Question)

  • Q1. About experience
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Hirist and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Went well easy to moderate level

Round 2 - HR 

(1 Question)

  • Q1. Tell me about yourself
  • Ans. 

    I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.

    • Experienced in conducting market research and identifying business opportunities

    • Skilled in creating detailed reports and presentations for stakeholders

    • Proficient in using data analysis tools such as Excel, SQL, and Tableau

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - None

Business Analyst Interview Questions & Answers

Sciative Solutions user image MEDIKONDA SAI (RA2011004020142)

posted on 12 Oct 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

General maths questions

Round 2 - Case Study 

Case study on travel industry

Round 3 - HR 

(1 Question)

  • Q1. It is tech + hr

Interview Preparation Tips

Interview preparation tips for other job seekers - Be perfect in orientation

Almonds Ai Interview FAQs

How many rounds are there in Almonds Ai Data Analyst interview?
Almonds Ai interview process usually has 3 rounds. The most common rounds in the Almonds Ai interview process are Technical and HR.
What are the top questions asked in Almonds Ai Data Analyst interview?

Some of the top questions asked at the Almonds Ai Data Analyst interview -

  1. star and dimension schema and window function in ...read more
  2. Find the highest salary in S...read more
  3. Apply index match and match funct...read more

Tell us how to improve this page.

Almonds Ai Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Almonds Ai Data Analyst Reviews and Ratings

based on 5 reviews

4.4/5

Rating in categories

4.6

Skill development

4.6

Work-life balance

3.9

Salary

4.4

Job security

4.2

Company culture

3.9

Promotions

4.4

Work satisfaction

Explore 5 Reviews and Ratings
Accountant
5 salaries
unlock blur

₹3.8 L/yr - ₹3.8 L/yr

Accounts Manager
4 salaries
unlock blur

₹3.8 L/yr - ₹7.7 L/yr

Accounts & Finance Executive
4 salaries
unlock blur

₹3.8 L/yr - ₹3.8 L/yr

Procurement Manager
4 salaries
unlock blur

₹6.4 L/yr - ₹6.6 L/yr

Category Manager
4 salaries
unlock blur

₹4.4 L/yr - ₹8.5 L/yr

Explore more salaries
Compare Almonds Ai with

Yalamanchili Software Exports

3.3
Compare

ScoreMe Solutions

4.3
Compare

Global Edge Software

3.5
Compare

Trawex Technologies

4.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview