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

Concatenate Data in Power Pivot

TRIM Data Cleanse

Reposition Resize and Delete Chart Elements

AutoSum

Manage Links Between Workbooks

Create and Use Calculated Columns in Power Pivot

$6.99 AUD

$9.99

Includes: