In business intelligence technology, the prominent logic of the data model design is that if the user designs a good logically designed schema, they can easily analyze a large volume of data. This chapter gives the fundamental concepts of a data model and how to design the logical schema based on the data sources.
A successful importation of two industry-type data for the analysis has been done in the previous chapter. In this chapter, a fundamental idea about the data model design will be given and we will continually learn how to practically design a data model for the imported data with the use of PowerPivot functionalities.
The preceding diagram illustrates how a data model inside the PowerPivot Workbook will be; the prominent factor is that this chapter is fully based on integration and aggregation from imported data sources.