Discuss some of the advanced data modeling techniques made possible with the PowerPivot add-in
What will be an ideal response?
PowerPivot allows you to create calculated columns and calculated fields, and establish KPIs all within Excel that can be used in PivotTables, PivotCharts, and other analysis tools. A special category of functions called DAX functions can also be used in PowerPivot to create calculations using data from other tables in the data model where relationships have been established.
You might also like to view...
Which of the following is a unique characteristic of a dual-core processor vs. a single-core processor?
A. A dual-core processor uses higher voltage than a single-core processor. B. A dual-core processor has several unique cores, with the same cache, on two different chips. C. A dual-core processor has two cores, with separate caches, on the same physical chip. D. A dual-core processor requires more RAM to function than a single-core processor.
Select the element used to hyperlink web pages to each other from the list below:
a. link b. hyperlink c. anchor d. target