Premium Employer

i

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

Affine Verified Tick

Compare button icon Compare button icon Compare
3.5

based on 158 Reviews

Filter interviews by

Affine Data Analyst Interview Questions, Process, and Tips

Updated 19 Dec 2024

Top Affine Data Analyst Interview Questions and Answers

View all 9 questions

Affine Data Analyst Interview Experiences

8 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 18 Nov 2024

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

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Highlight the odd cells in excel
  • Ans. 

    Use conditional formatting to highlight odd cells in Excel

    • Select the range of cells you want to highlight

    • Go to the 'Home' tab and click on 'Conditional Formatting'

    • Choose 'New Rule' and select 'Use a formula to determine which cells to format'

    • Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)

    • Choose the formatting style you want for the odd cells

  • Answered by AI
  • Q2. What are Joins in SQL, explain different joins and their outputs
  • Ans. 

    Joins in SQL are used to combine rows from two or more tables based on a related column between them.

    • 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 the right table

    • RIGHT JOIN returns all rows from the right table and the matched rows from the left table

    • FU...

  • Answered by AI
  • Q3. Query to give running sum of salary
  • Ans. 

    Use window function to calculate running sum of salary in SQL

    • Use window function like SUM() with OVER() clause

    • Partition the data by employee ID if needed

    • Order the data by date or any other relevant column

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your SQL strong and practice joins with problem solving questions

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 21 Mar 2024

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

I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Coding Test 

The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.

Round 2 - Technical 

(1 Question)

  • Q1. Simple questions on SQL were asked.
Round 3 - One-on-one 

(5 Questions)

  • Q1. What is pivot table in Excel?
  • Ans. 

    A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.

    • Pivot tables allow you to analyze and summarize large amounts of data in a spreadsheet.

    • You can easily rearrange the layout of the data to view it from different perspectives.

    • Pivot tables can perform functions like sum, average, count, and more on the data.

    • They are useful for creating reports...

  • Answered by AI
  • Q2. What is 'Data Validation' in Excel?
  • Ans. 

    Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.

    • Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.

    • Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.

    • Data ...

  • Answered by AI
  • Q3. What is the order of execution of an SQL query?
  • Ans. 

    The order of execution of an SQL query involves multiple steps to retrieve data from a database.

    • 1. Parsing: The SQL query is first parsed to check for syntax errors.

    • 2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.

    • 3. Compilation: The optimized query is compiled into an executable form.

    • 4. Execution: The compiled query is executed by the database engine t...

  • Answered by AI
  • Q4. What is the difference between Tree Map and Heatmap in Tableau?
  • Ans. 

    Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.

    • Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.

    • Heatmap visualizes data values using color gradients, with darker colors indicating higher values.

    • Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...

  • Answered by AI
  • Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau?
  • Ans. 

    Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.

    • Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.

    • Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.

    • Extract Data can improve per...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Affine Data Analyst interview:
  • SQL
  • Power Bi
  • Tableau
  • Excel

Skills evaluated in this interview

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate ProblemGiven an array/list of integer numbers 'CHOCOLAT ... read more
asked in Wipro
Q3. Ninja and substringsNinja has been given a string 'STR' containin ... read more
Q4. Maximum In Sliding Windows Of Size KGiven an array/list of intege ... read more
asked in Tredence
Q5. First Repeated CharacterYou are given a string 'STR' of lowercase ... read more

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 17 Oct 2024

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

(1 Question)

  • Q1. SQL and excel questions intermediate

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 19 Dec 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I was interviewed in Jun 2024.

Round 1 - Coding Test 

Easy SQL questions related to sub query

Round 2 - Coding Test 

SQL moderate questions related to joins and window functions

Round 3 - One-on-one 

(1 Question)

  • Q1. Asked about specific tools related to requirement

Interview Preparation Tips

Interview preparation tips for other job seekers - No advice, prepare based on JD

Affine interview questions for designations

 Senior Data Analyst

 (1)

 Business Analyst

 (6)

 Data Scientist

 (5)

 Data Engineer

 (3)

 Senior Data Scientist

 (2)

 Associate Data Scientist

 (1)

 Senior Associate

 (3)

 Consultant

 (1)

Data Analyst Interview Questions & Answers

user image Vikranth Ravikanthi

posted on 16 Aug 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. SQL Questions on Aggregations

Get interview-ready with Top Affine Interview Questions

Data Analyst Interview Questions & Answers

user image Sai Shreyas B.K

posted on 28 Sep 2024

Interview experience
4
Good
Difficulty level
Hard
Process Duration
-
Result
Not Selected

I was interviewed in Aug 2024.

Round 1 - Coding Test 

