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:
DimChannel
DimDate
DimProduct
DimProductSubcategory
DimPromotion
FactSales
ProductCategory
Stores
Geography
Before creating a relationship the users must know about data relationships, what is the use of it, and the classification of relationships. Usually the relationship is derived from a normalized database. Normalization is the process of breaking a big table into two or more smaller tables, so to get the...