Filter interviews by
I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.
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...
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...
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...
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 ...
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
Top trending discussions
I applied via Naukri.com and was interviewed in Apr 2023. There were 4 interview rounds.
Technical question answers
I applied via Referral and was interviewed in Feb 2021. There was 1 interview round.
I applied via Referral and was interviewed before Nov 2020. There were 5 interview rounds.
I applied via Walk-in and was interviewed in Feb 2024. There were 3 interview rounds.
Online assessment around 30-50mins
I applied via LinkedIn and was interviewed in Dec 2021. There were 4 interview rounds.
I applied via Referral and was interviewed before Jan 2021. There were 4 interview rounds.
I have given aptitude test which has 30 questions
I applied via Referral and was interviewed in May 2022. There were 3 interview rounds.
Regarding the lease agreement. Basic questions regarding that. English test was also there
based on 1 interview
Interview experience
Assistant Manager
251
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
241
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Manager
118
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
107
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Associate
77
salaries
| ₹0 L/yr - ₹0 L/yr |
JLL
CBRE
Knight Frank
Colliers India