O'Reilly logo

PowerPivot for Advanced Reporting and Dashboards by Robert Bosco J

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sales analysis data model design process

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

Creating a data relationship for the sales analysis data

Before creating a relationship the users must know about data relationships, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required