AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Lagozon Technologies Interview Questions and Answers
Lagozon Technologies Interview Experiences
5 interviews found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There were 4 interview rounds.
Multiple choice questions
(2 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
- 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
(2 Questions)
- 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
- Q2. On kpi show highest salary and customer name
(2 Questions)
- Q1. View and time intelligence function
- 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
Interview Preparation Tips
Skills evaluated in this interview
BI Developer Interview Questions asked at other Companies
(1 Question)
- Q1. Dax for inactive relationships
- Ans.
DAX can be used to create calculated columns or measures to handle inactive relationships in Power BI.
Use DAX functions like USERELATIONSHIP to specify which relationship to use in calculations.
Consider using DAX functions like CALCULATE and FILTER to work with inactive relationships.
Example: CALCULATE(SUM('Table'[Column]), USERELATIONSHIP('Table'[RelatedColumn], 'RelatedTable'[RelatedColumn]))
Skills evaluated in this interview
Power BI Developer Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed in Feb 2023. There were 4 interview rounds.
(1 Question)
- Q1. Basic questions and about the your experience and skills
(1 Question)
- Q1. About your projects and some Spark & SQL questions
(1 Question)
- Q1. About your responsibility and some other real time scenario questions
Data Engineer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. What is a Data Flow in Power BI/Azure environment ?
- Ans.
Data Flow is a Power BI feature that allows users to transform and load data from various sources into a Power BI dataset.
Data Flow is a visual interface for building ETL (Extract, Transform, Load) processes in Power BI
It allows users to connect to various data sources, transform data using Power Query Editor, and load the transformed data into a Power BI dataset
Data Flow can be scheduled to refresh data on a regular b...
- Q2. Is the M query case sensitive ? Is DAX ?
- Ans.
M query and DAX are both case sensitive.
M query is case sensitive, meaning that 'Hello' and 'hello' are considered different values.
DAX is also case sensitive, so 'SUM' and 'sum' are not the same.
It is important to be consistent with capitalization when working with M query and DAX.
- Q3. How would you use Calender Function in DAX if there's no date field in your dataset ?
- Ans.
Calendar function in DAX can be used to create a date table from scratch.
Create a new table with a column for each date component (year, month, day)
Use the CALENDAR function to generate a range of dates
Join the new table with the existing dataset using a common key
Use the new date table to perform time intelligence calculations
Interview Preparation Tips
Skills evaluated in this interview
IT (Data Analytics) Interview Questions asked at other Companies
Lagozon Technologies interview questions for popular designations
Interview Questionnaire
2 Questions
- Q1. Different types of Loads?
- Ans.
Different types of loads include static, dynamic, thermal, and seismic loads.
Static loads are constant and do not change over time, such as the weight of a building.
Dynamic loads are variable and can change over time, such as wind or water pressure.
Thermal loads are caused by temperature changes and can cause expansion or contraction of materials.
Seismic loads are caused by earthquakes and can cause shaking or vibratio...
- Q2. Qlik Sense Server Site experience,if any?
Business Analyst Interview Questions asked at other Companies
Interview questions from similar companies
I applied via Walk-in and was interviewed before Sep 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. A lot questions.
Interview Preparation Tips
I appeared for an interview before Jul 2020.
Interview Questionnaire
1 Question
- Q1. Is Infosys listed?
- Ans.
Yes, Infosys is listed on the Indian stock exchanges as well as on the NYSE.
Infosys is listed on the Bombay Stock Exchange (BSE) and National Stock Exchange of India (NSE)
It is also listed on the New York Stock Exchange (NYSE)
Infosys has a market capitalization of over $80 billion as of 2021
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Time management
I applied via Company Website and was interviewed before Feb 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. They asked about dbms questions in the form of table formate
- Q2. They asked code for some python program
Interview Preparation Tips
I applied via Naukri.com and was interviewed before May 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Explain me about yourself
- Q2. Just be brief don't bore them
Interview Preparation Tips
Lagozon Technologies Interview FAQs
Tell us how to improve this page.
Lagozon Technologies Interviews By Designations
Interview Questions for Popular Designations
Lagozon Technologies Interview Process
based on 6 interviews
Interview experience
Interview Questions from Similar Companies
Lagozon Technologies Reviews and Ratings
based on 38 reviews
Rating in categories
|
Data Analyst
27
salaries
|  ₹4 L/yr - ₹8 L/yr |
|
Data Engineer
27
salaries
| ₹4.8 L/yr - ₹15.4 L/yr |
|
BI Developer
10
salaries
| ₹2.4 L/yr - ₹10 L/yr |
|
Consultant
7
salaries
| ₹6.9 L/yr - ₹16 L/yr |
|
BI Consultant
7
salaries
| ₹5.5 L/yr - ₹10.5 L/yr |
TCS
Accenture
Cognizant
Infosys
- Home >
- Interviews >
- Lagozon Technologies Interview Questions
