sneumersky (1/23/2014)
I have a bad tendency of pushing just Kimball, when in fact there are other schools of thought out there. On this site, I tend to lean way closer to the Kimball side because many of the MS BI tools like Powerpivot and Analysis Services are more friendly to the "Kimballgroup way of doing things".
Although the CIF is normalized in the 3rd normal form, the various data marts build upon this are dimensional. So you can still use SSAS and PowerPivot when using the Inmon strategy. Also, because you can remodel everything in PowerPivot and the DMV of SSAS, you can build models directly on the normalized CIF. If just takes more work 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP