Walking Tree Power BI Developer Interview Questions and Answers

Q1. What are the types of data set you have worked upon?
Ans. 
I have worked on various types of data sets including sales data, customer data, financial data, and social media data.
• Sales data

• Customer data

• Financial data

• Social media data
Answered by AI
Add your answer
Q2. Write dax for delta sales growth
Ans. 
Calculate delta sales growth using DAX formula
• Use the following DAX formula: Delta Sales Growth = (SUM(Sales[SalesAmount]) - CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSMONTH('Date'[DateKey]))) / CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSMONTH('Date'[DateKey]))

• Make sure to replace 'Sales[SalesAmount]' with the actual column name in your dataset

• Ensure that 'Date'[DateKey]' is the date column in your dataset
Answered by AI
Add your answer

Q1. Basic questions related sql , power bi project details , dax functions (1-2 scenerios)
Add your answer

Aptitude test

Current affairs

Q1. Puzzle , sql related questions
Add your answer

Easy to medium leetcode questions

Q1. Tell me about your self
Add your answer
Q2. Write a for palindrome
Add your answer
Q3. SQL inner Joins
Add your answer
Q4. Object orientend programming
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

The round had quantitative questions along with some logical reasoning and english section and fundamentals of DBMS ,OS and Data structures and some other such topics

Q1. Can you explain the various disk scheduling algorithms used in operating systems?
Ans. 
Disk scheduling algorithms manage the order in which read/write requests are serviced on a disk.
• Common disk scheduling algorithms include FCFS, SSTF, SCAN, C-SCAN, LOOK, and C-LOOK.

• FCFS (First-Come, First-Served) serves requests in the order they arrive.

• SSTF (Shortest Seek Time First) prioritizes the request closest to the current head position.

• SCAN moves the disk arm from one end to the other, serving requests along t...read more
Answered by AI
View 1 more answer

Round duration - 90 minutes
Round difficulty - Medium

The editor and the environment was great and not disturbing like many have.
They had their own test cases to check the scope of our code.

Q1. 
Maximum Subarray Sum Problem Statement
Given an array of numbers, the task is to find the maximum sum of any contiguous subarray of the array.
Input:
The first line of input contains the size of the arr...read more
Ans. 
Find the maximum sum of any contiguous subarray in an array of numbers in O(N) time.
• Use Kadane's algorithm to find the maximum subarray sum in O(N) time.

• Initialize two variables: maxEndingHere and maxSoFar to keep track of the maximum sum.

• Iterate through the array and update the variables accordingly.

• Return the maxSoFar as the result.
Answered by AI
Add your answer

Round duration - 40 minutes
Round difficulty - Medium

It had only mcq questions but we could not navigate through the questions it had some reasoning and some dbms topics along with data structure ,memory ,cache memory and other topics

Q1. How do you find the age of an employee from the personal details table in SQL?
Ans. 
To find the age of an employee from the personal details table in SQL, you can calculate the difference between the current date and the employee's birthdate.
• Use the DATEDIFF function in SQL to calculate the difference between the current date and the employee's birthdate.

• Divide the result by 365 to get the age in years.

• Consider leap years for more accurate results.
Answered by AI
Add your answer

Round duration - 10 minutes
Round difficulty - Medium

The interviewer was polite and asked few questions from data structures and some from DBMS and some web question and about my project.

Q1. What is the difference between a primary key and a candidate key in a database management system?
Ans. 
Primary key uniquely identifies a record in a table, while candidate key can also uniquely identify a record but is not chosen as primary key.
• Primary key is chosen as the main unique identifier for a table

• Candidate key is a unique key that could also be chosen as primary key

• A table can have multiple candidate keys but only one primary key

• Example: In a table of students, 'student_id' could be a primary key while 'email'...read more
Answered by AI
Add your answer

Round duration - 12 minutes
Round difficulty - Medium

The interviewer asked me about my project and told me to describe myself in one word and justify that and asked my personal skills and asked some technical questions as well

Q1. What is pickling?
Ans. 
Pickling is a process of preserving or extending the shelf life of food by storing it in a solution of salt, vinegar, or brine.
• Pickling involves submerging food in a solution of salt, vinegar, or brine to preserve it.

• Common examples of pickled foods include cucumbers (pickles), onions, and cabbage.

• Pickling can also enhance the flavor of food by infusing it with spices and herbs.

• The acidity of the pickling solution help...read more
Answered by AI
Add your answer