Upload Button Icon Add office photos

Filter interviews by

Clear (1)

ANAROCK Property Consultants Data Analyst Intern Interview Questions, Process, and Tips

Updated 7 Jan 2025

ANAROCK Property Consultants Data Analyst Intern Interview Experiences

1 interview found

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

I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - One-on-one 

(7 Questions)

  • Q1. What do you mean by MTD ? How to create it
  • Ans. 

    MTD stands for Month-to-Date. It refers to the period from the beginning of the current month up to the present date.

    • MTD is a common term used in financial and business reporting to track performance within a specific month.

    • To create MTD, you would sum up the data from the beginning of the month up to the current date.

    • For example, if you are calculating MTD sales for January 2022 on January 15th, you would sum up all s...

  • Answered by AI
  • Q2. Diffrence between Calculated column and Measure?
  • Ans. 

    Calculated columns are static values calculated at the row level, while measures are dynamic values calculated at the aggregated level.

    • Calculated columns are computed for each row in a table, while measures are computed for the entire dataset or a subset of data.

    • Calculated columns are stored in the data model, while measures are calculated on the fly based on user interactions.

    • Examples of calculated columns include age...

  • Answered by AI
  • Q3. What is Data Modelling? Types of Data Models
  • Ans. 

    Data modeling is the process of creating a visual representation of data structures and relationships.

    • Data modeling involves defining the structure of data, its storage, and how it will be accessed and manipulated.

    • Types of data models include conceptual, logical, and physical models.

    • Conceptual models focus on high-level business concepts and relationships.

    • Logical models define the structure of the data without consider...

  • Answered by AI
  • Q4. Questions were asked regarding my project, specifically related to the chosen metrics as KPIs and your motivation behind the project?
  • Q5. RLS in power bi
  • Ans. 

    RLS in Power BI stands for Row-Level Security, a feature that restricts data access based on user roles.

    • RLS allows you to control access to data at the row level based on user roles

    • You can define filters in Power BI to restrict data based on user roles

    • RLS is commonly used to ensure that users only see data relevant to their role or department

  • Answered by AI
  • Q6. What are joins? Types of joins.
  • 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 ...

  • Answered by AI
  • Q7. Write query to find department wise highest salary in an organisation.
  • Ans. 

    Query to find department wise highest salary in an organisation

    • Use GROUP BY clause to group data by department

    • Use MAX() function to find highest salary in each department

    • Join the tables if necessary to get department information

  • Answered by AI

Interview Preparation Tips

Topics to prepare for ANAROCK Property Consultants Data Analyst Intern interview:
  • Power Bi
  • SQL
  • Advanced Excel
Interview preparation tips for other job seekers - Prepare Power BI Interview questions available through linkedin, internet and Youtube(can refer yt chaneel of learnwithgigs).
For SQL practise as much you can.

Interview questions from similar companies

Manager Interview Questions & Answers

JLL user image Anonymous

posted on 6 Oct 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 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 - HR 

(1 Question)

  • Q1. Tell me something about yourself
Round 3 - Aptitude Test 

Technical question answers

Round 4 - One-on-one 

(1 Question)

  • Q1. Technical question

I applied via Referral and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were based on technical, behavioural and situational management.

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Be calm and composed.
2. Practice good nonverbal communication
3. Listen actively and don't talk too much.
4. Use appropriate language and don't be too cocky.
5. Take care to answer your questions and work on your answers.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. About projects in previous company

Manager Interview Questions & Answers

CBRE user image Anonymous

posted on 25 Nov 2021

I applied via Referral and was interviewed before Nov 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. About yourself and questions relevant to your profile..
  • Q2. Thoroughly explore your current work in detail because your questions will be based on your current work mostly

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in your response and listen to interviewer carefully so you will not ask the question to be repeated..
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Walk-in and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Assignment 

Online assessment around 30-50mins

Round 2 - HR 

