A well designed data model is a significant factor behind the success of a QlikView project. The architecture and structure of a data model must be well thought through to avoid strings of complicated and unnecessary data presenting itself in the future.
Let's focus on what QlikView professional Steven Dark says about rocky data model foundations and starting a QlikView project the right way:
“What all too often happens is that the data model from the underlying source database is pulled in, with its existing join fields and system field names. A developer will be forced to deal with some immediate issues, such as synthetic keys, but will sometimes (once they have something that ‘kind of works') leave it at that. This can sometimes be okay on small data volumes – but it certainly will not scale and causes much extra effort down the line.”