• Read Kimball's The Data Warehouse Tookit, 3rd edition. Google it; it's a free PDF download and also the most authoritative, comprehensive guide of all time for helping you formulate your datamart.

    It allows for various purposes and corresponding appropriate theories of normalization or de-normalization as the case may be, but overall its focus is to guide those who want to set up a data mart for access by reporting analysts.