Do you want to work with a few small & sample data models in Excel to practice the things you’ve learned? I created a few that you are free to download and use however you want.

Customers-Orders-Products

This model is very simple. It has three tables: Customers, Orders, and Products. Download DataModelCOP.xlxs

Customers-Orders-OrderProducts-Products

This model has a bridge table called OrderProducts. It allows us to work with one-to-many relationships instead of the problematic many-to-many relationship. Download DataModelCOOPP.xlxs

These first two examples above are based on (but not exactly the same as) Greg Gogolin’s excellent beginner YouTube video called Database Design Tutorial.

Authors-AuthorsBooks-Books

Below is an example of a three-table data model of authors, books, and a bridge (linking/junction) table. Download AuthorsBooks.xlxs

Customers-Sales-Products

This model is similar to our first one on this post. Here its called Sales instead of Orders. The tables have been added to the data model and three measures have been created. This is the file from the post called DAX CROSSFILTER Example. Go ahead and download the Excel file. Download CrossfilterSimple.xlxs