For reasons still not quite clear to me, I come across a lot of organizations that perform pretty poor regarding the data modeling of their business intelligence solutions.
In some cases the organizations don’t even have tools for data modeling. Strangely enough a lot of these have an Oracle database, so why not use the Oracle SQL data modeler, which comes for free.
Of course the tools are just a means to an end and don’t guarantee that your data model design is correct. But bringing some kind of structure to your data that is visualized in a data model will help you and the stakeholders to determine its correctness.
Data modeling is an art, not pure science. In a follow up post, I’ll elaborate on that.