CIS 125S Chapter 7

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

PowerPivot

An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables.

Power View

An Excel BI tool that allows you to create and interact with multiple charts, slicers and other data visualizations in a single sheet.

Source data

Data in a worksheet or from an external source, arranged in rows and columns suitable for a PivotTable.

Field section

The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.

PivotChart report

A graphical representation of the data in a PivotTable.

Data Model

A method of incorporating data from multiple, related tables into an Excel worksheet.

PivotTable

An interactive, Excel report that summarizes and analyzes large amounts of data.

refresh

The command to update a worksheet to reflect new data.

Filter

A process by which you can limit the display of data to only specific information.

Quick Explore

A tool that allows you to drill down through PivotTable data with a single click.

PivotTable Fields Pane

A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.

column titles

PivotTable field names are formed from the source data's

filter data

Slicers are used to

Business Intelligence tools

Tools that can be used to perform data analysis and create sophisticated charts and reports.

Layout section

The lower portion of the PivotTable Field List where you build the PivotTable report by rearranging and repositioning fields.

Canvas

Area of a Power View worksheet that contains data visualizations.

Field buttons

Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are:

Slicer

Easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way.

list

The data for a PivotTable should be in the format of a:

Field names

The column titles from source data that form categories of data for a PivotTable.

VALUES area

The area in the layout section of the PivotTable Field List where data is summarized is the

FILTER area

The area in the layout section of the PivotTable Field List where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the


Ensembles d'études connexes

Culture, Spirituality, and Alternative/Complementary Modalities - ML8

View Set

L5 Practice Quiz: Ch 4 Creating Your Own Class

View Set

IC3 Chapter 13 Networking and Internet Basics

View Set

International Trade Theory 6 - Tariffs

View Set