Upload Button Icon Add office photos

Fractal Analytics

Compare button icon Compare button icon Compare

Filter interviews by

Fractal Analytics Consultant Interview Questions and Answers

Updated 15 May 2025

8 Interview questions

A Consultant was asked 8mo ago
Q. How do you handle JSON data in Python?
Ans. 

Python provides built-in libraries like json to handle JSON data easily.

  • Use json module to load and parse JSON data

  • Use json.dumps() to convert Python objects into JSON strings

  • Use json.loads() to convert JSON strings into Python objects

A Consultant was asked 12mo ago
Q. What are the scopes of GA3?
Ans. 

GA3 is a plant hormone that regulates various growth processes in plants.

  • Regulates seed germination

  • Promotes stem elongation

  • Influences flowering and fruit development

  • Used in agriculture to increase crop yield

  • Can be applied externally to plants to induce growth responses

Consultant Interview Questions Asked at Other Companies

asked in Accenture
Q1. An international bank (US based) has been operating in Asia for t ... read more
asked in Deloitte
Q2. How would you record travel expenses incurred and paid by an empl ... read more
asked in BCG
Q3. A telecom company with product X, a necessity in the industry, ha ... read more
asked in EXL Service
Q4. You have 20 red balls, 14 blue balls. You draw out balls, 2 at a ... read more
Q5. If an annual policy, billed monthly, is cancelled in June due to ... read more
A Consultant was asked 12mo ago
Q. What is a data layer?
Ans. 

A data layer is a software component that separates the data access logic from the business logic in an application.

  • It acts as an intermediary between the database and the application's business logic

  • Helps in managing data access, storage, and retrieval

  • Improves scalability and maintainability of the application

  • Examples include ORM frameworks like Hibernate in Java or Entity Framework in .NET

A Consultant was asked
Q. How familiar are you with fractals?
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.

A Consultant was asked
Q. What is your reason for switching jobs?
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

A Consultant was asked
Q. How can you derive a percentage share in Power BI?
Ans. 

To derive % share in Power BI, use the 'Group By' function and create a measure using the 'Divide' function.

  • Use the 'Group By' function to group the data by the desired category

  • Create a measure using the 'Divide' function to calculate the percentage share

  • Add the measure to a visual to display the % share

  • Example: = DIVIDE(SUM(Sales[Revenue]), CALCULATE(SUM(Sales[Revenue]), ALL(Sales)))

A Consultant was asked
Q. What are the differences between the SUM and SUMX functions in Power BI?
Ans. 

Sum and SumX are DAX functions used in Power BI to calculate the sum of values in a column or table.

  • Sum calculates the sum of values in a column or table.

  • SumX calculates the sum of an expression evaluated for each row in a table.

  • Both functions can be used in measures and calculated columns.

  • Example: Sum(Sales[Revenue]) calculates the total revenue for the Sales table.

  • Example: SumX(Orders, [Quantity]*[Price]) calcul...

Are these interview questions helpful?
A Consultant was asked
Q. 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...

Fractal Analytics Consultant Interview Experiences

26 interviews found

Consultant Interview Questions & Answers

user image Anonymous

posted on 17 Jan 2025

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Questions were all related to the role i.e Market Mix Modeling . Structure of a model, types of KPI that are reported to Client ( ROI, effectiveness etc), Statistical parameters to verify model, how to fin...
Round 2 - Technical 

Consultant Interview Questions & Answers

user image Anonymous

posted on 29 Oct 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Pandas based basic Data Manipulation Tasks
  • Q2. Handling Jsons in python
  • Ans. 

    Python provides built-in libraries like json to handle JSON data easily.

    • Use json module to load and parse JSON data

    • Use json.dumps() to convert Python objects into JSON strings

    • Use json.loads() to convert JSON strings into Python objects

  • Answered by AI

Skills evaluated in this interview

Consultant Interview Questions & Answers

user image Nida Hayath

posted on 14 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What are the scopes of GA3
  • Ans. 

    GA3 is a plant hormone that regulates various growth processes in plants.

    • Regulates seed germination

    • Promotes stem elongation

    • Influences flowering and fruit development

    • Used in agriculture to increase crop yield

    • Can be applied externally to plants to induce growth responses

  • Answered by AI
  • Q2. What is a data layer
  • Ans. 

    A data layer is a software component that separates the data access logic from the business logic in an application.

    • It acts as an intermediary between the database and the application's business logic

    • Helps in managing data access, storage, and retrieval

    • Improves scalability and maintainability of the application

    • Examples include ORM frameworks like Hibernate in Java or Entity Framework in .NET

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Salary negotiation
  • Q2. What is your notice period

Skills evaluated in this interview

Consultant Interview Questions & Answers

user image Anonymous

posted on 25 May 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Consisted of MCQs on Python and SQL

Round 2 - Technical 

(1 Question)

  • Q1. Based on job experience

Consultant Interview Questions & Answers

user image Anonymous

posted on 30 Apr 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL and Python basic questions

Round 2 - Technical 

