London Stock Exchange Group Data Analyst Interview Questions and Answers

Q1. Explain Data types in SQL?
Ans. 
Data types in SQL define the type of data that can be stored in a column of a table.
• Data types include integer, float, text, date, boolean, etc.

• Each data type has specific properties and constraints.

• Examples: INT for integers, VARCHAR for variable-length character strings.
Answered by AI
Add your answer
Q2. Explain the difference between DBMS and RDBMS?
Ans. 
DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.
• DBMS stands for Database Management System, which is a software system that allows users to interact with a database.

• RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.

• RDBMS e...read more
Answered by AI
Add your answer

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. Question related to SQL.
Add your answer
Q2. Concept of Data Warehousing.
Ans. 
Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.
• Data warehousing involves extracting data from multiple sources and consolidating it into a central repository.

• It is used for analytical reporting, business intelligence, and decision-making purposes.

• Data warehouses are designed for query and analysis rather than transaction processing.

• Examples of d...read more
Answered by AI
Add your answer

It contained python coding questions as well as machine learning questions

Q1. Sql joins, python codes
Add your answer
Q2. Complete codes and correct erros
Add your answer
Q3. Machine learning
Add your answer

Case study related to my project and background and internship

We started with our friends who is Business associate of Motilal Oswal finance services and those 2 friends are take brokership of financial firm, I was already there as a Tech Guy and Reasearcher for Stock Market and Fundamental Analytics , conducted more than 100 stocks analysis to advise clients to reduce the risk.

Q1. We friends just do a group discussion for the customer relationship
Add your answer
Q2. Investment and products related interview
Add your answer