ANAROCK Property Consultants Interview Questions, Process, and Tips

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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
Q4. Questions were asked regarding my project, specifically related to the chosen metrics as KPIs and your motivation behind the project?
Add your answer
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
Add your answer
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 ...read more
Answered by AI
Add your answer
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
Add your answer

Debate on brokers and non brokers

Q1. Tell me about yourself
Add your answer
Q2. Tell the map line of thane city
Ans. 
Thane city is located in the state of Maharashtra, India.
• Thane is a city in the state of Maharashtra, India

• It is located in the Thane district

• Thane is part of the Mumbai Metropolitan Region (MMR)

• It is known for its historical landmarks and cultural heritage
Answered by AI
Add your answer
Q3. Name five developers
Ans. 
Some well-known developers in the industry
• John Carmack - known for his work on games like Doom and Quake

• Tim Sweeney - founder of Epic Games, creator of Unreal Engine

• Shigeru Miyamoto - creator of iconic games like Mario and Zelda

• Hideo Kojima - known for the Metal Gear Solid series

• Gabe Newell - co-founder of Valve Corporation, creator of Steam
Answered by AI
Add your answer

Q1. Education experience salary
Add your answer

Q1. Notice period location
Add your answer
Q2. Salary negotiation
Add your answer

Case based ppt presentation

Q1. About real Estate
Add your answer
Q2. Regarding Construction finance
Add your answer
Q3. Regarding commercial, industrial & logistic real estate
Add your answer

Q1. Regarding real estate trend
Add your answer
Q2. Real estate investment
Add your answer
Q3. Regarding Private equity & AIF
Add your answer