Iksula Power BI Developer Interview Questions and Answers

Q1. Power bi troubleshooting Visualisation
Add your answer
Q2. Gateway Dax, sql queries
Add your answer

Power BI and SQL Coding

Q1. Salary discussion ........ TCS offer very low salary as per market standards
Add your answer
Q2. Normal Question like your family background
Add your answer
Q3. SQL and PLSQL Question
Add your answer
Q4. BI Question for RLS
Add your answer
Q5. MS Azure automation Question
Add your answer

Q1. What are the commands in sql
Ans. 
SQL commands are used to interact with databases and perform various operations like querying, updating, and deleting data.
• SELECT: Retrieves data from a database

• INSERT: Adds new records to a table

• UPDATE: Modifies existing records in a table

• DELETE: Removes records from a table

• CREATE TABLE: Creates a new table in the database

• ALTER TABLE: Modifies the structure of an existing table

• DROP TABLE: Deletes a table from the data
Answered by AI
Add your answer
Q2. Difference between having and where clause
Ans. 
HAVING clause is used with GROUP BY to filter grouped results, WHERE clause is used to filter individual rows
• HAVING clause is used with GROUP BY to filter grouped results

• WHERE clause is used to filter individual rows before grouping

• HAVING clause is used with aggregate functions like SUM, COUNT, AVG

• WHERE clause is used with conditions like =, >, <, IN
Answered by AI
Add your answer

Q1. What is the current Organisation
Ans. 
ABC Corporation is a multinational technology company specializing in software development and data analytics.
• ABC Corporation is known for its expertise in Power BI development.

• The company has a global presence with offices in multiple countries.

• ABC Corporation offers a wide range of software solutions for various industries.

• They have a strong focus on data analytics and provide advanced reporting and visualization too...read more
Answered by AI
View 2 more answers
Q2. What is the current CTC and Expected CTC
Ans. 
The current CTC and expected CTC are personal financial details and should not be disclosed in an interview.
• It is not appropriate to discuss personal financial details in an interview.

• Salary negotiations should be done after receiving a job offer.

• Focus on discussing your skills, experience, and qualifications for the Power BI Developer role.
Answered by AI
View 1 more answer

Q1. What is Row Level Security ?
Ans. 
Row Level Security is a feature in Power BI that allows you to restrict data access at the row level based on user roles and filters.
• Row Level Security (RLS) is used to control data access in Power BI based on user roles and filters.

• It allows you to define rules that determine which rows of data a user can see.

• RLS can be applied to tables or views in the data model.

• It is commonly used to restrict access to sensitive or...read more
Answered by AI
View 2 more answers
Q2. What is difference between SUM and SUMX?
Ans. 
SUM calculates the sum of a column or expression, while SUMX calculates the sum of an expression over a table.
• SUM is used to calculate the sum of a column or expression in Power BI.

• SUMX is used to calculate the sum of an expression over a table in Power BI.

• SUM is typically used with a column reference, while SUMX is used with an expression.

• SUMX can be used to perform calculations on filtered or modified data.

• Example: S...read more
Answered by AI
View 2 more answers
Q3. What is difference between calculate column and measures?
Ans. 
Calculated columns are computed during data loading, while measures are computed on the fly during data visualization.
• Calculated columns are created in the data model and stored in the underlying table.

• Measures are created using DAX expressions and are calculated dynamically based on the context of the visualization.

• Calculated columns consume memory and can impact performance, while measures are more efficient.

• Calculat...read more
Answered by AI
View 2 more answers

Q1. Present company last working day
Ans. 
The last working day of the company is the day on which an employee's employment ends.
• The last working day is typically determined by the company's policies and the employee's contract.

• It may be different for each employee depending on their notice period or reason for leaving.

• The last working day is usually communicated to the employee through an official letter or email.

• On the last working day, the employee may be re...read more
Answered by AI
Add your answer

Q1. Types of Joins in Power Query editor.
Ans. 
There are four types of joins in Power Query editor: Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join.
• Inner Join combines rows from two tables based on a matching column.

• Left Outer Join returns all rows from the left table and the matching rows from the right table.

• Right Outer Join returns all rows from the right table and the matching rows from the left table.

• Full Outer Join returns all rows from bot
Answered by AI
Add your answer
Q2. Types of transformations performed in Power QUERY EDITOR
Ans. 
Power Query Editor allows various transformations on data such as filtering, sorting, merging, splitting, and aggregating.
• Filtering: Removing rows based on certain criteria.

• Sorting: Arranging rows in a specific order.

• Merging: Combining multiple tables or queries into one.

• Splitting: Dividing a column into multiple columns.

• Aggregating: Calculating summary statistics like sum, average, count, etc.
Answered by AI
Add your answer