AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Affine
Work with us 
Compare
Filter interviews by
Affine Data Analyst Interview Questions and Answers
9 Interview questions
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 ta...
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
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
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 improv...
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 effec...
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 eng...
Affine HR Interview Questions
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.
...
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 re...
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
Affine Data Analyst Interview Experiences
8 interviews found
Anonymous
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(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
- Q2. What are Joins in SQL, explain different joins and their outputs
- Q3. Query to give running sum of salary
Interview Preparation Tips
Skills evaluated in this interview
I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.
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.
(1 Question)
- Q1. Simple questions on SQL were asked.
(5 Questions)
- Q1. What is pivot table in Excel?
- 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 ...
- 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...
- 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 ...
- 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...
Interview Preparation Tips
- SQL
- Power Bi
- Tableau
- Excel
Skills evaluated in this interview
(1 Question)
- Q1. SQL and excel questions intermediate
I appeared for an interview in Jun 2024.
Easy SQL questions related to sub query
SQL moderate questions related to joins and window functions
(1 Question)
- Q1. Asked about specific tools related to requirement
Interview Preparation Tips
Vikranth Ravikanthi
(1 Question)
- Q1. SQL Questions on Aggregations
Sai Shreyas B.K
I appeared for an interview in Aug 2024.
The sql questions were hard
Naresh R
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Difference between Primary Key and Unique Key ?
Basic aptitude questions, statics, probability etc
(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 ...
- Q2. Where do you see yourself in 5 years
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. Situation based question on experience
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Nov 2023. There were 5 interview rounds.
2 coding questions in 45 min
(2 Questions)
- Q1. Basics of java and frameworks
- Q2. Basics of SQL and types of queries
30 min of logical reasoning and basic aptitude
30 min of GD over a general topic to check your communication skills
(2 Questions)
- Q1. Why do you want to join our company
- Ans.
I admire your company's commitment to data-driven decision-making and innovative solutions in the industry.
Your company's reputation for leveraging data analytics to improve patient outcomes aligns with my passion for impactful work.
I am impressed by your recent project on predictive analytics, which showcases your commitment to innovation.
The collaborative culture at your company excites me, as I thrive in environment...
- Q2. Why should we hire you
- Ans.
I bring strong analytical skills, relevant experience, and a passion for data-driven decision-making to your team.
Proven experience in data analysis with tools like SQL and Python, demonstrated by a project where I improved reporting efficiency by 30%.
Strong problem-solving skills, as shown when I identified key trends in customer data that led to a 15% increase in sales.
Excellent communication skills, enabling me to p...
Affine Interview FAQs
Tell us how to improve this page.
Affine Interviews By Designations
- Affine Data Analyst Interview Questions
- Affine Business Analyst Interview Questions
- Affine Data Scientist Interview Questions
- Affine Senior Associate Interview Questions
- Affine Data Engineer Interview Questions
- Affine Consultant Interview Questions
- Affine Senior Data Scientist Interview Questions
- Affine Power BI Developer Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 10 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
|
Senior Associate
139
salaries
|  ₹10 L/yr - ₹18.3 L/yr |
|
Business Analyst
104
salaries
| ₹5.8 L/yr - ₹12.6 L/yr |
|
Consultant
91
salaries
| ₹17.3 L/yr - ₹31.4 L/yr |
|
Senior Business Analyst
88
salaries
| ₹10 L/yr - ₹18 L/yr |
|
Data Engineer
48
salaries
| ₹8 L/yr - ₹13 L/yr |
HCL Infosystems
Tekwissen
Softenger
Capital Numbers Infotech
- Home >
- Interviews >
- Affine Interview Questions
