Hexaware Technologies Data Analyst Interview Questions and Answers

Q1. Basis HR questions
Add your answer
Q2. Answer confidently
Add your answer

Q1. Based on previous work
Add your answer
Q2. Answer correctly what you had worked in your previous work
Add your answer

Q1. Related to market,trending hotels,car selling websites etc
Add your answer
Q2. Nothing else was asked
Add your answer

Focus on data intrepration

Q1. Okay but not that tough
Add your answer

Q1. What is sql
Ans. 
SQL (Structured Query Language) is a standard programming language for managing and manipulating relational databases.
• SQL is used to query, insert, update, and delete data in databases. Example: SELECT * FROM users;

• It allows for data definition and manipulation through commands like CREATE, ALTER, and DROP. Example: CREATE TABLE orders (id INT, amount DECIMAL);

• SQL supports complex queries with JOIN operations to combin...read more
Answered by AI
Add your answer
Q2. Data warehouse in sql
Ans. 
A data warehouse is a centralized repository for storing and analyzing large volumes of structured and unstructured data.
• Data warehouses integrate data from multiple sources, such as databases, CRM systems, and flat files.

• They support complex queries and data analysis, enabling businesses to make informed decisions.

• Data is organized in a star or snowflake schema, optimizing query performance.

• ETL (Extract, Transform, Lo...read more
Answered by AI
Add your answer

Q1. Sql basic questions - join , index, optimisation
Add your answer

Q1. Basic non technical With director
Add your answer