It's a difficult sphere of knowledge to penetrate. All of that is perfectly coherent to me, FWIW.

From first principals, I can highly recommend Ralph Kimball's primer, The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling.[1]

[1]https://www.amazon.com/gp/product/B00DRZX6XS