The sql questions were hard

Data Analyst Interview Questions & Answers

user image Naresh R

posted on 17 Feb 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Difference between Primary Key and Unique Key ?
  • Ans. 

    Primary key uniquely identifies each record in a table, while Unique key allows only unique values but can have null values.

    • Primary key enforces uniqueness and not null constraint on a column

    • Primary key can consist of multiple columns

    • Unique key allows only unique values but can have null values

    • Unique key can be applied to multiple columns as well

  • Answered by AI

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 27 Mar 2023

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

Basic aptitude questions, statics, probability etc

Round 2 - HR 

(2 Questions)

  • Q1. Where do you live in the USA
  • Ans. 

    I live in New York City, the bustling metropolis known for its iconic landmarks and diverse culture.

    • I reside in the heart of Manhattan, surrounded by towering skyscrapers.

    • New York City is home to famous attractions like Times Square, Central Park, and the Statue of Liberty.

    • The city offers a vibrant arts and entertainment scene, with Broadway shows and world-class museums.

    • I enjoy exploring the diverse neighborhoods and ...

  • Answered by AI
  • Q2. Where do you see yourself in 5 years
  • Ans. 

    In 5 years, I see myself as a senior data analyst leading a team, utilizing advanced analytics to drive strategic decision-making.

    • Leading a team of data analysts

    • Utilizing advanced analytics techniques

    • Driving strategic decision-making

    • Continuously learning and staying updated with the latest trends in data analysis

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic aptitude and math skills are the key to success in the field of psychology and psychology in the field and in the field in

Interview questions from similar companies

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

I applied via Recruitment Consulltant and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain recent project
  • Ans. 

    Developed a predictive model for customer churn in a telecom company

    • Collected and cleaned customer data from various sources

    • Performed exploratory data analysis to identify patterns and trends

    • Built a machine learning model using logistic regression to predict customer churn

    • Evaluated the model's performance using metrics such as accuracy, precision, and recall

  • Answered by AI
  • Q2. Cloud technologies used
  • Ans. 

    Various cloud technologies like AWS, Azure, and Google Cloud are commonly used for data analysis.

    • AWS (Amazon Web Services)

    • Azure (Microsoft Azure)

    • Google Cloud Platform

  • Answered by AI
Round 2 - Group Discussion 

Performance based questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed before Nov 2023. There were 5 interview rounds.

Round 1 - Coding Test 

2 coding questions in 45 min

Round 2 - Technical 

(2 Questions)

  • Q1. Basics of java and frameworks
  • Q2. Basics of SQL and types of queries
Round 3 - Aptitude Test 

30 min of logical reasoning and basic aptitude

Round 4 - Group Discussion 

30 min of GD over a general topic to check your communication skills

Round 5 - HR 

(2 Questions)

  • Q1. Why do you want to join our company
  • Q2. Why should we hire you

Affine Interview FAQs

How many rounds are there in Affine Data Analyst interview?
Affine interview process usually has 1-2 rounds. The most common rounds in the Affine interview process are Technical, Coding Test and One-on-one Round.
How to prepare for Affine Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Affine. The most common topics and skills that interviewers at Affine expect are SQL, Power Bi, Data Analytics, Data Analysis and Excel.
What are the top questions asked in Affine Data Analyst interview?

Some of the top questions asked at the Affine Data Analyst interview -

  1. What is the difference between Tree Map and Heatmap in Table...read more
  2. What is the difference between 'Extract Data' and 'Live Connection' in Table...read more
  3. What is the order of execution of an SQL que...read more

Tell us how to improve this page.

Affine Data Analyst Interview Process

based on 7 interviews in last 1 year

1 Interview rounds

  • Technical Round
View more

People are getting interviews through

based on 3 Affine interviews
Job Portal
Referral
67%
33%
Moderate Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Join Affine Command The New
Affine Data Analyst Salary
based on 7 salaries
₹7 L/yr - ₹19 L/yr
87% more than the average Data Analyst Salary in India
View more details
Senior Associate
126 salaries
unlock blur

₹7.7 L/yr - ₹20 L/yr

Business Analyst
107 salaries
unlock blur

₹5 L/yr - ₹12.6 L/yr

Senior Business Analyst
89 salaries
unlock blur

₹8 L/yr - ₹16.3 L/yr

Consultant
84 salaries
unlock blur

₹12 L/yr - ₹32 L/yr

Data Engineer
47 salaries
unlock blur

₹6 L/yr - ₹15 L/yr

Explore more salaries
Compare Affine with

Fractal Analytics

4.0
Compare

Mu Sigma

2.7
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview