NeenOpal Intelligent Solutions Data Analyst Interview Questions and Answers

Excel, Python, SQL and Power BI

Q1. Remove duplicates from an array without using any functions
Ans. 
Remove duplicates from an array without using any functions
• Create an empty array to store unique values

• Loop through the original array and check if the value is already in the unique array before adding it

• Use nested loops to compare each element with all other elements in the array
Answered by AI
View 1 more amswer
Q2. Create a single dimensional array from a multi dimensional array
Ans. 
To create a single dimensional array from a multi dimensional array, use the flatten method in Python.
• Use the flatten method in Python to convert a multi dimensional array into a single dimensional array.

• Example: multi_array = [[1, 2], [3, 4], [5, 6]]

• single_array = [item for sublist in multi_array for item in sublist]
Answered by AI
Add your answer
Q3. You have a 7 minutes hourglass and a 4 minutes hourglass, now figure out a way to calculate 9 minutes
Add your answer

Q1. Questions on Sand timer
Add your answer

It was based upon Tableau

Q1. They asked some python based question
Add your answer