Modelación Tabular: una alternativa sugerente para el análisis de los datos.

Since last century, multiple researches have been made with the goal of incrementing the efficiency in the storage and access to analytical databases, upon which results large companies have introduced commercial products. In this aspect, Microsoft SQL Server 2012 offers two independent options for the creation of analytical models, the multidimensional model and the more recent tabular model. This work looks deeply into the features and potentialities of each model, proposing the most important points that, in the authors' judgment, must be taken into account when undertaking a new project. A computational solution that provides both specialists and executives a particular as well as inclusive vision of the state of the business is proposed, taking advantage of the recent facilities provided by the Microsoft Business Intelligence platform for implementing the models, both multidimensional and tabular. CIMEX Enterprise Group has been the stage where the solution proposal has been developed. For checking the approximation validity four experiments were performed. [ABSTRACT FROM AUTHOR]