Create Table Relationships in Power Pivot

No reviews yet.

Once you create or import a table for each subject in your Data Model, you must enable the bringing together of related information in Excel again when needed.You do this by ensuring you have common fields in tables that are related, and by defining relationships between your tables.This way Excel analysis stools such as Pivot Tables can draw information drawn from several tables.

Properly designed tables and relationships can remove data redundancy or duplicate data by dividing your data into many subject-based tables so that each piece of is represented only once.

Here are 2 examples of relationship types:

One-to-many relationship: g. Each record in a customer table can have many records in an orders table.
One-to-one relationship: g. Each record in a staff table should only have 1 matching record in a staff details table. Such tables could be split for reasons such as privacy.

Highlights

Manage table relationships display in Diagram View
Understand the steps in creating and deleting table relationships

Duration: 7mins 28secs

$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

Create Table Relationships in Power Pivot

Properly designed tables and relationships can remove data redundancy or duplicate data by dividing your data into many subject-based tables so that each piece of is represented only once.

Highlights

Related Courses

Count Functions

Concatenation – combine data from multiple cells

Define and Use Cell and Range Names

Customize Calculations in the Status Bar

Mastering Power Pivot Essentials in Excel L2

Upper Lower and Proper Functions

$6.99 AUD

$9.99

Includes: