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

Adjust Gridline Display and Axis Scale

Mastering Power Pivot Essentials in Excel L1

AutoSum

Customize Calculations in the Status Bar

Hyperlink to Cells External Files and Web Pages

Formula Auditing

$6.99 AUD

$9.99

Includes: