This chapter allows the user to explore the features of data model and the fundamental concepts of relationship and hierarchy. The user, by now, should know how the ETL process and DAX expression are performed in PowerPivot, and how to use them to create structured data from unstructured data. Finally, the user will know how data can be homogenized from heterogeneous data.
More precisely, practical information about two industrial data has been clearly explained in order to make a good logical data model design, in which the user will know how to use PowerPivot to create a relationship, hierarchy, and make calculated columns, and do some troubleshooting if they encounter any errors while practising any of the functions. So, finally two different types of logical data model designs have been shown practically.
The next chapter fully covers BI analytical reporting, metrics, KPI, and so on, based on the data model that we have created in this chapter and explains how to make a report...