Fractal Analytics Data Analyst Interview Questions and Answers

Q1. What are the SQL commands can you explain it
Ans. 
SQL commands are used to interact with databases to perform various operations like querying, updating, and deleting data.
• SELECT: Retrieves data from a database

• INSERT INTO: Adds new records to a table

• UPDATE: Modifies existing records in a table

• DELETE: Removes records from a table

• CREATE TABLE: Creates a new table in the database

• ALTER TABLE: Modifies an existing table structure

• DROP TABLE: Deletes a table from the databas
Answered by AI
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

Basic quants test had to attend.

The platform used was Deselect, which featured questions on Python, SQL, and aptitude.

Q1. Asked some python and sql questions.
Add your answer
Q2. Questions regarding sql joins, having where clause.
Add your answer
Q3. Some machine learning questions on regression, classification, confusion matrix, assumptions of linear regression, how bagging boosting works.
Add your answer

Q1. Asked questions related to projects mentioned in resume
Add your answer
Q2. Asked me to explaind the credit card fraud detection project end to end.
Add your answer