Linking data in the model

When you start using Excel business intelligence tools you’ll realize that they enable connecting with data from multiple sources. This can be an Excel spreadsheet or text files, databases, data from the Internet, data warehouse “in the cloud” … If you have ever used MS Access, you will easily understand how to add and link tables within the model. If not, read this article and you will see that it is easy and quite intuitive task.

Data model

Data model is used to add and connect tables in a whole, in order to retrieve the data needed for reporting. This is a pseudo-base, part of Excel document. By adding a table into the Model data are automatically compressed; later, when we need them for reporting, they are decompressed and used as a reporting dimension in the pivot table. Data model is basis for use of “Power” technologies, i.e. “self-service” business intelligence tools.