AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
The Smart Cube Data Analyst Interview Questions and Answers
The Smart Cube Data Analyst Interview Experiences
5 interviews found
Anonymous
Selected
I applied via Campus Placement
Basic English, Quants and Statistics
Easy, relevant to pandemic
(1 Question)
- Q1. Python, Tableau, SQL, Stats, ML, all questions easy to medium level
(2 Questions)
- Q1. Behavioural Questions
- Q2. Statistics Case Study
Interview Preparation Tips
General Quant, DA questions like ratio, numbers etc
(2 Questions)
- Q1. What is the difference between extend and append in Python?
- Ans.
Extend adds elements of an iterable to a list, while append adds a single element to the end of a list.
Extend can add multiple elements from an iterable (list, tuple, string) to the end of a list.
Append adds a single element to the end of a list.
Extend modifies the original list, while append does not.
Example: list1 = [1, 2, 3], list2 = [4, 5], list1.extend(list2) will result in list1 = [1, 2, 3, 4, 5], list1.append(6)
- Q2. How can you join 2 dataframes one after the other in Python?
- Ans.
You can join 2 dataframes one after the other in Python using the concat() function from the pandas library.
Use pd.concat() function from the pandas library to join two dataframes one after the other.
Specify the dataframes to be concatenated as arguments to the concat() function.
Make sure the columns of both dataframes match or use the ignore_index parameter to reset the index after concatenation.
Interview Preparation Tips
Skills evaluated in this interview
Gst in india with + and -
(1 Question)
- Q1. Asked about case study
(1 Question)
- Q1. Asked some puzzles
Selected
I applied via Campus Placement and was interviewed before May 2023. There were 3 interview rounds.
Grammar and reasoning questions
Just a minute session. To check English fluency.
(1 Question)
- Q1. Resume based questions. Revolved around statistics, linear and logistics regression
The Smart Cube interview questions for designations
(1 Question)
- Q1. Normal Distribution, Time Series, Linear and Logistic Regression
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. What projects are you working on?
- Q2. Tell me about a time you struggled.
(1 Question)
- Q1. Hard DP level DSA question
Selected
(1 Question)
- Q1. How good are you with numbers
(1 Question)
- Q1. Vlookup, pivot table, sumif, average, graphs
(1 Question)
- Q1. Do you know the role and responsibility of this position
(2 Questions)
- Q1. Power BI Difference between ALL() and ALLSELECTED()
- Ans.
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
ALL() removes all filters from the specified column or table.
ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.
Example: ALL('Table') would remove all filters on the 'Table' in the query context.
Example: ALLSELECTED('Column') would remove filte...
- Q2. Excel Difference between COUNT() and COUNTA()
- Ans.
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
COUNT() counts only cells with numerical values.
COUNTA() counts all non-empty cells, including text and errors.
Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
(2 Questions)
- Q1. Resume based questions like explain the projects that you have done.
- Q2. Sample dataset questions
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
Basic quant questions with some questions on ML. 2 python questions based on data processing.
(2 Questions)
- Q1. Difference between list and set
- Ans.
List is an ordered collection of elements with duplicates allowed, while set is an unordered collection of unique elements.
List maintains the order of elements, while set does not guarantee any specific order.
List allows duplicate elements, while set does not allow duplicates.
List is accessed by index, while set is accessed by value.
Example: List - [1, 2, 3, 1], Set - {1, 2, 3}
- Q2. Difference between concat and merge
- Ans.
Concat is used to combine data along a particular axis, while merge is used to combine data based on a common key.
Concatenation is done along an axis (rows or columns) in pandas, while merging is done based on common columns or indices.
Concatenation is a simple operation that just appends data, while merging involves combining data based on a key.
Concatenation can be done even if the data does not have common columns, ...
Skills evaluated in this interview
The Smart Cube Interview FAQs
Tell us how to improve this page.
The Smart Cube Interviews By Designations
- The Smart Cube Senior Analyst Interview Questions
- The Smart Cube Data Analyst Interview Questions
- The Smart Cube Research Analyst Interview Questions
- The Smart Cube Analyst Interview Questions
- The Smart Cube Data Engineer Interview Questions
- The Smart Cube Manager Interview Questions
- The Smart Cube Assistant Manager Interview Questions
- The Smart Cube Senior Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
The Smart Cube Data Analyst Interview Process
based on 4 interviews
1 Interview rounds
- Aptitude Test Round
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
The Smart Cube Data Analyst Reviews and Ratings
based on 9 reviews
Rating in categories
|
Senior Analyst
282
salaries
|  ₹6 L/yr - ₹17 L/yr |
|
Assistant Manager
198
salaries
| ₹10 L/yr - ₹24 L/yr |
|
Analyst
109
salaries
| ₹5.3 L/yr - ₹11.2 L/yr |
|
Research Analyst
97
salaries
| ₹5.5 L/yr - ₹9 L/yr |
|
Manager
93
salaries
| ₹13 L/yr - ₹34 L/yr |
Mercer
Willis Towers Watson
WSP
McKinsey & Company
- Home >
- Interviews >
- The Smart Cube Interview Questions >
- The Smart Cube Data Analyst Interview Questions
