Multiple Choice
The pivot table functionality that has been part of Excel for decades is great,but has its limits.With _____ and _____,these limits are expanded significantly.
A) Power Pivot,its DAX language
B) Data Models,SQL
C) data analysis,data visualization
D) power queries,summary measures
Correct Answer:

Verified
Correct Answer:
Verified
Q10: One way to create a unique identifier
Q11: Business intelligence refers to the insights gained
Q12: Primary and foreign keys relate information between
Q13: Suppose you try to create a pivot
Q14: The flexibility of the measures created by
Q16: In terms of importing data from a
Q17: When there is a many-to-many relationship,it is
Q18: Which of the following most accurately explains
Q19: Excel Data Model is a recent Microsoft
Q20: A hospital has a database for which