Preparation of data for analysis has been done, but for full and meaningful analysis relationships have to be created between the tables that were imported from different data sources. By creating a relationship, integration of columns, creation of attribute formats, metrics, and calculation of columns using DAX for our analysis and advanced reporting can be done as per the requirements. One of the prominent things here is that a hierarchy can be created based on these attributes. So finally the logical design of the PowerPivot interface will be based on the star schema, the snowflake schema, or the constellation schema. After all these processes in the PowerPivot interface are completed, it will fulfill the third principle of integration and aggregation. The extract, transform, and load (ETL) process and DAX functional feature have already been discussed and this will help a lot in designing the data model.
The importation of the data of two industries for the...