Power Query
What is the difference between a measure and a calculated column?
A calculated column is for every row in a table, while a measure is a single value.
What is the difference between a primary key and a foreign key?
A primary key uniquely identifies each record in a table, while a foreign key can have duplicates and references another table.
If someone wants to see a data trend over time, what would be the best visualization?
Line Chart
Explain what a tooltip is.
Data or text that appears when you hover over a visualization.
In a formula, what function takes an entire table or column, ignoring all filters?
ALL
When transforming data, what is the difference between Merge Queries and Append Queries?
Merge is like a join (adds columns) while append adds rows.
If someone wants to see how one particular metric changes based on filters, what would be a good visual to use?
Explain a situation where a drillthrough would be a good design choice.
What is the difference between the functions SUM and SUMX?
Sum just adds up all values in a column, SUMX adds up all values for a custom expression.
If you want to turn the unique values in one column into their own columns, what functionality should you use.
Pivot columns.
If someone wants to see what percent each practice contributes to Turnberry’s total revenue, what would be a good visualization?
How do you set up one tab to be a tooltip for a visualization on a different tab?
What does this formula compute? CALCULATE(sum(utilization[Utilized Hours]),DATESQTD(utilization[datevalue]))
Sum of Utilized Hours for this quarter to date.
If you have a very large data set (over 100 million rows, for example), should you use Import or Direct Query to get the data?
Direct Query. Import stores the data directly to the file, which would be very expensive for such a large table.
How do you dynamically change the appearance of a visual based on the data values?
Conditional formatting.
Explain two ways a drillthrough can be activated.