Lagozon Technologies BI Developer Interview Questions and Answers

Multiple choice questions

Q1. Find Third highest salary from the given scenario
Ans. 
To find the third highest salary, sort the salaries in descending order and select the third salary.
• Sort the salaries in descending order

• Select the third salary from the sorted list
Answered by AI
Add your answer
Q2. What is dynamic row level security
Ans. 
Dynamic row level security is a feature that allows restrictions to be applied to rows of data based on user roles or attributes.
• Implemented in BI tools like Power BI or Tableau

• Security rules are defined based on user roles or attributes

• Users only see data that they are authorized to access
Answered by AI
Add your answer

Q1. How you make understand your dashboard to non technical person
Ans. 
I use simple language, visuals, and real-life examples to explain the dashboard to non-technical individuals.
• Use simple language and avoid technical jargon

• Include visuals like charts and graphs to make data easier to understand

• Provide real-life examples to illustrate the data and its implications
Answered by AI
Add your answer
Q2. On kpi show highest salary and customer name
Add your answer

Q1. View and time intelligence function
Add your answer
Q2. Difference between views and table explain with examples
Ans. 
Views are virtual tables that display data from one or more tables, while tables store data physically.
• Views are saved queries that act as virtual tables

• Views do not store data physically, but tables do

• Views can be used to simplify complex queries or restrict access to certain columns

• Tables are used to store data permanently

• Example: A view can be created to display only specific columns from a table
Answered by AI
Add your answer