AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
ANAROCK Property Consultants Data Analyst Intern Interview Questions and Answers
ANAROCK Property Consultants Data Analyst Intern Interview Experiences
1 interview found
Aditya_ MNNIT
I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.
(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...
- 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...
- 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...
- 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
- 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 ...
- 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
Interview Preparation Tips
- Power Bi
- SQL
- Advanced Excel
For SQL practise as much you can.
Top trending discussions
Interview questions from similar companies
Manager Interview Questions & Answers
Cushman & Wakefield
Shailendra Pratap Sahoo
posted on 8 Mar 2021
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
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.
Anonymous
I applied via LinkedIn and was interviewed before Jul 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. About previous Company experience
Interview Preparation Tips
I applied via Approached by Company and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. Basic details, Current profile, Current and expected CTC
(2 Questions)
- Q1. Current Profile, Roles and Responsibility
- Q2. Construction Methodology, Planning and scheduling
(1 Question)
- Q1. CTC Negotiations and further discussion with respect to Notice period, joining date.
Interview Preparation Tips
Manager Interview Questions & Answers
Aparna Constructions and Estates
purna prasad
posted on 16 Dec 2023
Selected
I applied via Referral and was interviewed in Nov 2023. There were 5 interview rounds.
(2 Questions)
- Q1. Based on experience
- Q2. Mep related questions
(1 Question)
- Q1. Family background and assets
(2 Questions)
- Q1. Based on experience
- Q2. Mep related questions
(1 Question)
- Q1. Cost analysis and rate
(1 Question)
- Q1. About projects in previous company
Vivek Sharma
Data science based case study
During interview ask senario
(2 Questions)
- Q1. General questions
- Q2. About past experience
I applied via Referral and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. Cad test revit test sketchup test
(1 Question)
- Q1. Why sobha....................................
- Ans.
Sobha is a leading real estate developer in India known for its quality construction and customer-centric approach.
Sobha has completed over 100 real estate projects across India
The company has won numerous awards for its quality construction and customer service
Sobha is committed to sustainable development and has implemented green initiatives in its projects
The company has a strong focus on customer satisfaction and h...
(1 Question)
- Q1. Meeting chairman...........................
Interview Preparation Tips
Utkarsh Verma
Selected
I appeared for an interview before Feb 2024, where I was asked the following questions.
- Q1. What has been your experience in real estate, and what markets and property ticket sizes have you managed?
- Ans.
I have extensive experience in real estate, managing diverse markets and property sizes, from residential to commercial.
Market Experience: Managed properties in urban markets like New York and suburban areas, adapting strategies to local demands.
Property Types: Oversaw residential, commercial, and mixed-use developments, ensuring compliance with regulations and market trends.
Ticket Sizes: Handled transactions ranging f...
- Q2. How effective are your relationship-building skills with channel partners, particularly with the top channel partners you have collaborated with?
- Ans.
I excel in building strong relationships with channel partners, focusing on collaboration, trust, and mutual growth.
Open Communication: I prioritize transparent communication, ensuring that channel partners feel heard and valued. For example, I hold regular check-ins to discuss goals and challenges.
Tailored Support: I adapt my approach to meet the unique needs of each top channel partner. For instance, I developed a cu...
Selected
I appeared for an interview in Jan 2025.
(2 Questions)
- Q1. Explain work procedure in details.
- Ans.
Work procedure involves detailed steps to complete a task efficiently and effectively.
Identify the task to be completed
Break down the task into smaller steps
Assign responsibilities to team members
Set deadlines for each step
Monitor progress and make adjustments as needed
- Q2. Explain Waterproofing methodology & gypsum starting process
- Ans.
Waterproofing methodology involves applying materials to prevent water penetration, while gypsum starting process involves mixing gypsum with water to create a paste.
Waterproofing methodology includes surface preparation, application of waterproofing materials like membranes or coatings, and proper curing.
Examples of waterproofing materials include bituminous coatings, cementitious coatings, and liquid-applied membrane...
ANAROCK Property Consultants Interview FAQs
Tell us how to improve this page.
ANAROCK Property Consultants Interviews By Designations
- ANAROCK Property Consultants Senior Associate Interview Questions
- ANAROCK Property Consultants Sales Manager Interview Questions
- ANAROCK Property Consultants Sourcing Manager Interview Questions
- ANAROCK Property Consultants Senior Sales Associate Interview Questions
- ANAROCK Property Consultants Manager Interview Questions
- ANAROCK Property Consultants Assistant Manager Interview Questions
- ANAROCK Property Consultants Team Manager Interview Questions
- ANAROCK Property Consultants Sales Executive Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
|
Assistant Manager
245
salaries
|  ₹4.4 L/yr - ₹11 L/yr |
|
Senior Associate
229
salaries
| ₹3.5 L/yr - ₹7.3 L/yr |
|
Manager
108
salaries
| ₹8 L/yr - ₹14.2 L/yr |
|
Sales Manager
108
salaries
| ₹4 L/yr - ₹9 L/yr |
|
Sales Associate
68
salaries
| ₹3 L/yr - ₹6.6 L/yr |
NoBroker
Sobha
Lodha Group
Cushman & Wakefield
- Home >
- Interviews >
- ANAROCK Property Consultants Interview Questions
