Post reply

DW NOVICE Question - How Best To Exploit OLAP

  • May 24, 2011 at 10:05 am

    #389581

    I'm a traditional RDBMS guy with years of experience in the relational world and have only done some light reading about SSAS/OLAP/CUBEs and related items. I now have a dev/test SQL 2005 server running with SSAS running that I'd like to tinker with to see if I can create some Data warehouse/cubes that could provide our users with faster reporting options.

    I admit I don't fully know the diff between a DW (Data Warehouse) a DM (Data Mart) and a CUbe; they could all be 3 different words for the same thing as far as I know. I was hoping someone could provide a link to a great starting point for some one experienced in Realtional DB's on SQL Server who wants to check out OLAP whcih I believe is the over all term for SSAS + Data Warehouse + Data Marts + Cubes.

    Thanks

    Kindest Regards,

    Just say No to Facebook!

  • May 29, 2011 at 11:25 pm

    #1331503

    This is a welcome resource..

    Click here

    Raunak J

  • May 30, 2011 at 6:19 pm

    #1331759

    YSLGuru (5/24/2011)

    I admit I don't fully know the diff between a DW (Data Warehouse) a DM (Data Mart) and a CUbe; they could all be 3 different words for the same thing as far as I know.

    Well, they are not. A Data Warehouse is nothing but a collection of Datamarts; Cubes are one of the possible solutions to implement a delivery layer on your Data Warehouse.

    As for an starting point, I would start by researching Dimensional Modeling.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • May 31, 2011 at 5:00 am

    #1331878

    William Pearson writes several excellent article on SSAS and MDX.

    Check out these links:

    SQL Server Central Stairway Series[/url]

    Database Journal Series

  • May 31, 2011 at 5:49 am

    #1331901

    I always recommend Ralph Kimball's works to anyone starting out.

  • May 31, 2011 at 12:58 pm

    #1332224

    Many thanks to all who have replied with recomendations/links.

    Kindest Regards,

    Just say No to Facebook!

  • May 31, 2011 at 7:20 pm

    #1332327

    Just to add one more that you already have access to... do a search in the BOL index for "Tutorial".

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply