Downloads

Model builder: build a finance model, then wire it up

Sort each table of a real database into Fact, Dimension, Bridge or Not needed, then draw the relationships and press Check my model.

How to play

Power Pivot and Power BI start every report with a model: a fact table of amounts, dimensions to slice them by, and relationships between the two. This game is that model view, on real sample databases. For the Finance track you first build the model: sort each table into Fact, Dimension, Bridge or Not needed, and see why. Then you draw the relationships like the Edit relationship dialog (cardinality, cross-filter direction, active or inactive), mark the date table, and press Check my model. Every mistake is explained: loops, shortcuts, backwards one-sides, bi-directional filters you do not need, and role-playing dates. Each level ends with a short lesson and a link to the guide. Just want to look at a database? Use the schema explorer.