ANAROCK Property Consultants Data Analyst Intern Interview Questions and Answers

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

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

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

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

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