(1 Question)

  • Q1. Interview screening
Round 3 - Technical 

(1 Question)

  • Q1. Client via involved via web meet
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Situational Questions
  • Q2. Do you have any experience in real estate

Analyst Interview Questions & Answers

JLL user image Anonymous

posted on 1 Jan 2022

I applied via LinkedIn and was interviewed in Dec 2021. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Technical and psychological
  • Q2. Cad related and basic interview questions
  • Q3. Where do your see your self in 5 years etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident about their company and job role. Make them know why this job is important for you and how you see good career growth in this.

Analyst Interview Questions & Answers

JLL user image Anonymous

posted on 20 Jan 2022

I applied via Referral and was interviewed before Jan 2021. 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 

I have given aptitude test which has 30 questions

Round 3 - One-on-one 

(1 Question)

  • Q1. Basics of accounting, communication,your joining time.
Round 4 - HR 

(3 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Why are you looking for a change?

Interview Preparation Tips

Topics to prepare for JLL Analyst interview:
  • B.com
Interview preparation tips for other job seekers - Now days If you have any references in the company,so there is more possibility

Analyst Interview Questions & Answers

JLL user image Anonymous

posted on 6 Nov 2022

I applied via Referral and was interviewed in May 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - Case Study 

Regarding the lease agreement. Basic questions regarding that. English test was also there

Round 3 - Interview 

(3 Questions)

  • Q1. What are your academic qualifications What your family members do how can you contribute
  • Q2. What your family members do
  • Q3. How can you contribute in the company

Interview Preparation Tips

Interview preparation tips for other job seekers - Know the job you are applying for. Carefully speak
Contribute & help others!
anonymous
You can choose to be anonymous

ANAROCK Property Consultants Interview FAQs

How many rounds are there in ANAROCK Property Consultants Data Analyst Intern interview?
ANAROCK Property Consultants interview process usually has 1 rounds. The most common rounds in the ANAROCK Property Consultants interview process are One-on-one Round.
How to prepare for ANAROCK Property Consultants Data Analyst Intern 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 ANAROCK Property Consultants. The most common topics and skills that interviewers at ANAROCK Property Consultants expect are Data Analysis, Analytical Chemistry, Analytical Skills, Auditing and Clinical Data Management.
What are the top questions asked in ANAROCK Property Consultants Data Analyst Intern interview?

Some of the top questions asked at the ANAROCK Property Consultants Data Analyst Intern interview -

  1. What do you mean by MTD ? How to create...read more
  2. What is Data Modelling? Types of Data Mod...read more
  3. Write query to find department wise highest salary in an organisati...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

National Stock Exchange of India

No Interviews

INTERVIEWS

Dalmia Bharat Cement

No Interviews

INTERVIEWS

National Stock Exchange of India

No Interviews

INTERVIEWS

National Stock Exchange of India

No Interviews

INTERVIEWS

Pranav Vikas India Private Limited

No Interviews

INTERVIEWS

Broadridge Financial Solutions

No Interviews

INTERVIEWS

Dalmia Bharat Cement

No Interviews

INTERVIEWS

Dalmia Bharat Cement

No Interviews

Tell us how to improve this page.

ANAROCK Property Consultants Data Analyst Intern Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

JLL Interview Questions
4.1
 • 351 Interviews
CBRE Interview Questions
4.2
 • 264 Interviews
NoBroker Interview Questions
3.1
 • 232 Interviews
Square Yards Interview Questions
4.0
 • 198 Interviews
Sobha Interview Questions
3.9
 • 127 Interviews
Lodha Group Interview Questions
4.0
 • 125 Interviews
DLF Interview Questions
3.9
 • 74 Interviews
View all
Assistant Manager
251 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
241 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Manager
118 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
107 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Associate
77 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ANAROCK Property Consultants with

JLL

4.1
Compare

CBRE

4.2
Compare

Knight Frank

4.0
Compare

Colliers India

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent