ANAROCK Property Consultants
20+ Elgebra Interview Questions and Answers
Q1. What do you mean by MTD ? How to create it
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 sales data from January 1st to January 15th.
MTD is often us...read more
Q2. What is Data Modelling? Types of Data Models
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 considering how it will be implemented in a database system.
Physic...read more
Q3. Write query to find department wise highest salary in an organisation.
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
Q4. What are joins? Types of joins.
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 JOIN returns rows when there is a match in one of the tabl...read more
Q5. Diffrence between Calculated column and Measure?
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 calculated from birthdate, while examples of measures inc...read more
Q6. What are the most important aspects of sales
The most important aspects of sales include building relationships, understanding customer needs, effective communication, and closing deals.
Building relationships with customers to gain trust and loyalty
Understanding customer needs and providing solutions that meet those needs
Effective communication to convey the value of products or services
Closing deals by overcoming objections and negotiating terms
Q7. RLS in power bi
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
Q8. Have yu handled the activity requirement for societies.
Yes, I have experience in handling activity requirements for societies.
I have organized various events and activities for societies in the past.
I am familiar with the process of obtaining necessary permits and permissions.
I have a network of vendors and suppliers to ensure smooth execution of events.
I am able to work within budget constraints and deliver high-quality events.
For example, I organized a cultural festival for a residential society which included performances, foo...read more
Q9. Market Estimation of Real Estate Commercial and Residential Real Estate difference
Market estimation of real estate and differences between commercial and residential real estate.
Market estimation involves analyzing the current and future demand and supply of real estate in a particular area.
Commercial real estate is used for business purposes, while residential real estate is used for living purposes.
Commercial real estate tends to have higher rental rates and longer lease terms than residential real estate.
Residential real estate is typically more affecte...read more
Q10. What is MVC and architecture of CI
MVC is a software design pattern that separates an application into three main components: Model, View, and Controller. CI follows the MVC architecture.
Model represents the data and business logic of the application.
View is responsible for displaying the data to the user.
Controller acts as an intermediary between Model and View, handling user input and updating the Model accordingly.
CodeIgniter (CI) is a PHP framework that follows the MVC architecture.
CI's controllers handle ...read more
Q11. Which all A cat builders are present in banglore
Some A cat builders present in Bangalore are ABC Builders, XYZ Constructions, and LMN Developers.
ABC Builders
XYZ Constructions
LMN Developers
Q12. Tell the map line of thane city
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
Q13. What do you know about the market trends in Mumbai
Q14. Any prior Real estate knowledge?
Yes, I have prior real estate knowledge.
I have worked as a real estate agent for 5 years.
I have experience in property management and leasing.
I have also invested in real estate properties for personal gain.
Q15. Advanced MySQL query with example
An advanced MySQL query involves using complex joins, subqueries, and functions to retrieve specific data.
Use JOIN to combine data from multiple tables
Utilize subqueries to retrieve data based on results from another query
Leverage functions like COUNT, SUM, AVG for calculations
Example: SELECT * FROM table1 JOIN table2 ON table1.id = table2.id WHERE table1.column = (SELECT column FROM table3 WHERE condition)
Q16. Why sales after Civil Engineering?
Q17. Depth of real estate
Depth of real estate refers to the level of detail and complexity involved in real estate transactions and management.
Depth of real estate can refer to the intricacies of property laws and regulations that must be navigated in transactions.
It can also refer to the level of analysis and research required to make informed decisions about real estate investments.
Understanding market trends, property values, and financial implications are all part of the depth of real estate.
For ...read more
Q18. Sales experience
I have over 5 years of sales experience in various industries, consistently exceeding targets and building strong client relationships.
Managed a portfolio of clients and consistently met or exceeded sales targets
Developed and implemented sales strategies to increase revenue
Built strong relationships with clients to ensure repeat business
Utilized CRM systems to track sales progress and client interactions
Q19. Why real estate?
Real estate offers opportunities for growth, financial stability, and the chance to help people find their dream homes.
Real estate provides the potential for financial growth through property appreciation and rental income
It allows for the opportunity to help individuals and families find their ideal homes or investment properties
The industry offers a diverse range of career paths, from sales and marketing to property management and development
Q20. Name five developers
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
Top HR Questions asked in Elgebra
Interview Process at Elgebra
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month