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

Question

Quizplus · Accepted Answer

Power Pivot and its DAX (Data Analysis Expressions) language significantly expand the capabilities of Excel's pivot tables by allowing for more complex data models and calculations.

The Pivot Table Functionality That Has Been Part of Excel