KPIT Technologies Data Analyst Interview Questions and Answers

Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.

• Rank assigns consecutive integers to each distinct value based on their order.

• Dense rank also assigns consecutive integers, but does not leave gaps between ranks.

• For example, if we have values 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3.

RLS in Power Bi stands for Row-Level Security, which allows users to restrict access to data based on their role or profile.

• RLS in Power Bi is used to control access to data at the row level

• It allows users to define rules to restrict data based on their role or profile

• RLS can be implemented using DAX expressions to filter data dynamically

• For example, a sales manager can only see data related to their region using RLS

Identifying time for a project involves creating a timeline, setting deadlines, and monitoring progress.

• Create a project timeline outlining key milestones and tasks

• Set deadlines for each task to ensure timely completion

• Monitor progress regularly to identify any delays and adjust timelines accordingly