Eucloid Data Solutions Interview Questions and Answers

Q1. Write SQL aggregation and join queries.
Ans. 
SQL aggregation and join queries for data analysis.
• Use GROUP BY clause for aggregation

• Use aggregate functions like SUM, AVG, COUNT, etc.

• Use JOIN clause to combine data from multiple tables
Answered by AI
Add your answer
Q2. Name types of joins and explain them.
Add your answer
Q3. How would you import data in power bi using api?
Ans. 
You can import data in Power BI using API by connecting to the API endpoint and specifying the required parameters.
• Use the 'Get Data' option in Power BI to connect to the API endpoint

• Specify the required authentication method (e.g. API key, OAuth)

• Select the data you want to import and transform it as needed

• Refresh the data periodically to keep it up to date
Answered by AI
Add your answer
Q4. Extract number from stings in sql
Ans. 
Extract numbers from strings in SQL
• Use the SQL function REGEXP_REPLACE to remove non-numeric characters

• Use the SQL function REGEXP_SUBSTR to extract numbers from strings

• Consider using regular expressions to handle different number formats
Answered by AI
Add your answer

Q1. What are window functions in sql and explain in detail
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions operate on a set of rows related to the current row

• They can be used to calculate running totals, ranks, and averages

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

• They are typically used with the OVER() clause to define the window frame
Answered by AI
Add your answer
Q2. Difference between joins
Add your answer
Q3. What is order of execution in sql
Add your answer
Q4. Ways to write time efficient sql queries
Ans. 
Use indexes, limit columns in SELECT, avoid using SELECT *, optimize joins
• Use indexes on columns frequently used in WHERE clauses

• Limit columns in SELECT to only those needed

• Avoid using SELECT * to retrieve all columns

• Optimize joins by using INNER JOIN instead of OUTER JOIN when possible
Answered by AI
Add your answer

Q1. What are SQL joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• SQL joins are used to retrieve data from multiple tables based on a related column between them

• Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right ...read more
Answered by AI
Add your answer
Q2. What are the different window functions?
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions include ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, FIRST_VALUE, LAST_VALUE, and more

• They allow for calculations to be performed on a specific subset of rows within a query result set

• Window functions are commonly used in analytical queries to calculate running totals, moving averages, and more
Answered by AI
Add your answer

Q1. How will you identify the given two strings as anagram?
Ans. 
Anagrams are two strings that have the same characters in a different order.
• Check if the two strings have the same length.

• Sort the characters in both strings and compare if they are equal.

• Alternatively, count the frequency of characters in both strings and compare the counts.
Answered by AI
Add your answer
Q2. From a table with employee details and another table with order details, count the employees who ordered all the category items.
Ans. 
Count employees who ordered every item from all categories in two related tables.
• Join the employee and order tables on employee ID.

• Group by employee ID and count distinct categories ordered.

• Filter employees who have ordered items from all available categories.

• Example: If there are 3 categories and an employee ordered from all, count them.
Answered by AI
Add your answer

Q1. SQL queries were asked
Add your answer
Q2. Puzzle guesstimates MARKETING KPIS
Add your answer

Q1. Excel, python basic questions
Add your answer
Q2. Cohort analysis, average order value SQL questions
Add your answer

Q1. Case study round, puzzles
Add your answer
Q2. Question about ongoing project
Add your answer

Sql questions and queries were asked and also made to write the pseduo code along with case studies

Case studies related to guesstimates and aptitude test were asked