Email this to someoneShare on Google+Share on LinkedInTweet about this on Twitter

The new BI Modeler release implements analytical base table design for Advanced Analytics applications

Advanced Analytics applications often require data models based on analytical base tables: tables that include either measures and dimensional attributes at the same time. This kind of tables contain all the quantitative and categorical features needed by machine learning algorithms to fit predictive and analytical models.

Analytical base tables are fact tables that embed the columns of the related dimensional tables instead of referencing them.

The new BI Modeler release (b115) implements a new Hierarchy Implementation Strategy to generate, starting from a standard Fact Schema, this kind of fact tables with embedded dimensional attributes.

Applying this implementation strategy, called Embedded Dimension, a Hierarchy of a Fact Schema will be implemented adding all the columns derived from its attributes to the corresponding fact table, side by side with the measures of the Fact Schema. The grain of the fact table is always defined by the set of dimensions of every Hierarchy.


Email this to someoneShare on Google+Share on LinkedInTweet about this on Twitter

BI Modeler supports SAP HANA and HADOOP HIVE data modeling

I’m very proud to announce that now BI Modeler (b107) supports both SAP HANA and HADOOP HIVE physical data modeling.

Now you can design your data warehouse conceptual model via DFM and transform it in a ready-to-use physical model for the most used in-memory and big data platforms.

Try it by yourself: get a copy of the last version of BI Modeler from the DOWNLOAD section.

Email this to someoneShare on Google+Share on LinkedInTweet about this on Twitter

BI Modeler b104 is now available!

A new release of BI Modeler is now available. You can download it from the DOWNLOAD section.

This release fixes minor bugs related to the forward engineering algorithm: since release b104, no column is generated for a calculated measure anymore.

It also introduces more settings about the naming convention adopted during the forward engineering process: you can choose prefixes and suffixes used for surrogete key, PK and FK constraint names. You can also choose the “white char” used to replace spaces and concatenate prefixes/suffixes.

Email this to someoneShare on Google+Share on LinkedInTweet about this on Twitter

Hello world!

Welcome to the brand new site of my Business Intelligence Modeler tool.

I decide to give a new home to BI Modeler outside of my blog

BI Modeler was born in 2006 as an experiment, a sort of a lab to verify if a Model Driven approach may be applied to realize Business Intelligence systems and what kind of tool/functionalities were needed to support this approach.

Then it became a personal productive tool that I have used in real projects. At the same time it has been published on my blog and more and more people have downloaded and used it (for free, of course).

Now ti has gained such a maturity level that I believe it’s time to give to the tool more visibility, with a dedicated site. It is not a commercial evolution: BI Modeler will continue to be available for free; at present I’m just interested in promoting the use of a model driven approach in BI projects.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.