TCS Junior Data Analyst Interview Questions and Answers

Developed a predictive model to forecast customer churn for a telecommunications company.

• Used machine learning algorithms such as logistic regression and random forest

• Performed data preprocessing and feature engineering to improve model accuracy

• Collaborated with business stakeholders to understand key factors influencing customer churn

The available data types in SQL include numeric, character, date/time, and boolean types.

• Numeric data types include integer, decimal, and floating-point types.

• Character data types include char, varchar, and text types.

• Date/time data types include date, time, datetime, and timestamp types.

• Boolean data type represents true or false values.

Joins are used to combine rows from two or more tables based on related columns.

• INNER JOIN: Returns records that have matching values in both tables.

• LEFT JOIN: Returns all records from the left table and the matched records from the right table.

• RIGHT JOIN: Returns all records from the right table and the matched records from the left table.

• FULL JOIN: Returns all records when there is a match in either left or right tab...read more

Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.

• Power BI is a Microsoft product used for data analysis and visualization.

• It allows users to connect to various data sources and create interactive reports and dashboards.

• Power BI offers a wide range of visualizations, such as charts, graphs, and maps, to present data in a meaningful way.

• Users can perfor...read more