AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
BeeHyv
Compare
Filter interviews by
BeeHyv Interview Questions and Answers
12 Interview questions
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):
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
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
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 ...
Calculate the rolling sum of sales using SQL window functions for cumulative totals over a specified period.
Use the SUM() function with the OVER() clause to calculate rolling sums.
Example: SELECT date, sales, SUM(sales) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS rolling_sum FROM sales_data;
You can adjust the window frame to specify different periods, e.g., LAST 7 DAYS.
Ensure your data...
Retrieve current and previous month sales in a single row using SQL or data manipulation techniques.
Use SQL with a CASE statement to differentiate between current and previous month sales.
Example SQL: SELECT SUM(sales) AS current_month_sales, SUM(CASE WHEN MONTH(date) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH) THEN sales END) AS previous_month_sales FROM sales_table WHERE YEAR(date) = YEAR(CURRENT_DATE);
Alternativel...
The longest palindrome in a given string is the longest sequence of characters that reads the same forwards and backwards.
Iterate through each character in the string
For each character, expand outwards to find the longest palindrome centered at that character
Keep track of the longest palindrome found so far
Return the longest palindrome
Print a pattern as shown below.
Use nested loops to iterate through rows and columns.
Use conditional statements to determine the pattern to be printed.
Store each row as a string in an array of strings.
Probability of a point making an obtuse angle inside a trapezium with one side.
The point must lie inside the trapezium.
The trapezium must have one side that is not parallel to the other.
Use trigonometry to calculate the angles of the trapezium.
Calculate the probability of the point making an obtuse angle using the angles of the trapezium.
Finding the 2000th term of a sequence involves identifying the pattern or formula governing the sequence.
Identify the sequence type (arithmetic, geometric, etc.).
For arithmetic sequences, use the formula: a_n = a_1 + (n-1)d.
For geometric sequences, use: a_n = a_1 * r^(n-1).
Example: For the sequence 2, 4, 6, 8 (arithmetic), the 2000th term is 2 + (2000-1)*2 = 4000.
Example: For the sequence 3, 6, 12, 24 (geometric),...
BeeHyv Interview Experiences
23 interviews found
Anonymous
I applied via Approached by Company and was interviewed in Aug 2024. There were 6 interview rounds.
(1 Question)
- Q1. Power BI optimization techniques.
- Ans.
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...
(3 Questions)
- Q1. How to handle large datasets.
- Ans.
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...
- Q2. How to use parameters.
- Ans.
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):
- Q3. Row lovel Security.
(2 Questions)
- Q1. SQL interview. How to get the rolling sum of sales.
- Ans.
Calculate the rolling sum of sales using SQL window functions for cumulative totals over a specified period.
Use the SUM() function with the OVER() clause to calculate rolling sums.
Example: SELECT date, sales, SUM(sales) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS rolling_sum FROM sales_data;
You can adjust the window frame to specify different periods, e.g., LAST 7 DAYS.
Ensure your data is o...
- Q2. Get current month and previous month sales in same row.
(3 Questions)
- Q1. Gateway. Refresh, Incremental Refresh and other service related.
- Q2. Write DAX to calculate some values.
- Ans.
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
- Q3. Create data model and visualizations.
- Ans.
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.
(1 Question)
- Q1. Asked about past project experience.
Interview Preparation Tips
- Power Bi
- SQL
- Python
- Data Modeling
- schema creation
- Optimization
Skills evaluated in this interview
Selected
(2 Questions)
- Q1. Questions are based on aptitude
- Q2. Questions are based in puzzles and aptitude for freshers
Questions were based on aptitude
Basic Python questions.
Basic aptitude questions.
Selected
I applied via Campus Placement and was interviewed in Dec 2023. There were 3 interview rounds.
Mensuration , P and C
(3 Questions)
- Q1. Basics syntax of python and some simple coding questions
- Q2. Find the longest palindrome in the given string:?
- Ans.
The longest palindrome in a given string is the longest sequence of characters that reads the same forwards and backwards.
Iterate through each character in the string
For each character, expand outwards to find the longest palindrome centered at that character
Keep track of the longest palindrome found so far
Return the longest palindrome
- Q3. Print the pattern as shown Below
- Ans.
Print a pattern as shown below.
Use nested loops to iterate through rows and columns.
Use conditional statements to determine the pattern to be printed.
Store each row as a string in an array of strings.
This is advance aptitude test where we are tested on some more difficut atpi questions
Interview Preparation Tips
Skills evaluated in this interview
Ashutosh
(2 Questions)
- Q1. Joins, normalization, cte
- Q2. Joins in python
- Ans.
Joins in Python are used to combine data from two or more tables based on a related column between them.
Joins are used in SQL to combine rows from two or more tables based on a related column between them.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
In Python, joins can be performed using libraries like pandas or SQLalchemy.
Example: df_merged = pd.merge(df1, df2, on='common_column', ho...
Skills evaluated in this interview
I applied via Campus Placement
The test was moderate and it have only 12 questions in 1 hr
(1 Question)
- Q1. The interview is also of aptitute where the interview will check your problem solving skills .
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
(1 Question)
- Q1. How you work on Excel and all
They give around 15 questions for Aptitude test
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed in Sep 2023. There were 2 interview rounds.
It was completely a math based test
(1 Question)
- Q1. There were math questions to solve
Selected
I applied via Campus Placement and was interviewed before Dec 2023. There were 5 interview rounds.
A one-hour exam consisting of easy to moderate aptitude questions.
Easy to moderate Python multiple-choice questions.
(1 Question)
- Q1. Aptitude Interview with the questions i failed to answer in exam
(1 Question)
- Q1. Python basic to moderate oops questions and dsa questions
(1 Question)
- Q1. Few moderate to hard aptitude questions and discussion with cto
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed in Nov 2022. There were 6 interview rounds.
Integer type answers must be written for the online test
The test can taken in any of the teo languages java and python. I took python test. It had python mcqs and few sql mcqs
(1 Question)
- Q1. Aptitude interview round
(1 Question)
- Q1. Coding interview round. Asked to write code in python for simple questions.
(1 Question)
- Q1. Advanced aptitude round
Interview Preparation Tips
Top trending discussions
BeeHyv Interview FAQs
The duration of BeeHyv interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
BeeHyv Interviews By Designations
- BeeHyv Software Developer Interview Questions
- BeeHyv Software Developer Trainee Interview Questions
- BeeHyv Developer Interview Questions
- BeeHyv Project Coordinator Interview Questions
- BeeHyv Trainee Developer Interview Questions
- BeeHyv Management Trainee Interview Questions
- BeeHyv Software Engineer Interview Questions
- BeeHyv Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Software Developer Trainee Interview Questions
- Team Lead Interview Questions
- Software Engineer Interview Questions
- Business Analyst Interview Questions
- Sales Executive Interview Questions
- Senior Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 14 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
|
Software Developer
108
salaries
|  ₹6 L/yr - ₹18 L/yr |
|
Developer
16
salaries
| ₹7 L/yr - ₹11 L/yr |
|
Software Engineer
14
salaries
| ₹8 L/yr - ₹14 L/yr |
|
Senior Software Engineer
12
salaries
| ₹21 L/yr - ₹31 L/yr |
|
Devops Engineer
9
salaries
| ₹7.5 L/yr - ₹14 L/yr |
Maxgen Technologies
JoulestoWatts Business Solutions
Value Point Systems
F1 Info Solutions and Services
- Home >
- Interviews >
- BeeHyv Interview Questions
