Upload Button Icon Add office photos
Engaged Employer

i

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

Novel Office Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Novel Office Data Analyst Interview Questions, Process, and Tips

Updated 13 Feb 2025

Top Novel Office Data Analyst Interview Questions and Answers

Novel Office Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 13 Feb 2025

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

(4 Questions)

  • Q1. What is the difference between the DELETE and DROP commands in SQL?
  • Ans. 

    DELETE is used to remove rows from a table, while DROP is used to remove entire tables from a database.

    • DELETE is a DML command used to remove specific rows from a table based on a condition.

    • DROP is a DDL command used to remove entire tables, views, or databases from a database.

    • DELETE does not remove the table structure, only the data within it.

    • DROP removes the table structure along with all its data, and it cannot be r...

  • Answered by AI
  • Q2. What is the concept of a Primary Key in SQL?
  • Ans. 

    Primary Key in SQL is a unique identifier for each record in a table.

    • Primary Key ensures each record in a table is unique

    • It can consist of one or multiple columns

    • Primary Key values cannot be NULL

    • Example: 'id' column in a 'users' table

  • Answered by AI
  • Q3. What is the difference between UNION and UNION ALL in SQL?
  • Ans. 

    UNION combines and removes duplicates, UNION ALL combines without removing duplicates.

    • UNION merges the result sets of two or more SELECT statements, removing duplicates.

    • UNION ALL merges the result sets of two or more SELECT statements, including duplicates.

    • UNION is slower than UNION ALL as it involves removing duplicates.

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FROM t

  • Answered by AI
  • Q4. What is the LIKE operator, and how is it used in SQL?
  • Ans. 

    The LIKE operator is used in SQL to search for a specified pattern in a column.

    • The LIKE operator is used with the WHERE clause to search for a specified pattern in a column.

    • It allows for the use of wildcards such as % (matches any sequence of characters) and _ (matches any single character).

    • For example, 'SELECT * FROM table_name WHERE column_name LIKE 'a%'' will return all rows where the column starts with 'a'.

  • Answered by AI

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 15 Mar 2023

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

I applied via Referral and was interviewed in Feb 2023. There were 4 interview rounds.

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 Resume tips
Round 2 - Aptitude Test 

1st round consists of IQ test followed by logical Reasoning Test if you clear you would be qualified for other rounds

Round 3 - HR 

(2 Questions)

  • Q1. Basic Hr questions related to position applied. about the company and work culture
  • Q2. Tell me about Yourself family background
Round 4 - Technical 

(1 Question)

  • Q1. Regarding your past experience & project which you have done in your previous company.SQL and basic excel,Python questions were also asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well IQ test will be easy round you need to score more than 100 points.
Logical reasoning round is quite difficulty and Tricky. Practice well

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 Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

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

I was interviewed in Dec 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. What is your long time goal?
  • Q2. What is your short time goal?
  • Ans. 

    My short term goal is to enhance my data analysis skills through continuous learning and practical application.

    • Enroll in online courses or workshops to learn new data analysis techniques

    • Seek opportunities to work on real-world data analysis projects

    • Attend data analysis conferences or networking events to stay updated on industry trends

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Enjoy the job and enjoy the work process
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before May 2023. There was 1 interview round.

Round 1 - HR 

(1 Question)

  • Q1. Tell about yourself
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Basic of sql and excel
  • Q2. What is joins and types oj joins
  • Ans. 

    Joins are used in databases 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 t...

  • Answered by AI
Round 3 - Aptitude Test 

Manager round general questions about joining

Skills evaluated in this interview

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

I applied via Instahyre and was interviewed before Jan 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Some basic sql questions

Round 2 - Technical 

(1 Question)

  • Q1. How many spheres can be accomadated in a bus if dimensions provided?
  • Ans. 

    The number of spheres that can be accommodated in a bus depends on the dimensions of the bus and the size of the spheres.

    • Calculate the volume of the bus using its dimensions

    • Calculate the volume of a sphere using its radius

    • Divide the volume of the bus by the volume of a sphere to get the maximum number of spheres that can fit

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - BE Direct with your answers

Interview Questionnaire 

1 Question

  • Q1. About some physics & maths & all generally

Interview Preparation Tips