(2 Questions)

  • Q1. Problem solving questions
  • Q2. SQL query on 2nd largest
  • Ans. 

    Use a subquery to find the 2nd largest value in a SQL table.

    • Use a subquery to find the maximum value in the table

    • Exclude the maximum value from the results to find the 2nd largest value

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Culture fit questions

Skills evaluated in this interview

Consultant Interview Questions & Answers

user image Anonymous

posted on 6 Mar 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Job Portal and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

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

Round 2 - Group Discussion 

Tooics are given from businesses and case study

Consultant Interview Questions & Answers

user image Mohammed Ayaz

posted on 25 Feb 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Feb 2023. There were 4 interview rounds.

Round 1 - One-on-one 

(2 Questions)

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

6-8 questions on SQL and Python

Round 3 - One-on-one 

(1 Question)

  • Q1. An overview on all the projects I have worked on and my knowledge on domain
Round 4 - HR 

(3 Questions)

  • Q1. Strength and Weakness
  • Q2. Reason to switch
  • Q3. Negotiations on salary

Interview Preparation Tips

Topics to prepare for Fractal Analytics Consultant interview:
  • SQL
  • Python
  • Pandas
  • Pharma
Interview preparation tips for other job seekers - Please be thorough with the profile you are applying for and the domain in which you have relevant experience.

Consultant Interview Questions & Answers

user image Anonymous

posted on 7 Jan 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • 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...
  • 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...

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • 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...
Round 4 - HR 

(1 Question)

  • Q1. Salary Discussion and stuff related to that

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand Basic Concepts of MMM thoroughly. Try to prepare end to end solution i.e. from data processing to recommendation to the client.

Consultant Interview Questions & Answers

user image Anonymous

posted on 16 Mar 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview before Mar 2023.

Round 1 - One-on-one 

(1 Question)

  • Q1. More about what you have been doing in past role
Round 2 - One-on-one 

(1 Question)

  • 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
Round 3 - HR 

(1 Question)

  • Q1. To check culture fit with the org

Consultant Interview Questions & Answers

user image Anonymous

posted on 23 Aug 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Python plus SQL , machine learning,mmm
Round 3 - Case Study 

Case study on different aspects of analytics

Top trending discussions

View All
Interview Tips & Stories
6d (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about Fractal Analytics?
Ask anonymously on communities.

Fractal Analytics Interview FAQs

How many rounds are there in Fractal Analytics Consultant interview?
Fractal Analytics interview process usually has 2-3 rounds. The most common rounds in the Fractal Analytics interview process are Technical, HR and One-on-one Round.
How to prepare for Fractal Analytics Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Fractal Analytics. The most common topics and skills that interviewers at Fractal Analytics expect are SQL, Python, Analytics, Analytical and Project Management.
What are the top questions asked in Fractal Analytics Consultant interview?

Some of the top questions asked at the Fractal Analytics Consultant interview -

  1. What is adstock, decay, Due tos Contributions? How do you evaluate the model? ...read more
  2. How can you derive (%share) in power...read more
  3. How do we use statistics to.solve analytical probl...read more
What are the most common questions asked in Fractal Analytics Consultant HR round?

The most common HR questions asked in Fractal Analytics Consultant interview are -

  1. What are your salary expectatio...read more
  2. Share details of your previous j...read more
How long is the Fractal Analytics Consultant interview process?

The duration of Fractal Analytics Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Overall Interview Experience Rating

4.6/5

based on 15 interview experiences

Difficulty level

Easy 10%
Moderate 90%

Duration

Less than 2 weeks 80%
2-4 weeks 20%
View more

Interview Questions from Similar Companies

MathCo Interview Questions
3.0
 • 116 Interviews
Zeta Interview Questions
3.4
 • 74 Interviews
Kiya.ai Interview Questions
3.4
 • 50 Interviews
CoinDCX Interview Questions
3.8
 • 31 Interviews
MoEngage Interview Questions
3.9
 • 27 Interviews
Seclore Interview Questions
4.0
 • 27 Interviews
Demandbase Interview Questions
3.8
 • 18 Interviews
View all
Fractal Analytics Consultant Salary
based on 1.2k salaries
₹11.3 L/yr - ₹20 L/yr
5% more than the average Consultant Salary in India
View more details

Fractal Analytics Consultant Reviews and Ratings

based on 155 reviews

4.0/5

Rating in categories

4.0

Skill development

4.2

Work-life balance

3.3

Salary

4.2

Job security

4.1

Company culture

3.1

Promotions

3.6

Work satisfaction

Explore 155 Reviews and Ratings
Consultant
1.2k salaries
unlock blur

₹11.3 L/yr - ₹20 L/yr

Data Engineer
948 salaries
unlock blur

₹9 L/yr - ₹23.5 L/yr

Senior Consultant
742 salaries
unlock blur

₹20 L/yr - ₹34.4 L/yr

Data Scientist
581 salaries
unlock blur

₹14 L/yr - ₹25 L/yr

Senior Data Scientist
350 salaries
unlock blur

₹22 L/yr - ₹38 L/yr

Explore more salaries
Compare Fractal Analytics with

Kiya.ai

3.4
Compare

MathCo

3.0
Compare

Innovatiview India Ltd

3.9
Compare

Zeta

3.4
Compare
write
Share an Interview