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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Data Analysis and Decision Making

ISBN: 978-1133629603

5th edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: