TCI Supply Chain Solutions Data Entry Operator Interview Questions and Answers

Simple maths questions easily solving problems

Q1. Self introduction about yourself
Ans. 
I am a detail-oriented and organized individual with experience in data entry. I have strong typing skills and a high level of accuracy.
• I have worked as a data entry operator for XYZ company for 2 years.

• During my time at XYZ company, I was responsible for entering large volumes of data into spreadsheets and databases.

• I have a typing speed of 60 words per minute with a 99% accuracy rate.

• I am proficient in using Microsof...read more
Answered by AI
Add your answer
Q2. Vlookup formula, pivot table
Add your answer

Q1. About yourself what about your working?
Add your answer

Talk to the head hunter. General phone screening

Q1. Talk to the hiring manager and another manager from BI. Asked about work experience and gave me a SQL test
Add your answer

Shared a dataset and wanted me to provide some insights and also build some slides to present

Python, SQL, Aptitude

Q1. SQL - A table EmployeeSkills was given having two columns EmpID & Skills. There can be multiple for an employee id with skills he possess. You need to find the EmpID having skills in Python and SQL
Add your answer
Q2. PowerBI - Create Bookmarks in Power BI
Ans. 
Bookmarks in Power BI allow users to save the state of a report, including filters, slicers, and visuals.
• Bookmarks can be created by selecting 'View' and then 'Bookmarks' in the Power BI toolbar.

• Users can add bookmarks by selecting 'Add' and then naming the bookmark.

• Bookmarks can be applied by selecting the desired bookmark from the 'Bookmarks' pane.

• Bookmarks can be used to save different views of a report for easy acc
Answered by AI
Add your answer
Q3. SQL - Find cumulative Profit sum in a given table.
Ans. 
Use SQL query with window function to find cumulative profit sum in a given table.
• Use window function like SUM() with ORDER BY clause to calculate cumulative profit sum.

• Example: SELECT date, profit, SUM(profit) OVER (ORDER BY date) AS cumulative_profit FROM table_name;

• Ensure the table has a column for date and profit to order and calculate cumulative sum.
Answered by AI
Add your answer

SQL, Python and Power BI