i
Polestar
Analytics
Filter interviews by
RLS stands for Row-Level Security, a feature in Power BI that restricts data access based on user roles.
RLS allows you to control which rows of data a user can access in a Power BI report or dashboard.
You can define security roles and rules to filter data based on user attributes or roles.
For example, you can set up RLS to only show sales data for a specific region to users in that region.
RLS helps ensure data sec...
The length of an array refers to the number of elements it contains.
Use the .length property to find the length of an array.
Example: let arr = ['apple', 'banana', 'orange']; arr.length will return 3.
Python script to calculate factorial of a number.
Create a function that takes a number as input.
Use a loop to multiply the number by decreasing integers until reaching 1.
Return the final result as the factorial of the input number.
Find missing number in array of strings
Convert strings to integers for comparison
Iterate through the array to find the missing number
Consider edge cases like empty array or multiple missing numbers
applymap is used to map a value from one table to another while join is used to combine two or more tables based on a common field.
applymap is used for one-to-one mapping while join is used for many-to-one mapping
applymap is faster than join for small datasets
join can handle more complex data relationships than applymap
applymap can be used to replace null values with a default value
join can be used to aggregate da...
SQL wildcards allow flexible pattern matching in queries, enhancing data retrieval capabilities.
Wildcards are used with the LIKE operator in SQL.
The '%' wildcard represents zero or more characters. Example: 'A%' matches 'Apple', 'Aardvark'.
The '_' wildcard represents a single character. Example: 'A_d' matches 'Add', 'Acd'.
Wildcards can be combined. Example: 'A%_d' matches 'Acd', 'Aed', but not 'Acds'.
Joins are used to combine data from two or more tables based on a related column.
Joins are used in SQL to retrieve data from multiple tables.
They are used to combine rows from two or more tables based on a related column.
There are different types of joins such as inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all the rows from the...
Comparing business analysis of two hypothetical companies under different scenarios
Company A is a tech startup with high growth potential but also high risk
Company B is a well-established retail chain with steady revenue but limited growth
Under a booming economy, Company A is likely to outperform Company B due to its growth potential
In a recession, Company B may fare better than Company A as consumers prioritize e...
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
It was a 60 minute aptitude test that had 60 qs to answer covering sections like quants, verbal, logical reasoning and some general programming. There was a 0.5 mark negative marking as well for each wrong answer. It was easy test
RLS stands for Row-Level Security, a feature in Power BI that restricts data access based on user roles.
RLS allows you to control which rows of data a user can access in a Power BI report or dashboard.
You can define security roles and rules to filter data based on user attributes or roles.
For example, you can set up RLS to only show sales data for a specific region to users in that region.
RLS helps ensure data security...
I appeared for an interview before Feb 2024.
In this round, you will encounter 40 questions, and you need to answer approximately 80% of them correctly.
I applied via Campus Placement and was interviewed before Nov 2023. There were 3 interview rounds.
Were give few aptitude question
Binary search can be adapted to find a target value with precision up to two decimal places in a sorted array.
Binary search works on sorted arrays, reducing the search space by half each iteration.
To find a value to two decimal places, set a precision limit (e.g., 0.01).
Calculate mid-point as (low + high) / 2 and check if it meets the precision requirement.
Example: Searching for square root of 2, start with low = 1, hi...
It was basic aptitude
Basic cosing questions
The length of an array refers to the number of elements it contains.
Use the .length property to find the length of an array.
Example: let arr = ['apple', 'banana', 'orange']; arr.length will return 3.
Dax queries, power bi en to end
I appeared for an interview before May 2024, where I was asked the following questions.
I applied via Naukri.com and was interviewed before Apr 2023. There were 2 interview rounds.
MCQ round, maths, logical, reasoning
Python script to calculate factorial of a number.
Create a function that takes a number as input.
Use a loop to multiply the number by decreasing integers until reaching 1.
Return the final result as the factorial of the input number.
I applied via Campus Placement
Basic Aptitude test, english questions, quant questions
Top trending discussions
The duration of Polestar Analytics interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 13 interview experiences
Difficulty level
Duration
based on 364 reviews
Rating in categories
Senior Analyst
139
salaries
| ₹5 L/yr - ₹20 L/yr |
Consultant
117
salaries
| ₹12.5 L/yr - ₹20 L/yr |
Analyst
71
salaries
| ₹3.3 L/yr - ₹11.9 L/yr |
Business Analyst
61
salaries
| ₹5 L/yr - ₹11 L/yr |
Senior Consultant
60
salaries
| ₹11.5 L/yr - ₹33 L/yr |
CMS IT Services
Quantiphi Analytics Solutions Private Limited
PrimEra Medical Technologies
Mavenir Systems