This video shows, from a business perspective, an Excel Pivot table that filters by a product and allows the user to see the distribution of all other products that appear on the same sales order of the product you selected. The back-end data is stored in an Microsoft Sql Server Analysis Services cube and contains over 15 millions sales order and over 160 million line items.

This video only discusses the business use of the tool. In a separate video, Part 2, the technical discussion of the cube and its architecture.

( [ Ссылка ] )

свернуть