INDO-MIM Senior Technical Lead Interview Questions, Process, and Tips

To find the median in SQL, you can use the NTILE() function to divide the data into two halves and then calculate the average of the middle values.

• Use the NTILE() function to divide the data into two halves

• Calculate the average of the middle values to find the median

• Consider handling cases where the number of values is even or odd

LOD in Tableau stands for Level of Detail and refers to the ability to control the level of aggregation in visualizations.

• LOD expressions allow you to compute values at different levels of detail in Tableau.

• There are three types of LOD expressions: INCLUDE, EXCLUDE, and FIXED.

• INCLUDE LOD expressions compute values at the specified level of detail and then aggregate them up to the view level.

• EXCLUDE LOD expressions excl...read more

Sets are collections of unique elements with no specific order, while groups are collections of elements with a defined structure and operations.

• Sets do not allow duplicate elements, while groups can have repeated elements.

• Sets do not have a specific order, while groups may have a defined structure.

• Sets are often used in mathematical contexts, while groups are used in algebra and other areas of mathematics.

YTD stands for Year-to-Date and MTD stands for Month-to-Date, both are used to track financial performance over a specific period of time.

• YTD refers to the period starting from the beginning of the current year up to the present date.

• MTD refers to the period starting from the beginning of the current month up to the present date.

• YTD and MTD are commonly used in financial reporting to analyze performance trends.

• For exam...read more