ANAROCK Property Consultants Data Analyst Intern Interview Questions, Process, and Tips

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

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

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

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

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

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