Upload Button Icon Add office photos

The Smart Cube

Compare button icon Compare button icon Compare

Filter interviews by

The Smart Cube Senior Data Analyst Interview Questions and Answers

Updated 18 Jul 2023

The Smart Cube Senior Data Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 

Basic Mathematics, Statistics questions

Round 3 - Group Discussion 

Share thoughts on one topic for in 1 minute

Round 4 - One-on-one 

(2 Questions)

  • Q1. This is the technical round
  • Q2. 1. Regression analysis 2. R2 , adj R2 3. Statistics 4. Machine Learning
Round 5 - One-on-one 

(1 Question)

  • Q1. Basic Aptitude, quizzes, case study

Interview questions from similar companies

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

I applied via Newspaper Ad and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Round 2 - Technical 

(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...

  • Answered by AI
  • Q2. Written a SQL query
Round 3 - HR 

(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

  • Answered by AI

Skills evaluated in this interview

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

(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...

  • Answered by AI
  • 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.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Resume based questions like explain the projects that you have done.
  • Q2. Sample dataset questions

Skills evaluated in this interview

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

I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Basics of power bi and sql
  • Q2. What are joins and types of join
  • Q3. How to add date table in power bi
Round 2 - Technical 

(4 Questions)

  • Q1. Sql scenario based question on joins
  • Q2. Window function questions
  • Q3. Performance tuning
  • Q4. Power bi dax question
Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. How good are you with numbers
Round 2 - Technical 

(1 Question)

  • Q1. Vlookup, pivot table, sumif, average, graphs
Round 3 - Behavioral 

(1 Question)

  • Q1. Do you know the role and responsibility of this position
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions liek tiem distance, percentage , ratio, work and hour

Round 2 - Coding Test 

Excel, Numpy, Pandas, basic ML

Round 3 - Case Study 

Case study talking about how to optimise the supply chain using data analytics

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Hard DP level DSA question
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What is the number of tourist per day in jaipur
  • Ans. 

    The number of tourists per day in Jaipur varies depending on the season and events happening in the city.

    • Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

    • Events like festivals or cultural events can attract more tourists

    • Historical sites like Amer Fort and Hawa Mahal are popular attractions

    • Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Almost everything on Power BI
Round 2 - One-on-one 

(1 Question)

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

I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Difference between mutual and hedge funds
  • Ans. 

    Mutual funds pool money from multiple investors to invest in a diversified portfolio, while hedge funds are more exclusive and use more aggressive strategies.

    • Mutual funds are open to all investors, while hedge funds are typically only available to accredited investors.

    • Mutual funds are regulated by the SEC, while hedge funds have more flexibility in their investment strategies.

    • Mutual funds are more diversified and have ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just know whatever is written in you resume and be prepared with all the basic financial knowledge

The Smart Cube Interview FAQs

How many rounds are there in The Smart Cube Senior Data Analyst interview?
The Smart Cube interview process usually has 5 rounds. The most common rounds in the The Smart Cube interview process are One-on-one Round, Resume Shortlist and Aptitude Test.
What are the top questions asked in The Smart Cube Senior Data Analyst interview?

Some of the top questions asked at the The Smart Cube Senior Data Analyst interview -

  1. 1. Regression analysis 2. R2 , adj R2 3. Statistics 4. Machine Learn...read more
  2. Basic Aptitude, quizzes, case st...read more
  3. This is the technical ro...read more

Tell us how to improve this page.

The Smart Cube Senior Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.6
 • 221 Interviews
Fractal Analytics Interview Questions
4.0
 • 207 Interviews
BCG Interview Questions
3.7
 • 196 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
Bain & Company Interview Questions
3.8
 • 103 Interviews
Blackrock Interview Questions
3.8
 • 100 Interviews
WSP Interview Questions
4.2
 • 89 Interviews
Mercer Interview Questions
3.7
 • 80 Interviews
View all
The Smart Cube Senior Data Analyst Salary
based on 81 salaries
₹8 L/yr - ₹15.5 L/yr
5% more than the average Senior Data Analyst Salary in India
View more details

The Smart Cube Senior Data Analyst Reviews and Ratings

based on 4 reviews

3.8/5

Rating in categories

3.2

Skill development

4.2

Work-life balance

4.3

Salary

3.6

Job security

4.5

Company culture

3.8

Promotions

2.7

Work satisfaction

Explore 4 Reviews and Ratings
Senior Analyst
280 salaries
unlock blur

₹6.5 L/yr - ₹16 L/yr

Assistant Manager
217 salaries
unlock blur

₹10 L/yr - ₹25.6 L/yr

Analyst
108 salaries
unlock blur

₹5.3 L/yr - ₹11.3 L/yr

Manager
93 salaries
unlock blur

₹13 L/yr - ₹32 L/yr

Research Analyst
86 salaries
unlock blur

₹5.5 L/yr - ₹8.2 L/yr

Explore more salaries
Compare The Smart Cube with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

AbsolutData

3.6
Compare

LatentView Analytics

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