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

Mastering Chart and Graph Essentials

Upper Lower and Proper Functions

Locate and Enable Power Pivot

VLOOKUP Incorporating Other Excel Functions

Quick Layout, Color and Chart Style Options

Build a PivotTable from a Data Model in Power Pivot

$6.99 AUD

$9.99

Includes: