Data modeling

Power Pivot in Excel

Nick Edwards

Analyst at Roofstock

What is data modeling?

The sculpture of David by Michelangelo

Data modeling is the process of structuring and organizing data for analysis.
- Define relationships
- Organize and structure

A fact table.

A dimension table and a fact table.

A dimension table and a fact table.

A dimension table and a fact table linked together by a key.

Example of a star schema.

Cardinality - the number of times one row of data from the first table matches with a row of data from a second table.

Cardinality - the number of times one row of data from the first table matches with a row of data from a second table.

example of a 1:1 relationship

Cardinality - the number of times one row of data from the first table matches with a row of data from a second table.

example of a 1:manyrelationship

Cardinality - the number of times one row of data from the first table matches with a row of data from a second table.

Example of a many:many relationship

A hierarchy is a way of organizing data into levels of increasing granularity.

Image of Russian dolls

Example:

Power Pivot in Excel