i
BeeHyv
Filter interviews by
I applied via Approached by Company and was interviewed in Aug 2024. There were 6 interview rounds.
Power BI optimization techniques involve data model optimization, query optimization, and report design best practices.
Optimize data model by removing unnecessary columns and relationships
Use query folding to push data transformation tasks to the data source
Avoid using calculated columns and instead use measures for calculations
Limit the use of visuals that require high computational resources
Use aggregations and compo
Handling large datasets involves optimizing storage, processing, and analysis techniques.
Use distributed computing frameworks like Hadoop or Spark to process data in parallel.
Utilize data compression techniques to reduce storage requirements.
Implement indexing and partitioning strategies to improve query performance.
Consider using cloud-based storage and computing resources for scalability.
Use sampling techniques to wo
Parameters are variables that can be passed into a function or procedure to customize its behavior.
Parameters are defined when creating a function or procedure.
They can be used to pass values into the function or procedure.
Parameters can be required or optional, with default values specified.
They help make functions more flexible and reusable.
Example: def calculate_area(length, width):
Calculating values using DAX in Power BI
Use SUMX function to calculate sum of values in a column
Use CALCULATE function to apply filters and conditions to calculations
Use DAX measures to create reusable calculations
Example: Calculate total sales for a specific product category
Creating data model and visualizations involves structuring data and presenting it visually.
Identify the key variables and relationships in the data
Design a data model that represents the data structure
Select appropriate visualization tools and techniques
Create visualizations such as charts, graphs, and dashboards
Ensure the visualizations effectively communicate insights from the data
Was asked questions on Permutations and Combinations like the once you see in Math Olympiads.
Top trending discussions
I applied via Company Website and was interviewed in Mar 2024. There were 2 interview rounds.
Good questions. 3 SQL case studies at end
I applied via Approached by Company and was interviewed in Aug 2024. There were 3 interview rounds.
AB testing is a method used to compare two versions of a webpage or app to determine which one performs better.
AB testing involves creating two versions (A and B) of a webpage or app with one differing element
Users are randomly assigned to either version A or B to measure performance metrics
The version that performs better in terms of the desired outcome is selected for implementation
Example: Testing two different call...
It was a classification problem
I have worked on projects involving data analysis, visualization, and predictive modeling.
Developed predictive models using machine learning algorithms
Performed data cleaning and preprocessing to ensure data quality
Created interactive dashboards for data visualization
Collaborated with cross-functional teams to derive insights from data
I applied via campus placement at Sastra University and was interviewed in Mar 2024. There were 2 interview rounds.
Well designed to test the aptitude competence of the candidate.
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
I applied via Company Website and was interviewed before May 2020. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before May 2021. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Use conditional formatting to highlight odd cells in Excel
Select the range of cells you want to highlight
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose 'New Rule' and select 'Use a formula to determine which cells to format'
Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)
Choose the formatting style you want for the odd cells
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FU...
Use window function to calculate running sum of salary in SQL
Use window function like SUM() with OVER() clause
Partition the data by employee ID if needed
Order the data by date or any other relevant column
based on 1 interview
Interview experience
Software Developer
88
salaries
| ₹6 L/yr - ₹18 L/yr |
Software Engineer
15
salaries
| ₹8 L/yr - ₹14 L/yr |
Developer
14
salaries
| ₹6 L/yr - ₹11 L/yr |
Software Developer Trainee
8
salaries
| ₹6.3 L/yr - ₹8 L/yr |
Full Stack Developer
8
salaries
| ₹7.1 L/yr - ₹16 L/yr |
Persistent Systems
TCS
Infosys
Wipro