UST Associate Data Analyst Interview Questions and Answers

General aptitude test

Q1. About company, goals, about yourself
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

They gave a span of 3 days to build an AI-powered webapp

Q1. How would you go about learning a new skill
Add your answer
Q2. Experience in cloud technologies
Ans. 
I have experience working with cloud technologies such as AWS, Azure, and Google Cloud Platform.
• Experience in setting up and managing virtual machines, storage, and networking in cloud environments

• Knowledge of cloud services like EC2, S3, RDS, and Lambda

• Experience with cloud-based data processing and analytics tools like AWS Glue and Google BigQuery
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Project details and challenges faced in the project
Ans. 
Developed a predictive model for customer churn in a telecom company
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify key factors influencing churn

• Built and fine-tuned machine learning models to predict customer churn

• Challenges included imbalanced data, feature engineering, and model interpretability
Answered by AI
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. Tell me about your self?
Add your answer
Q2. What is maths and stats
Ans. 
Maths and stats refer to the study of mathematical concepts and statistical methods for analyzing data.
• Maths involves the study of numbers, quantities, shapes, and patterns.

• Stats involves collecting, analyzing, interpreting, and presenting data.

• Maths is used to solve equations, calculate probabilities, and model real-world phenomena.

• Stats is used to make informed decisions, draw conclusions, and test hypotheses.

• Both ma...read more
Answered by AI
Add your answer

Confusion matrix what are your job rolls explain me Gradient boosting algorithm?

Asked the question about ml and basic python questions

Q1. 1. Basics of Python 2. Basics of ML like supervised and unsupervised learning
Add your answer

Basic DP, Array Questions

Q1. Resume Walkthrough and Discussion, Medium level coding questions
Add your answer

Q1. Discussion with Manager
Add your answer

Q1. Normal HR round
Add your answer