I've mostly learned through consulting and analytics experience and with the help of Ralph Kimball's book "The Data Warehouse Toolkit". You'll also want to look

I've mostly learned through consulting and analytics experience and with the help of Ralph Kimball's book "The Data Warehouse Toolkit". You'll also want to look up Bill Inmon as he proposes a different methodology to data warehouses. Happy to answer questions if you have any.