Many-to-Many & Bridge Tables: Spotting Double Counting and Allocating with Weights
This lesson is part of the course
In this lesson
You join Larkfield Home's product revenue through a product–collection bridge table, measure how much the join double counts and allocate revenue with weighting factors so the totals add up again.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Grain of a Fact Table: One Row per Order Line & the Duplicate Check Locked
- Surrogate vs Natural Keys: Key Mapping and the Unknown Member Locked
- Joining Facts to Dimensions: Enriching Sales with XLOOKUP and INDEX/MATCH Locked
- Aggregating by Dimension Attributes: SUMIFS by Category and Region Locked
- The Date Dimension: Date Keys, Quarters, Months and Weekdays from a Date Locked
- Slowly Changing Dimensions Type 2: Valid-From/To and the Right Version by Date Locked
- Many-to-Many & Bridge Tables: Spotting Double Counting and Allocating with Weights Locked
- Model QA: Orphan Keys, Inner-Join Losses and Reconciling Totals Locked