UST Associate Data Analyst Interview Questions and Answers

General aptitude test

Q1. About company, goals, about yourself
Add your answer

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

It was related to Aptitude MCQ and 2-coding test

Q1. Palindrome of a number
Ans. 
A palindrome of a number is a number that remains the same when its digits are reversed.
• To check if a number is a palindrome, reverse the number and compare it with the original number.

• Examples: 121 is a palindrome, 123 is not a palindrome.
Answered by AI
Add your answer
Q2. Merge 2linked list
Ans. 
Merging two linked lists involves combining the elements of both lists into a single list.
• Create a new linked list to store the merged elements

• Traverse through both linked lists and add elements to the new list

• Handle cases where one list is longer than the other
Answered by AI
Add your answer
Q3. About projects you have done
Add your answer

Q1. Explain your resume fully
Add your answer
Q2. General questions on the behaviour
Add your answer

Q1. What is the importance of data analysis?
Ans. 
Data analysis is crucial for making informed decisions, identifying trends, and solving complex problems.
• Helps in making informed decisions based on data-driven insights

• Identifies trends and patterns that can lead to strategic business decisions

• Aids in solving complex problems by analyzing data to find root causes

• Improves efficiency and effectiveness of processes through data-driven optimizations
Answered by AI
Add your answer
Q2. What steps should be taken to become a data analyst?
Ans. 
To become a data analyst, one should focus on acquiring relevant education, gaining experience with data analysis tools, and developing strong analytical and problem-solving skills.
• Obtain a degree in a related field such as statistics, mathematics, computer science, or data science.

• Gain experience with data analysis tools such as SQL, Python, R, and Excel.

• Develop strong analytical and problem-solving skills by working ...read more
Answered by AI
Add your answer

NER training using deep learning

Q1. Describe the approach taken for assignment
Ans. 
I approach assignments by breaking them down into smaller tasks, setting deadlines, and regularly checking progress.
• Break down the assignment into smaller tasks to make it more manageable

• Set deadlines for each task to stay on track

• Regularly check progress to ensure everything is on schedule

• Seek feedback from colleagues or supervisors to improve the quality of work
Answered by AI
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Extract only India Players from dictionary (using list comprehension) CSK = {"Dhoni" : "India", "Du Plessis" : "South Africa", "RituRaj": "India", "Peterson" : "England", "Lara" : "West Indies"}
Ans. 
Extract India players from a dictionary using list comprehension
• Use list comprehension to filter out players with nationality as 'India'

• Create a new list with only the India players

• Example: [player for player, nationality in CSK.items() if nationality == 'India']
Answered by AI
View 2 more answers
Q2. Find Common Elements in three lists using sets arr1 = [1,5,10,20,40,80,100] arr2 = [6,7,20,80,100] arr3 = [3,4,15,20,30,70,80,120]
Ans. 
Use sets to find common elements in three lists.
• Convert the lists to sets for efficient comparison.

• Use the intersection method to find common elements.

• Return the common elements as a set or list.
Answered by AI
View 1 more answer
Q3. Check if you found any error in the below code: school_name = 'ABC School' def __init__(self, name, roll_no): self.name = name self.roll_no = roll_no def show(self)" print('Ins...read more
Add your answer
Q4. How do you print the 3, 5 and 7th row in a database (Python - use Pandas)
Ans. 
Printing specific rows from a database using Pandas in Python
• Use Pandas library to read the database into a DataFrame

• Use iloc method to select specific rows by index

• Print the selected rows
Answered by AI
Add your answer
Q5. Split Dataset in train, test and validation (import library and split dataset)
Ans. 
Use scikit-learn library to split dataset into train, test, and validation sets
• Import train_test_split from sklearn.model_selection

• Specify test_size and validation_size when splitting the dataset

• Example: X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=42)
Answered by AI
Add your answer
Q6. Print Unique values in the dataset and delete the duplicate rows (SQL)
Ans. 
Use DISTINCT keyword to print unique values and DELETE with a subquery to remove duplicate rows.
• Use SELECT DISTINCT column_name FROM table_name to print unique values.

