Quinte Financial Technologies Data Analyst Interview Questions, Process, and Tips

2 SQL Leet code challenge questions and 1 Python program.

Q1. Basics of SQL, Python and Tableau
Add your answer
Q2. How to select consecutive data from a column
Ans. 
Use SQL query with window functions like ROW_NUMBER() to select consecutive data from a column
• Use ROW_NUMBER() to assign a unique number to each row based on a specific order

• Use a self join or subquery to compare the row numbers of consecutive rows

• Filter the rows where the row numbers are consecutive to select the consecutive data
Answered by AI
Add your answer
Q3. Write a select query to find highest unique number in a column
Ans. 
Use a subquery to find the highest number that appears only once in a column
• Use a subquery to filter out numbers that appear more than once

• Order the results in descending order and select the top 1
Answered by AI
Add your answer

Q1. About previous experiences
Add your answer
Q2. About previous projects
Add your answer

Q1. Examples of SQL joins
Ans. 
SQL joins are used to combine data from two or more tables based on a related column between them.
• INNER JOIN: returns only the matching rows from both tables

• LEFT JOIN: returns all rows from the left table and matching rows from the right table

• RIGHT JOIN: returns all rows from the right table and matching rows from the left table

• FULL OUTER JOIN: returns all rows from both tables, with NULL values for non-matching rows

• CR...read more
Answered by AI
Add your answer
Q2. Difference between blend and join in Tableau
Ans. 
Blend combines data from different data sources while Join combines data from the same data source.
• Blend is used when data sources have different levels of detail.

• Join is used when data sources have the same level of detail.

• Blend creates a new virtual table while Join adds columns to an existing table.

• Example of Blend: Combining sales data from Excel and customer data from Salesforce.

• Example of Join: Combining sales da
Answered by AI
Add your answer
Q3. DIfference between Live data and extract data in Tableau
Ans. 
Live data is real-time data that is constantly updated, while extract data is a static subset of data.
• Live data is connected to a data source and updates in real-time as the source changes.

• Extract data is a static subset of data that is created by filtering and aggregating live data.

• Live data is useful for real-time analysis and monitoring, while extract data is useful for creating static reports and dashboards.

• Extract...read more
Answered by AI
Add your answer