In the Sales Analysis PowerPivot Workbook, importation of nine tables from different data sources has been done. Here, some tables may have no relationship and some may have different data formats, some tables may need a few calculated columns, and so on. Solving these issues will make the data homogenized, integrated, prepared, and detailed and aggregated; this is known as a logical design.
The following are the tables that were imported into the Sales Analysis PowerPivot Workbook:
Before creating a relationship the users must know about data relationships, ...