Fractal Analytics Consultant Interview Questions, Process, and Tips

Aptitude test are basically asked from reasonable and patterns type questions.

Tooics are given from businesses and case study

Q1. Questions related to Pharma domain about patient/hcp activity table, HIT targeting project end to end implementation, raw data cleaning and filtering etc.
Add your answer
Q2. Basic SQL question based on a sample data given which will be used as a backend for a visualisation
Add your answer

6-8 questions on SQL and Python

Q1. An overview on all the projects I have worked on and my knowledge on domain
Add your answer

Q1. Strength and Weakness
Add your answer
Q2. Reason to switch
Ans. 
Seeking new challenges and opportunities for growth
• Desire to work on more diverse projects

• Opportunity for career advancement

• Seeking a better work-life balance

• Interested in learning new skills or technologies
Answered by AI
Add your answer
Q3. Negotiations on salary
Add your answer

Q1. I was provided with a Marketing Mix Model problem statement and I have to provide the complete solution in excel and powerpoint presentation. In first round, The Question were all around my previous projec...read more
Add your answer
Q2. What is adstock, decay, Due tos Contributions? How do you evaluate the model? What is seasonality and the formula for seasonality? Do seasonality have any contribution?
Ans. 
Explanation of adstock, decay, Due tos Contributions, seasonality and its formula.
• Adstock is the measure of the lasting impact of advertising on consumer behavior.

• Decay refers to the reduction in the effectiveness of advertising over time.

• Due tos Contributions is the attribution of sales to different marketing channels.

• Seasonality is the pattern of sales or other metrics that repeat over a fixed period of time.

• The form...read more
Answered by AI
Add your answer

Q1. Second round was improvement on the model provided by me as the solution for MMM question. Technical questions were more on reasoning for the variables selected and understanding of the concepts of MMM. L...read more
Add your answer

Q1. Salary Discussion and stuff related to that
Add your answer

Q1. More about what you have been doing in past role
Add your answer

Q1. How much you know about fractal
Ans. 
Fractals are complex geometric shapes that can be split into parts, each of which is a reduced-scale copy of the whole.
• Fractals exhibit self-similarity, meaning they look similar at any scale or magnification.

• Examples of fractals include the Mandelbrot set, Koch snowflake, and Sierpinski triangle.

• Fractals are used in various fields such as mathematics, computer graphics, and art.
Answered by AI
Add your answer

Q1. To check culture fit with the org
Add your answer

Q1. Python plus SQL , machine learning,mmm
Add your answer

Case study on different aspects of analytics

Q1. Write SQL queries for given scenario
Ans. 
Writing SQL queries for a given scenario
• Use SELECT statement to retrieve data from tables

• Use WHERE clause to filter data based on specific conditions

• Use JOIN clause to combine data from multiple tables
Answered by AI
Add your answer
Q2. Simple queries initially, sub queries and CTEs will be touched in later part, window functions and extensive usage of joins will also be checked
Add your answer
Q3. Test test test test?
Add your answer

Q1. Engagement manager round will have a case study
Add your answer
Q2. Mostly case study related to some of the practice will be asked, mostly CPG
Add your answer