Using The Kimball Dimensional Modeling Tool

  • jimnichols98

    SSC Rookie

    Points: 36

    Comments posted to this topic are about the item Using The Kimball Dimensional Modeling Tool

  • Todd M. Owens

    Old Hand

    Points: 338

    Jim -

    What does the tool cost? Is there maintenance? How much time did it save on the first use and how much is it likely to save in each data mart going forward?

    Thanks - Todd

  • Samuel Vella

    SSCrazy Eights

    Points: 8055

    Todd,

    There is a link to the download in the article:

    http://www.kimballgroup.com/html/booksMDWTtools.html

    Cost is zero... however it is worthwhile buying the book it accompanies!

  • jimnichols98

    SSC Rookie

    Points: 36

    Hi Todd,

    As Samuel mentioned, the cost is only the time and effort to integrate the tool into your process, so initial and maintance fees do not apply (should buy the book in my opinion).

    As for the initial and follow on benefits, it depends on the situation of course but for the typical data mart, it provides some benefit in the form of time savings and process structure (e.g. making sure all the metadata items are populated) for the initial data mart. There would be a higher ROI benefit in follow on data marts as long as you use the tool to do the modeling and deployment (there is no easy way to reverse engineer in changes made without the tool).

    There are situations where other tool choices would likely provide a higher ROI, such as projects that will have a lot of tables (e.g. 100 or more, because there is no way to create logical submodels) or projects that require reverse engineering of existing database schemas into models.

    Regards,

    Jim

  • Martin N

    Ten Centuries

    Points: 1186

    or you could download 3D (stands for data driven design) it's a modelling tool from Wherescape. Provided at the moment as a free beta quite a powerful tool, check it out.

    http://www.wherescape.com/products/


    Kindest Regards,

    Martin

Viewing 5 posts - 1 through 5 (of 5 total)

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