Understand the Data Model in Power Pivot

No reviews yet.

A Data Model allows you to integrate data from multiple tables, effectively building a relational data source inside an Excel workbook.

Data Models are used transparently within Excel, providing tabular data used in PivotTables and PivotCharts.

When you connect Power Pivot to, for example, an external database, that data does not appear visible in your worksheets but is embedded as hidden data within the workbook.

Highlights

Explore the unique values in primary key fields
Manage the display of tables in a Data Model
Understand the data sort and filter options available for each table column

Duration: 8mins

$6.99 AUD

from

$9.99

Add to Cart

Includes:

Quality On-demand Video Demonstrations
Step-by-step Learner Guide
Demonstration and practice exercises to boost retention
Lifetime access
Course progress indicator

Understand the Data Model in Power Pivot

Highlights

Related Courses

Manage Links Between Workbooks

Create and Use Calculated Columns in Power Pivot

Create a Chart on a New Sheet

Formulas and Functions Basic Structure

Insert Function Wizard

Work with Noncontiguous Ranges

$6.99 AUD

$9.99

Includes: