A supermarket transactions data set is likely to have hierarchical columns of data. For example, for the
Question:
A supermarket transactions data set is likely to have “hierarchical” columns of data. For example, for the product sold, there might be columns like Product Family, Product Department, Product Category, and maybe even more. (See the file Supermarket Transactions.xlsx from Chapter 2 as an example.) Another hierarchy is for store location, where there might be columns for Country, State or Province, City, and possibly more. One more hierarchy is time, with the hierarchy Year, Quarter, Month, and so on. How could a supermarket manager use pivot tables to “drill down” through a hierarchy to examine revenues? For example, you might start at the Drink level, then drill down to Alcoholic Beverages, and then to Beer and Wine? Illustrate with the file mentioned.
Step by Step Answer:
Business Analytics Data Analysis and Decision Making
ISBN: 978-1133629603
5th edition
Authors: S. Christian Albright, Wayne L. Winston