TCS Data Analyst Interview Questions, Process, and Tips

Q1. Dax quries and powerquery
Add your answer
Q2. Azure data factory
Add your answer

Basic aptitude with coding

Q1. Basic questions related with your strem
Add your answer

The questions were related to Statistics and Data Science

Q1. Based on SQL and Python
Add your answer
Q2. Joins and different clause in SQL
Ans. 
Joins and different clause in SQL
• Joins are used to combine rows from two or more tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Clauses like WHERE, GROUP BY, HAVING, and ORDER BY are used to filter, group, and sort data in SQL queries
Answered by AI
Add your answer
Q3. Confusion metrics
Add your answer

Q1. Basic questions
Add your answer

Q1. Can you describe the experience with data analysis and its tools?
Ans. 
I have extensive experience in data analysis using tools such as Excel, SQL, Python, and Tableau.
• Proficient in Excel for data cleaning, manipulation, and visualization

• Strong SQL skills for querying databases and extracting relevant information

• Experience with Python for statistical analysis and machine learning

• Familiarity with Tableau for creating interactive dashboards and reports
Answered by AI
Add your answer
Q2. How do you determine which variable is important in predictive model ?
Ans. 
Variables importance in predictive model is determined using techniques like feature selection, correlation analysis, and machine learning algorithms.
• Use feature selection techniques like Recursive Feature Elimination (RFE) or SelectKBest to identify important variables.

• Analyze correlation between variables and target variable to determine importance.

• Utilize machine learning algorithms like Random Forest or Gradient Bo...read more
Answered by AI
Add your answer

Q1. Location discussion and Preference's
Add your answer
Q2. Salary discussion
Add your answer