Fractal Analytics Interview Questions, Process, and Tips

Q1. Questions on tomcat, java., spring
Add your answer

Q1. Q on OOPS, Resume based projects in detail
Add your answer

Q1. Standard HR questions
Add your answer

SQL Test
3 questions for Solution using SQL queries.

Q1. SQL queries using window function
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate values based on a specific subset of rows within a table.

• They are commonly used with aggregate functions like SUM, AVG, and COUNT.

• Examples of window functions include ROW_NUMBER(), RANK(), and NTILE().
Answered by AI
Add your answer
Q2. Resume questions
Add your answer
Q3. Past experience
Add your answer
Q4. KPI that you have created
Ans. 
I created a KPI to measure customer retention rate.
• Developed formula to calculate percentage of customers retained over a specific period

• Monitored customer churn rate to track effectiveness of retention strategies

• Analyzed customer feedback and behavior to identify factors influencing retention

• Implemented initiatives to improve customer retention based on data insights
Answered by AI
Add your answer

Easy and based on sql questions

Q1. SQL, DAX, Power Bi, Modelling
Add your answer

Q1. SQL, DAX, Power Bi, Project Execution
Add your answer

Q1. General HR Questions, and company related.
Add your answer