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.

Computer Science & Information Technology

You might also like to view...

What are breadcrumbs? What purpose do they serve? When are they useful?

What will be an ideal response?

Computer Science & Information Technology

The ________ task pane has tools to help you gather information using online reference resources

A) Research B) Online C) Reference D) Insights

Computer Science & Information Technology

COGNITIVE ASSESSMENT You have a new phone. What determines what type of messages you can send?

A. where you are geographically at any given time B. the embedded computer within the phone C. the type of phone D. the services offered by the mobile service provider

Computer Science & Information Technology

____ is the study of how we as humans think and learn.

A. Artificial intelligence B. Cognitive science C. Social science D. Neuroscience

Computer Science & Information Technology