Home Forums Data Warehousing Strategies and Ideas Learning DW RE: Learning DW

  • January 12, 2018 at 10:41 am

    #1975759

    JaybeeSQL - Friday, January 12, 2018 10:19 AM

    Hi all, been going through the MS tutorial for Analysis Services, but it's as dull as ditchwater, not sure if I should spend time pursuing.  

    I have a small production DB I'd like to turn into a DW later, but for now any recommendations for a more engaging learning path?

    Thanks,

    JB

    First, familiarize yourself with concepts of dimensional modeling, star-schema, slowly changing dimensions, ETL. Afterward, focus on tools like SSAS, SSIS, and maybe vendor specific frameworks.

    Ralph Kimball is a good guide. His book below is perhaps one of the greatest ever written on the topic.

    The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

    https://www.amazon.com/Data-Warehouse-Toolkit-Definitive-Dimensional/dp/1118530802
    Articles & Design Tips
    https://www.kimballgroup.com/category/articles-design-tips/

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho