i
ClearTrail Technologies
Filter interviews by
I applied via Campus Placement and was interviewed before Nov 2020. There was 1 interview round.
I applied via LinkedIn and was interviewed in May 2021. There were 5 interview rounds.
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
Do select test
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 ...
I applied via LinkedIn and was interviewed before Aug 2021. There were 4 interview rounds.
A technical test for whatever technical round you are applying for. Will be conceptual test rather than hard/coded test
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)))
Test was very simple having 4 sql questions and 4 python questions. Total time given was 90 minutes.
Pyrhon questions was one liner code.
Sql questions was related to join, group by, where and order functions
I applied via Naukri.com and was interviewed in Dec 2022. There were 4 interview rounds.
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...
Case study on different aspects of analytics
I applied via Naukri.com and was interviewed before Sep 2023. There were 3 interview rounds.
Medium to difficult level
I applied via Job Portal and was interviewed in Feb 2024. There were 2 interview rounds.
Aptitude test are basically asked from reasonable and patterns type questions.
Tooics are given from businesses and case study
Software Engineer
72
salaries
| ₹5.5 L/yr - ₹23 L/yr |
Senior Software Engineer
50
salaries
| ₹9 L/yr - ₹30 L/yr |
Associate Software Engineer
31
salaries
| ₹3.8 L/yr - ₹8 L/yr |
Module Lead
15
salaries
| ₹15.7 L/yr - ₹36 L/yr |
Technical Support Engineer
13
salaries
| ₹5.3 L/yr - ₹11 L/yr |
Fractal Analytics
Subex
Innovatiview India Ltd
Watchyourhealth.com