Spartan Matriculation Higher Secondary School Interview Questions and Answers

My passion for data-driven decision-making and problem-solving led me to pursue a career as a Data Analyst.

• I have always been fascinated by numbers and how they can tell a story, like analyzing sales data to identify trends.

• During my college years, I worked on a project that involved cleaning and analyzing a large dataset, which sparked my interest in data analysis.

• I enjoy using tools like Excel and SQL to manipulate d...read more

You can remove duplicates in Excel using the 'Remove Duplicates' feature in the Data tab.

• Select the range of cells or the entire table where you want to remove duplicates.

• Go to the 'Data' tab on the Ribbon.

• Click on 'Remove Duplicates'.

• In the dialog box, choose the columns to check for duplicates.

• Click 'OK' to remove duplicates; Excel will inform you how many duplicates were removed.

I have experience with various data analysis tools including Excel, SQL, Python, and Tableau for data visualization and reporting.

• Excel: Used for data cleaning, analysis, and visualization through pivot tables and charts.

• SQL: Employed for querying databases to extract and manipulate data efficiently.

• Python: Utilized libraries like Pandas and NumPy for data manipulation and analysis.

• Tableau: Created interactive dashboar...read more