BeeHyv Interview Questions, Process, and Tips

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
Answered by AI
Add your answer

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
Answered by AI
Add your answer
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):
Answered by AI
Add your answer
Q3. Row lovel Security.
Add your answer

Q1. SQL interview. How to get the rolling sum of sales.
Add your answer
Q2. Get current month and previous month sales in same row.
Add your answer

Q1. Gateway. Refresh, Incremental Refresh and other service related.
Add your answer
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
Answered by AI
Add your answer
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
Answered by AI
Add your answer

Was asked questions on Permutations and Combinations like the once you see in Math Olympiads.

Q1. Asked about past project experience.
Add your answer

Q1. Questions are based on aptitude
Add your answer
Q2. Questions are based in puzzles and aptitude for freshers
Add your answer

Questions were based on aptitude

Basic Python questions.

Basic aptitude questions.

Mensuration , P and C

Q1. Basics syntax of python and some simple coding questions
Add your answer
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
Answered by AI
Add your answer
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.
Answered by AI
Add your answer

This is advance aptitude test where we are tested on some more difficut atpi questions

Q1. Joins, normalization, cte
Add your answer
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
Answered by AI
Add your answer

A one-hour exam consisting of easy to moderate aptitude questions.

Easy to moderate Python multiple-choice questions.

Q1. Aptitude Interview with the questions i failed to answer in exam
Add your answer

Q1. Python basic to moderate oops questions and dsa questions
Add your answer

Q1. Few moderate to hard aptitude questions and discussion with cto
Add your answer

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

Q1. Aptitude interview round
Add your answer

Q1. Coding interview round. Asked to write code in python for simple questions.
Add your answer

Q1. Advanced aptitude round
Add your answer