Week 5 – Excel Powerpivot

Question 1

How do you do PowerPivot importing

Answer 1

• One of the most useful features of spreadsheets is the ability to quickly calculate tabular summaries of data.
• A weakness of pivot tables and charts: They rely on one worksheet.
• PowerPivot can pull data from multiple database tables or spreadsheets, or retrieve through database queries.

Question 2

What are PowerPivot relationships?

Answer 2

Databases only create relationships between and among tables.

Question 3

What are PowerPivot tables?

Answer 3

Used to maintain connections to remote systems

Question 4

What are PowerPivot charts?

Answer 4

• PowerPivot can create charts similar to PivotCharts.

- However, PowerPivot can draw data from multiple data sources.