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, Process, and Tips
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
Anonymous
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
I applied via Naukri.com and was interviewed in Sep 2021. There was 1 interview round.
(1 Question)
- Q1. So u know internal audit
- Ans. Say yes and u r hired
Interview Preparation Tips
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
(1 Question)
- Q1. About projects in previous company
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...
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.
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
(1 Question)
- Q1. Past work experience Puzzle Technical questions on finance
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed before May 2022. There were 7 interview rounds.
(1 Question)
- Q1. All Technical Queries relevant to work profile
(1 Question)
- Q1. Cross functional along with technical
(2 Questions)
- Q1. Cross functional
- Q2. Kind of Challenge facing at present in projects
- Ans.
Managing remote teams and ensuring timely delivery of projects
Coordinating with team members across different time zones
Ensuring effective communication and collaboration among team members
Tracking progress and identifying potential roadblocks
Adapting to changing project requirements and timelines
Ensuring timely delivery of projects within budget constraints
Aptitude was at higher level questions the said test was online
(1 Question)
- Q1. Working culture Management skills etc
(1 Question)
- Q1. Final brief for on boarding with functional head
- Ans.
The final onboarding brief with the functional head is crucial for a smooth transition into the role.
Ensure clear communication of expectations and responsibilities
Provide an overview of the team and their roles
Discuss any ongoing projects and priorities
Address any concerns or questions the new manager may have
Set up regular check-ins to monitor progress and provide support
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 Sourcing Manager Interview Questions
- ANAROCK Property Consultants Senior Sales Associate Interview Questions
- ANAROCK Property Consultants Sales Manager Interview Questions
- ANAROCK Property Consultants Manager Interview Questions
- ANAROCK Property Consultants Team Manager Interview Questions
- ANAROCK Property Consultants Sales Executive Interview Questions
- ANAROCK Property Consultants Assistant Vice President Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Science Engineer Interview Questions
- Show more
ANAROCK Property Consultants Data Analyst Intern Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Assistant Manager
241
salaries
|  ₹3.7 L/yr - ₹10 L/yr |
|
Senior Associate
199
salaries
| ₹2.8 L/yr - ₹7.2 L/yr |
|
Manager
111
salaries
| ₹5 L/yr - ₹17 L/yr |
|
Sales Manager
108
salaries
| ₹3 L/yr - ₹11.5 L/yr |
|
Sales Associate
73
salaries
| ₹3 L/yr - ₹6.5 L/yr |
NoBroker
Sobha
Lodha Group
Cushman & Wakefield
- Home >
- Interviews >
- ANAROCK Property Consultants Interview Questions >
- ANAROCK Property Consultants Data Analyst Intern Interview Questions
