October 30, 2011 at 10:41 pm
Comments posted to this topic are about the item Using The Kimball Dimensional Modeling Tool
October 31, 2011 at 8:44 am
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
October 31, 2011 at 9:45 am
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!
November 1, 2011 at 12:54 am
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
November 1, 2011 at 3:46 am
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/
Martin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply