Generate dimensional models on the fly in the workshop environment Get your facts and dimensions identified and modeled visually in front of your users Never need to try and figure out what your written notes meant after the workshop is over Generate model documentation, including the Bus Matrix, automatically in Word Include your model documentation in your technical specification Link directly to data sources to include data lineage and transformation rules right in your model Data lineage suport for SQL Server 2005/2008/2008R2/2012, Oracle 9-11g, Acces MDB, ODBC. Diagram view to visual star schemas
Flexible dimensional model design Fact and dimension attribution with metadata Source data explorer and lineage import Model document generator Visual diagram view Kimball model data store
Dimensional Modeler is Unique! There is no other generic dimensional modeling tool on the market that facilitates the user-driven modeling approach. Throw notebooks, flipcharts and whiteboards away. ..build your dimensional model in your workshop with your users! Project your laptop display to a screen and get the users to partipate in Fact and Dimension identification and clarification of grain. Let the users take the model away with them after the workshop.
Aimed at the business intelligence consultant and/or data warehouse developer.