• Use DELETE FROM table_name WHERE row_id NOT IN (SELECT MAX(row_id) FROM table_name GROUP BY column_name) to delete duplicate rows.
Answered by AI
Add your answer
Q7. Print rows where a certain criterion is met (ex - in a dataset of employees select the ones whose salary is greater than 100000 - in SQL)
Ans. 
Use SQL SELECT statement with WHERE clause to filter rows based on a specific criterion.
• Use SELECT statement with WHERE clause to specify the criterion (ex: salary > 100000)

• Example: SELECT * FROM employees WHERE salary > 100000;

• Ensure proper syntax and column names are used in the query
Answered by AI
Add your answer
Q8. Print rows with the second highest criterion value without using offset function in SQL
Ans. 
Use subquery to find rows with second highest criterion value in SQL without using offset function.
• Use a subquery to find the maximum criterion value

• Then use another subquery to find the maximum value that is less than the maximum value found in the first subquery

• Finally, select rows with the second highest criterion value
Answered by AI
Add your answer
Q9. Print rows with the same set of values in column (these are not duplicates row - just the duplicates values in a column)
Ans. 
Print rows with the same set of values in a column
• Identify unique sets of values in the column

• Group rows based on these unique sets of values

• Print out the rows for each unique set of values
Answered by AI
Add your answer
Q10. Difference between Power BI and Tableau
Ans. 
Power BI is a Microsoft product focused on business intelligence and data visualization, while Tableau is a standalone data visualization tool.
• Power BI is more user-friendly and integrates well with other Microsoft products.

• Tableau is known for its powerful data visualization capabilities and flexibility in creating complex visualizations.

• Power BI is often preferred by organizations already using Microsoft products, wh...read more
Answered by AI
Add your answer
Q11. Limitations of Power BI and Tableau
Ans. 
Power BI and Tableau have limitations in terms of data connectivity, customization, and pricing.
• Limited data connectivity options compared to other tools

• Limited customization capabilities for advanced analytics

• High pricing for enterprise-level features

• Tableau has better visualization capabilities but can be more complex to use

• Power BI is more user-friendly but may lack certain advanced features
Answered by AI
Add your answer
Q12. What are the types of regression models, name them and explain them
Ans. 
Types of regression models include linear regression, logistic regression, polynomial regression, ridge regression, and lasso regression.
• Linear regression: used to model the relationship between a dependent variable and one or more independent variables.

• Logistic regression: used for binary classification problems, where the output is a probability value between 0 and 1.

• Polynomial regression: fits a curve to the data by...read more
Answered by AI
Add your answer
Q13. Difference in Linear and Logistic Regression
Ans. 
Linear regression is used for continuous variables, while logistic regression is used for binary outcomes.
• Linear regression predicts continuous outcomes, while logistic regression predicts binary outcomes.

• Linear regression uses a linear equation to model the relationship between the independent and dependent variables.

• Logistic regression uses the logistic function to model the probability of a binary outcome.

• Linear reg...read more
Answered by AI
Add your answer
Q14. Difference in Random Forest and Decision Tree
Ans. 
Random Forest is an ensemble method using multiple decision trees, while Decision Tree is a single tree-based model.
• Random Forest is a collection of decision trees that are trained on random subsets of the data.

• Decision Tree is a single tree structure that makes decisions by splitting the data based on features.

• Random Forest reduces overfitting by averaging the predictions of multiple trees.

• Decision Tree can be prone t...read more
Answered by AI
Add your answer
Q15. What is ETL and what are the types or examples of ETL tools
Ans. 
ETL stands for Extract, Transform, Load. It is a process of extracting data from various sources, transforming it into a usable format, and loading it into a target database.
• ETL tools include Informatica PowerCenter, Talend, Apache Nifi, Microsoft SQL Server Integration Services (SSIS), and IBM InfoSphere DataStage.

• Extract: Data is extracted from various sources such as databases, files, APIs, etc.

• Transform: Data is cl...read more
Answered by AI
Add your answer

Q1. Can you tell me about yourself? Why do you want to work as a data analyst? What do you know about our company?
Add your answer
Q2. What are your short-term and long-term career goals in the field of data analysis? Why do you wish to pursue a career in data analysis? What factors motivate you to work in a data-driven environment?
Add your answer

Asked the question about ml and basic python questions