State Street Bank Data Analyst Interview Questions and Answers

Q1. Tell me about your experience with Thoughtspot BI tool.
Ans. 
I have extensive experience using Thoughtspot BI tool to analyze and visualize data.
• Utilized Thoughtspot to create interactive dashboards for stakeholders

• Performed data cleaning and transformation within Thoughtspot platform

• Generated insights and recommendations based on data analysis in Thoughtspot
Answered by AI
Add your answer
Q2. What is your experience with API integration in Thoughtspot?
Ans. 
I have extensive experience with API integration in Thoughtspot.
• Developed custom API integrations to pull data from external sources into Thoughtspot

• Utilized Thoughtspot's REST API to automate data loading and report generation

• Worked closely with IT teams to troubleshoot and optimize API connections
Answered by AI
Add your answer

Q1. Write sql query
Ans. 
SQL query to retrieve total sales amount for each product category
• Use GROUP BY clause to group the results by product category

• Use SUM() function to calculate the total sales amount

• Join the tables if necessary to get the required data
Answered by AI
Add your answer
Q2. Tell your exp it
Ans. 
I have 3 years of experience working as a Data Analyst in the finance industry.
• Utilized SQL to extract and analyze data from databases

• Created visualizations using Tableau to present findings to stakeholders

• Performed predictive modeling using Python to forecast financial trends
Answered by AI
Add your answer

Q1. Asked about skillsets & tools used in the current job. I was asked basic questions on SQL & Tableau
Add your answer

Detailed interview on SQL, Tableau & Alteryx

Q1. Base on SQL and tableau
Add your answer
Q2. How join work share in detail with examples
Add your answer
Q3. How to get nth salary
Add your answer
Q4. How to delete duplicates
Ans. 
To delete duplicates, use SQL query with DISTINCT keyword or remove duplicates programmatically in Python using sets.
• Use SQL query with DISTINCT keyword to remove duplicates from a database table

• In Python, remove duplicates from a list using sets: list(set(original_list))

• For pandas DataFrame, drop duplicates using df.drop_duplicates()
Answered by AI
Add your answer

Q1. Live coding on the platform
Add your answer

Q1. Different joins
Add your answer
Q2. Case study
Add your answer

Revenue impact for casino

Logical reasoning ,quantitative aptitude

2 coding questions,one was easy and other was medium to tough level

Q1. Sql basics were asked and asked me to write few sql codes
Add your answer
Q2. Python codes ,and machine learning concepts
Add your answer

Q1. Get the maximum salary of the employee from the employee and department table
Add your answer
Q2. Explain the data analysis process that you would follow for employee salary table
Ans. 
The data analysis process for an employee salary table involves data cleaning, exploration, visualization, and modeling.
• Start by cleaning the data to remove any duplicates, missing values, or outliers.

• Explore the data by calculating basic statistics like mean, median, and standard deviation.

• Visualize the data using histograms, box plots, or scatter plots to identify patterns or trends.

• Perform statistical modeling to an...read more
Answered by AI
Add your answer
Q3. Explain the challenges you faced in your project
Ans. 
I faced challenges in managing large datasets and ensuring data accuracy in my project.
• Managing large volumes of data from multiple sources

• Ensuring data accuracy and consistency

• Dealing with missing or incomplete data

• Handling data cleaning and preprocessing tasks

• Addressing technical issues with data storage or processing tools
Answered by AI
Add your answer

Q1. SQL and powerbi questions
Add your answer