Interview Questions.

Question 1. Explain What Is Dax?

Answer :

DAX stands for Data Analysis Expressions, and it's miles the components language truly it is a collection of capabilities, operators, and constants that may be used in a formula, or expression in Microsoft SQL Server Analysis Services, Power Pivot in Excel, and Power BI Desktop. Stated extra virtually, DAX enables you create new facts from statistics already in your version.Expressions.

Question 2. Explain When Do You Use Sumx() Instead Of Sum()?

Answer :

When the expressions to SUM() consits of whatever else than a column name.

Typically whilst you need to feature or multiply the values in extraordinary columns:

SUMX(Orderline, Orderline[quantity], Orderline[price])

SUMX() first creates a row context over the Sales table (see 1 above). It then iterates through this desk one row at a time. SUM() is optimized for lowering over column segments and is as such now not an iterator.

Python Interview Questions
Question three. What Do You Understand By New Calendarauto() Function In Dax(ssas)?

Answer :

CALENDARAUTO feature returns a desk with a unmarried column named “Date” that consists of a contiguous set of dates. The variety of dates is calculated automatically based totally on data inside the version.

Example: In this example, the MinDate and MaxDate in the records version are July 1, 2010 and June 30, 2011.

CALENDARAUTO() will return all dates between January 1, 2010 and December 31, 2011.

CALENDARAUTO(three) will really return all dates among April 1, 2010 and March 31, 2012.

Question four. Name Any 3 Most Useful Aggregation Functions Dax?

Answer :

DAX has a number of aggregation features, inclusive of the following generally used features:

SUM
AVERAGE
MIN
MAX
SUMX (and other X functions)
These capabilities paintings most effective on numeric columns, and commonly can mixture simplest one column at a time. However, special aggregation capabilities that lead to X, which include SUMX, can paintings on more than one columns. These functions iterate through the desk, and examine the expression for every row.

Python Tutorial
Question 5. Which Are The Three Places Where An Expression Can Be Evaluated And Hence A Specific Context Is Set?

Answer :

In a pivot desk cell. Filter context is about by way of rows, columns, filters and slicers.
In a row cell (calculated column) Row context is about through the row itself.
In the measure calculation region of a table. No row, nor filter out context is set.
ETL Testing Interview Questions
Question 6. Name Any 3 Most Useful Text Functions In Dax?

Answer :

The text features in DAX encompass the subsequent:

CONCATENTATE
REPLACE
SEARCH
UPPER
FIXED
These textual content work very in addition to the Excel functions which have the equal call, so if you're acquainted with how Excel handles textual content features, you're already a step in advance. If not, you may usually experiment with these features in Power BI, and analyze extra about how they behave.

Question 7. How Is Filter Context Propagated Through Relationships?

Answer :

Filter context automatically propagates following the filtering of the connection. It usually propagates from the one facet of the connection to the numerous facet. In addition, you furthermore may have the <u>alternative of permitting the propagation from the various side to the only aspect</u>. No functions are available to pressure the propagation: Everything occurs inside the engine in an automatic way, in step with the definition of relationships inside the information version.

ETL Testing Tutorial Data technological know-how Interview Questions
Question 8. What Is The Difference Between Distinct() And Values() In Dax?

Answer :

Both depend the distinct values, however VALUES() also counts a probable implictit digital empty row due to non matching values in a toddler table. This is commonly in a size table.

Question nine. Which Function Should You Use Rather Than Countrouws(awesome())?

Answer :

DISTINCTCOUNT()

Data analyst Interview Questions
Question 10. What Is A Pattern?

Answer :

A sample is a trendy reusable strategy to a normally occurring problem.In Microsoft Excel, you operate patterns each day to construct tables, charts, reviews, dashboards, and more.

R Programming language Tutorial
Question eleven. What Are Dax Patterns?

Answer :

DAX Patterns is a group of ready-to-use information fashions and formulation in DAX, which is the programming language of Power Pivot. Create your Excel facts model quicker by using the use of a DAX pattern

Business intelligence Interview Questions
Question 12. Explain Related() And Relatedtable()?

Answer :

RELATED works if you have a row context at the desk on the many side of a dating. RELATEDTABLE works if the row context is lively on the one facet of a dating. It is well worth noting that both, RELATED and RELATEDTABLE, can traverse an extended chain of relationships to acquire their end result; they're not restrained to a single hop.

Python Interview Questions
Question 13. Explain How A Pivot Table Can Be Viewd As An Mvc System?

Answer :

Model = the Data Model (incl DAX expressions)
View = the table (or chart)
Controller = rows + columns + filters + slicers
What can you are saying approximately computerized clear out propagation The filters best ever robotically go with the flow from the "one" aspect of the connection to the "many" side of the connection; from the "arrow" aspect to the "dot" aspect; from the research table to the facts table—something phrases you operate, it's usually downhill.

With the lookup tables above and the data tables under, it's miles a intellectual cue to help you immediately visualize how automated filter out propagation works.

Question 14. How Does Calculate() Result In Context Transition?

Answer :

When in row context it transitions to filter out context: the filter out on the rows of a selected desk propagates via the connection to the related before the calculation is finished.

E.G. CALCULATE(SUM(OtherTable[column]) in a calculated column.

It extends or modifies an present filter context, by means of including a clear out as its second parameter.

CALCULATE() constantly introduces clear out context.

Question 15. What Is The Difference Between Max And Maxa Functions In Dax?

Answer :

The MAX feature takes as an issue a column that incorporates numeric values. If the  column carries no numbers, MAX returns a clean. If you want to evaluate values that are not numbers, use the MAXA characteristic.

R Programming language Interview Questions
Question sixteen. How Are Row Contexts Created?

Answer :

Automatically in a calculated column
Programmatically through the use of iterators.
Question 17. How Are Filter Contexts Created?

Answer :

Automatically by using using fields on rows, columns, slicers, and filters.
Programmatically through the usage of CALCULATE()
Ph analyzer Interview Questions
Question 18. How Can You Propagate Row Context Through Relationships?

Answer :

Propagation takes place manually by means of the usage of RELATED() and RELATEDTABLE(). These features want for use on the right aspect of a one-to-many courting: RELATED() on the many side, RELATEDTABLE() on the only side.

ETL Testing Interview Questions
Question 19. How Does Summarizecolumns Relate To Filtering?

Answer :

SUMMARIZECOLUMNS is not prone for outer (outside) filters, in assessment to SUMMARIZE
you may upload a clear out (e.G. The usage of FILTER) as a param of SUMMARIZCOLUMNS and it will filter out therefore. It acts as if you've delivered a filter out in a pivot desk.
Question 20. What Is The Initial Filter Context?

Answer :

The initial filter out context comes from 4 areas of a pivot table:

Rows
Columns
Filters
Slicers
It is the usual filtering coming from a pivot desk before any possible adjustments from DAX formulas the usage of CALCULATE().

Question 21. Why Don't You Use A Calculate() In The Aggregation Expression Of A Summarizecolumn()?

Answer :

The CALCULATE() is routinely generated.

Question 22. What Is The Difference Between Having A Measure As A Second Filter Param And Having The Original Measure Expression As A Param. Filter(desk, [measure]) Vs Filter(desk, Sum(...))?

Answer :

A degree has constantly implicit clear out context, so the ROW context caused by means of the FILTER is transferred to filter out context within the degree.<br>In case of the expression handiest, no clear out context is imposed at the expression, so the expression is evaluated with an empty filter out context! This gives a unique end result.

Question 23. Dax Nested Functions Is Equivalent To Sql What?

Answer :

SQL subqueries.