AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Loginworks Softwares Associate Data Analyst Interview Questions, Process, and Tips
Loginworks Softwares Associate Data Analyst Interview Experiences
1 interview found
I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. What is vlookup's function and it's limitation in excel.
- Ans.
vlookup is a function in Excel used to search for a specific value in a table and return a corresponding value from another column.
vlookup stands for 'vertical lookup'
It requires a lookup value, a table array, column index number, and an optional range lookup value
It can only search for values in the leftmost column of the table array
It returns the first matching value found, so it may not be accurate if there are dupl...
- Q2. Write a query to find rows beginning with letter in SQL
- Ans.
Query to find rows beginning with a letter in SQL
Use the LIKE operator with the pattern '[letter]%'
Replace [letter] with the desired letter
Enclose the pattern in single quotes
Example: SELECT * FROM table_name WHERE column_name LIKE 'A%'
- Q3. How can u find duplicates in excel
- Ans.
To find duplicates in Excel, use the conditional formatting feature or the Remove Duplicates tool.
Select the range of cells where you want to find duplicates
Go to the 'Home' tab and click on 'Conditional Formatting'
Select 'Highlight Cells Rules' and then 'Duplicate Values'
Choose the formatting style and click 'OK'
Alternatively, go to the 'Data' tab and click on 'Remove Duplicates'
Select the columns where you want to fi
- Q4. Write a query to find duplicates in sql.
- Ans.
Query to find duplicates in SQL
Use GROUP BY clause to group the columns that may have duplicates
Use HAVING clause to filter the groups that have more than one row
Use COUNT() function to count the number of rows in each group
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Business Analyst Interview Questions & Answers
Hestabit Technologies
Anonymous
posted on 18 Jun 2022
I applied via Approached by Company and was interviewed before Jun 2021. There was 1 interview round.
(1 Question)
- Q1. How would you respond to a client who is not happy with the progress of work and wants to put the work on hold
Interview Preparation Tips
Business Analyst Interview Questions & Answers
Hestabit Technologies
Shruti Tiwari
posted on 9 Sep 2020
I applied via LinkedIn and was interviewed in Aug 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. About yourself
- Q2. About company and related technologies used in this process
Interview Preparation Tips
2nd is video call interview also not that much tough, just read about company and JD
Business Analyst Interview Questions & Answers
Hestabit Technologies
Anonymous
posted on 20 Mar 2025
Selected
I appeared for an interview before Mar 2024, where I was asked the following questions.
- Q1. What was your experience with the cold call?
- Q2. What technical expertise do you possess?
- Ans.
I possess a strong technical background in data analysis, SQL, and business intelligence tools, enhancing decision-making processes.
Proficient in SQL for database querying and data manipulation, enabling efficient data extraction and reporting.
Experienced with data visualization tools like Tableau and Power BI, creating interactive dashboards for stakeholder insights.
Skilled in Excel for advanced data analysis, includi...
Business Analyst Interview Questions & Answers
Hestabit Technologies
Anonymous
posted on 17 Mar 2025
Selected
I appeared for an interview before Mar 2024, where I was asked the following questions.
- Q1. Can you provide details about yourself and your work experience?
- Q2. Can you describe a situation in which you had to handle pressure, meet deadlines, or overcome challenges in your previous jobs?
Selected
I applied via Job Portal and was interviewed before Dec 2023. There were 3 interview rounds.
SQL Test with 5 questions
(2 Questions)
- Q1. Approach towards solving the SQL Queries from the test
- Q2. Past Experiences
(2 Questions)
- Q1. Resume related Questions
- Q2. Power BI and SQL related questions. How to approach in a dashboard building process
I applied via LinkedIn and was interviewed in Apr 2024. There were 3 interview rounds.
Aptitude test, basic maths and LR
SQL and Visualisation related
(1 Question)
- Q1. Asked for details after qualifying in test
Interview Preparation Tips
Software Engineer Interview Questions & Answers
American Megatrends
R. Arockia Ratheesh Sahayaraj
posted on 6 Nov 2015
Interview Preparation Tips
Experience: Only 24 people from my campus attended the placement process of this company.The experience wasn't really good.I wasn't
short-listed for next round as my CGPA was 7.5 and need was of above 7.5 ,as they were maintaining standards.
Round: Test
Experience: 1.C aps was really tough.
2.Section 2 we had to choose either Microprocessor or Java,I preferred microprocessor . 3.Simple Questions on 8085 and 8086 instruction set was asked.
4.How much memory are there are 20 address lines,
5.Difference between SRAM and DRAM.
6.ROM is used for stack or not.
7.What are contents of Stack Pointer after PUSH and POP operation.
8.What happens after RET instruction?
9.What is CMC equivalent instruction?
Round: Test
Experience: 16 questions on Quant which are :-
Odd number in a series, Area and Volume, Games of Skill, Time and Work, Average, Trains, Boats
and Streams, Profit and Gain were asked.
If no. of handshakes is 66,find total number of People.?
A lotus in a pond doubles in size everyday,if it fills the pond on 20th day,when will be the pond would be half?
LOGICAL REASONING-
4 men are on the side of a bridge.One torch light is with them and without it they cannot cross
the bridge.The bridge can withstand only 2 people at a time.The time required by the persons are 1
min,2 mins,7 mins,10 mins respectively.Find the shortest time required by all of em to cross the
bridge.
(Answer: 17 minutes)
Round: SOFT SKILLS
Experience: scenario based questions were asked:-
1.working on a project in your company and your brother is in urgent need of a project.What will you do?
2.Your friend mails the project details to some other company.what will be you reaction?
3.Your boss allows to take your team members for a treat.Whether you choose costly one or within budget?
4.Your favorite subject in your curriculum and Why?
5.Where you would view yourself in 5 years?
6.What is a dream company in your terms?
7.Any situation were your work was criticized and what was your reaction?
Skills:
College Name: Anna University Chennai
I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Python file handling, input,output, in a file, Sql joins, list sort in python, basics of GIS, Web service how to test
Interview Preparation Tips
Senior Software Engineer Interview Questions & Answers
American Megatrends
Anonymous
posted on 29 Nov 2022
I applied via Approached by Company and was interviewed before Nov 2021. There were 2 interview rounds.
Array and OOPS concept. Given set of questions to solve with each oops concept
(3 Questions)
- Q1. Out of box thinking. Given logical puzzles and ask you to analyze and provide your understanding
- Q2. Explain the inheritance concept with car model
- Ans.
Inheritance in car model refers to the ability of a new car model to inherit features and characteristics from an existing car model.
Inheritance allows for the creation of a new car model that shares common features with an existing car model
The new car model can add or modify features inherited from the existing car model
For example, a new sports car model can inherit features from a base car model such as engine, tra...
- Q3. Probability question with fruits and boxes
Interview Preparation Tips
Loginworks Softwares Interview FAQs
Tell us how to improve this page.
Loginworks Softwares Interviews By Designations
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Senior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Scientist Interview Questions
- Jr. Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Show more
Interview Questions from Similar Companies
|
Software Developer
25
salaries
|  ₹1 L/yr - ₹4.2 L/yr |
|
Data Analyst
25
salaries
| ₹1.5 L/yr - ₹4.2 L/yr |
|
Associate Software Developer
13
salaries
| ₹1.7 L/yr - ₹3.5 L/yr |
|
Associate Data Analyst
8
salaries
| ₹2 L/yr - ₹2.5 L/yr |
|
Customer Success Manager
7
salaries
| ₹5.8 L/yr - ₹7 L/yr |
HyScaler
Pitney Bowes
AvenData GmbH
Dataflow Group
- Home >
- Interviews >
- Loginworks Softwares Interview Questions >
- Loginworks Softwares Associate Data Analyst Interview Questions
