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
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
Selected
I applied via campus placement at Lady Shri Ram College for Women, Delhi
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
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
tejas jain
I applied via Newspaper Ad and was interviewed in Aug 2024. There were 3 interview rounds.
Three sections are there 1) Aptitude Test 2) SQL 3) DSA
(2 Questions)
- Q1. What is DSA , sorting , difference between array and linked list
- Ans.
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
DSA stands for Data Structures and Algorithms
Sorting is the process of arranging data in a particular order
Arra...
- Q2. Written a SQL query
(2 Questions)
- Q1. Coding question like add numbers
- Q2. Experience on your project
- Ans.
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
Developed predictive models to forecast customer behavior and optimize marketing strategies
Conducted market research to identify trends and opportunities for growth
Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Skills evaluated in this interview
(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 Indeed and was interviewed in Jan 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Basics of power bi and sql
- Q2. What are joins and types of join
- Ans.
Joins 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
FULL JOIN...
- Q3. How to add date table in power bi
- Ans.
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
Create a new table in Power BI with a list of dates
Add columns for day, month, year, etc. for additional analysis
Establish relationships between the date table and other tables in the data model
(4 Questions)
- Q1. Sql scenario based question on joins
- Q2. Window function questions
- Q3. Performance tuning
- Q4. Power bi dax question
Skills evaluated in this interview
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
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.
Basic aptitude questions liek tiem distance, percentage , ratio, work and hour
Excel, Numpy, Pandas, basic ML
Case study talking about how to optimise the supply chain using data analytics
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 Assistant Manager Interview Questions
- The Smart Cube Intern Interview Questions
- The Smart Cube Manager 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
283
salaries
|  ₹6 L/yr - ₹16 L/yr |
|
Assistant Manager
216
salaries
| ₹10 L/yr - ₹25.6 L/yr |
|
Analyst
108
salaries
| ₹5.3 L/yr - ₹11.3 L/yr |
|
Manager
93
salaries
| ₹13 L/yr - ₹34 L/yr |
|
Research Analyst
86
salaries
| ₹5.5 L/yr - ₹8.2 L/yr |
Fractal Analytics
Mu Sigma
AbsolutData
LatentView Analytics
- Home >
- Interviews >
- The Smart Cube Interview Questions >
- The Smart Cube Data Analyst Interview Questions
