I currently know a lot about databases, but haven't quite made it past the threshold into BI design. I am looking for good materials that can take you step by step through taking a transactional DB design and then creating the OLTP Dim and fact tables. I have access to MSsQL from 2008 to 2016, Lynda.com and any book on amazon. I was turned down for the class by work. I have googled, and am not sure what are the good resources, that I can afford. So, I thought I would ask you about what the best resources were. Video works best for me, but I can read as well. Any and all help is greatly appreciated. Please keep the topic about MS SQL.
Fox - trying to become undumb about BI only, lol