Nine A Business Connect Power BI Developer Interview Questions and Answers

Q1. What is the DAX formula for calculating a running total?
Ans. 
The DAX formula for calculating a running total is using the CALCULATE function with the FILTER function.
• Use the CALCULATE function to evaluate an expression in a context modified by filters.

• Use the FILTER function to return a table that represents a subset of another table or expression.

• Combine CALCULATE and FILTER functions to calculate a running total.
Answered by AI
Add your answer
Q2. What is the DAX formula for replacing blank values with zero and vice versa?
Ans. 
The DAX formula for replacing blank values with zero and vice versa is IF(ISBLANK(), 0, BLANK())
• Use the IF function in DAX to check if a value is blank

• If the value is blank, return 0. If not, return blank()
Answered by AI
Add your answer
Q3. SQL Queries for the above scenarios
Add your answer

Q1. What are your previous work experiences?
Ans. 
I have 3 years of experience as a Power BI Developer in a consulting firm.
• Developed interactive dashboards and reports using Power BI

• Worked closely with business stakeholders to gather requirements

• Optimized data models for performance and efficiency
Answered by AI
Add your answer
Q2. Salary negotiations etc.
Add your answer

Q1. Difference between sum and sumx?
Ans. 
SUM calculates the total of a column, while SUMX evaluates an expression for each row in a table and returns the sum of the results.
• SUM is used to calculate the total of a column in a table.

• SUMX is used to iterate over each row in a table, evaluate an expression, and return the sum of the results.

• SUMX is commonly used in DAX formulas to perform calculations row by row.
Answered by AI
Add your answer
Q2. What is gateway and its types?
Ans. 
A gateway in Power BI is a bridge that connects on-premises data sources to the cloud service.
• There are two types of gateways in Power BI: On-premises data gateway and Personal gateway.

• On-premises data gateway is used to connect cloud services to on-premises data sources.

• Personal gateway is used for individual users to refresh data within Power BI.

• Gateways ensure secure data transfer between on-premises and cloud envir
Answered by AI
Add your answer
Q3. What is row level security?
Ans. 
Row level security is a feature in Power BI that restricts access to data at the row level based on user roles or criteria.
• Row level security allows you to control which rows of data a user can see in a report or dashboard.

• It is commonly used to ensure that users only see the data that is relevant to them based on their role or department.

• Row level security can be implemented using DAX expressions to filter data based ...read more
Answered by AI
Add your answer

Q1. Explain git module
Ans. 
Git module is a software tool that allows for version control and collaboration on code projects.
• Git module is a version control system used for tracking changes in code files.

• It allows multiple developers to work on the same project simultaneously.

• Git module helps in managing different versions of code and merging changes from different branches.

• Common git commands include git clone, git add, git commit, git push, and...read more
Answered by AI
Add your answer

Q1. What is your name?
Ans. 
My name is John Smith.
• Full name is John Smith

• Common first and last name

• No middle name
Answered by AI
Add your answer
Q2. Tell me about yourself
Ans. 
I am a software engineer with 5 years of experience in developing web applications using Java, Spring, and Angular.
• 5 years of experience in software development

• Proficient in Java, Spring, and Angular

• Strong problem-solving skills

• Experience in developing web applications
Answered by AI
Add your answer

Quantitative Aptitude

Q1. To write syntax for a problem using any programming language.
Add your answer
Q2. Tell me about your projects and Internship experience.
Add your answer

Q1. Questions were related to Hobbies, extra curricular activities and some questions of analytical ability such as color cube, maths, etc. It was in general.
Add your answer

Q1. Basics of C programming language.
Add your answer
Q2. Basics of Data structure.
Add your answer

Q1. PowerApps question
Add your answer
Q2. Name of client, what is
Ans. 
The name of the client is the entity or organization that is receiving the software engineering services.
• Client name is typically a company or individual who has requested the development of a software product.

• It is important to maintain confidentiality and professionalism when discussing client names.

• Examples of client names could be Google, Microsoft, Apple, etc.
Answered by AI
Add your answer

Gtfd juun lfxjk nf kf krsz kg khvb.

Sf cv cv nn khg mhh mkgx sv jvv .

Gnn h m gf l y kf, kkyc liv mlbh mh .

Sf jf jdzy kew ha bkkm kgc jyydc .

Q1. Dbb Ku HK VM fb LM GH GH mm GH ui nfdz hx mkm
Add your answer
Q2. Fjnl bmkvhvgndVhfgnk hun jjvj HK HK DG.
Add your answer

Q1. Hjnn HK OK KKK LJ GH
Add your answer
Q2. Th uf GH ur Ed CV kg
Add your answer

KKK lb GU Mk ohhh sf VH mg ui

CJK PJ Mk ng HK LJ VN I'll