Interview preparation tips for other job seekers - Actually my hiring in omaxe is as trainee & student..I have cleared written exam & general discussion..maximum were technically
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2023. There were 3 interview rounds.

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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Diffirence between project and project engineering
  • Ans. 

    Project refers to a specific task with a defined start and end, while project engineering involves the technical aspects of planning, designing, and executing the project.

    • Project is the overall task or objective to be completed within a specific timeframe.

    • Project engineering focuses on the technical aspects such as planning, designing, and executing the project.

    • Project management involves coordinating resources and tas...

  • Answered by AI
  • Q2. Types of services in interior fitout
  • Ans. 

    Types of services in interior fitout include design, construction, project management, and installation.

    • Design services involve creating layouts, selecting materials, and creating 3D visualizations.

    • Construction services include building partitions, ceilings, and flooring.

    • Project management services involve coordinating schedules, budgets, and contractors.

    • Installation services include fitting furniture, fixtures, and eq...

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. Problems faced in site
  • Ans. 

    Some common problems faced on site include delays in material delivery, inclement weather, and coordination issues.

    • Delays in material delivery can impact project timelines and budgets

    • Inclement weather can halt work progress and cause safety concerns

    • Coordination issues between different teams can lead to misunderstandings and errors

  • Answered by AI
  • Q2. Difference between agreement and bond
  • Ans. 

    Agreement is a mutual understanding between parties, while a bond is a legal document that ensures fulfillment of obligations.

    • Agreement is a mutual understanding between two or more parties.

    • A bond is a legal document that guarantees the fulfillment of obligations.

    • Agreements are usually informal and may not always be legally binding.

    • Bonds are formal and legally enforceable documents.

    • Examples of agreements include contra...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. TDS sections with limitations
  • Ans. 

    TDS sections with limitations refer to the various sections of the Income Tax Act that specify the maximum amount of tax that can be deducted at source.

    • TDS section 192 limits the deduction of tax at source on salary income

    • TDS section 194 limits the deduction of tax at source on interest income

    • TDS section 194A limits the deduction of tax at source on interest other than interest on securities

  • Answered by AI
  • Q2. GST compliances Basic

Interview Preparation Tips

Topics to prepare for 91springboard Executive Accountant interview:
  • TDS
  • Indirect Taxation
  • Invoice Verification
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
More than 8 weeks
Result
No response

I applied via Approached by Company and was interviewed in May 2024. There were 4 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me About Yourself
  • Ans. 

    Experienced executive accountant with a strong track record in financial management and strategic planning.

    • Over 10 years of experience in accounting and finance

    • Expertise in budgeting, forecasting, and financial analysis

    • Proven ability to streamline processes and improve efficiency

    • Strong communication and leadership skills

    • Previously managed a team of accountants at XYZ Corporation

  • Answered by AI
  • Q2. Tell us About your experience
Round 2 - Technical 

(1 Question)

  • Q1. GST,TDS and Journal Entries questions
Round 3 - HR 

(2 Questions)

  • Q1. Tell us about yourself
  • Q2. Tell us about your experiance
Round 4 - HR 

(4 Questions)

  • Q1. Tell us about Yourself
  • Q2. Tell Us about your company
  • Q3. Tell us about your role & responsibility
  • Q4. What do you know about the company

Interview Preparation Tips

Interview preparation tips for other job seekers - Dear all, If you are applying the job in this organization then please be aware because they are scammers they only wasting your time. I have done 3 rounds but when i give 4th round the HR Head said we are looking Account Receivable.Look they don't know which position they are hiring they just wasting your time.
Contribute & help others!
anonymous
You can choose to be anonymous

Novel Office Interview FAQs

How many rounds are there in Novel Office Data Analyst interview?
Novel Office interview process usually has 2-3 rounds. The most common rounds in the Novel Office interview process are Technical, Resume Shortlist and Aptitude Test.
How to prepare for Novel Office 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 Novel Office. The most common topics and skills that interviewers at Novel Office expect are Data Analysis, Python, SQL, Communication Skills and Analytical Skills.
What are the top questions asked in Novel Office Data Analyst interview?

Some of the top questions asked at the Novel Office Data Analyst interview -

  1. What is the difference between the DELETE and DROP commands in S...read more
  2. What is the difference between UNION and UNION ALL in S...read more
  3. What is the LIKE operator, and how is it used in S...read more

Recently Viewed

SALARIES

Softenger

SALARIES

Zensar Technologies

SALARIES

Deep Auto Electricals

SALARIES

Deep Auto Electricals

LIST OF COMPANIES

Deep Auto Electricals

Overview

SALARIES

Diffusion Engineers

SALARIES

Softenger

SALARIES

Diffusion Engineers

SALARIES

Grepix Infotech

LIST OF COMPANIES

Zensar Technologies

Overview

Tell us how to improve this page.

Novel Office Data Analyst Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more

Interview Questions from Similar Companies

Omaxe Interview Questions
4.1
 • 35 Interviews
Smartworks Interview Questions
3.5
 • 31 Interviews
DRA Homes Interview Questions
4.6
 • 23 Interviews
Runwal Group Interview Questions
3.8
 • 20 Interviews
JP Infra Interview Questions
3.8
 • 19 Interviews
N.K. Realtors Interview Questions
4.2
 • 19 Interviews
DTC Projects Interview Questions
4.1
 • 17 Interviews
PS Group Interview Questions
3.7
 • 16 Interviews
View all
Novel Office Data Analyst Salary
based on 36 salaries
₹2.1 L/yr - ₹5.5 L/yr
41% less than the average Data Analyst Salary in India
View more details

Novel Office Data Analyst Reviews and Ratings

based on 11 reviews

4.3/5

Rating in categories

4.1

Skill development

3.6

Work-life balance

3.0

Salary

3.3

Job security

4.2

Company culture

3.5

Promotions

4.1

Work satisfaction

Explore 11 Reviews and Ratings
Data Analyst
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Manager
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Project Engineer
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

HR Executive
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Novel Office with

Regus

2.9
Compare

WeWork India Management

4.3
Compare

Smartworks

3.5
Compare

Awfis

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