10+ Fractal Analytics Consultant Interview Questions and Answers

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 formula for seasonality is (Value in Period / Average Value of...read more

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)))

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.

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

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]) calculates the total sales for each order in the Orders table.

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

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

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