ABOUT THE DASHBOARD

Explore the trends in Grocery Sales based on a sample of debit and credit card transactions in this dashboard. The location of the debit/credit cardholder is based on the cardholder’s address in the financial institution’s records. 

The top 15 merchants by Sales, Top Sales by State and Zip, Sales per capita by state, Sales by week and merchant are available based on date and merchant choice. The top 15 merchants display the merchant and total sales in the order of ranking. The top sales by state and zip display the merchant, state, total sales and the sales per capita. The map visual gives in-depth detail on the sales per capita by state and a drill down to the zip code level. The zip code level drill down is available via the map visual (right-click or hover) and, top sales by state and zip table visual.  

The zip code level drill down displays a map with zip code and sales per capita for the zip code for the chosen state. The table provides merchant, zip, city, total sales and sales per capita on the side ranked by highest sales per capita. 

HOW TO USE IT

The user selects the date range and the merchant to explore the Sales per capita by state, Top sales by state and zip, Top 15 merchants by Sales and a sample of sales by week and merchant. The sales per capita is displayed by state on the map visual. The top sales and the top 15 merchants by sales tables are ranked by Sales. The user can change the sort order on both tables as needed for a more in-depth review. On selecting a state in the visual, the user can drill down to the zip code level which displays the sales by capita by zip code on a map visual and more detailed information in the table. The drill-through feature is available via the map visual (right-click or hover) and top sales by state and zip table visual. 

VARIABLE DEFINITIONS

Date: Data available from 1/3/2015.

Sales per capita: Divide Total Sales by Population.

Top 15 Merchants by Sales: Total sales ranked by Merchant

Top Sales by State: Total Sales and Sales per Capita by Merchant and State 

DATA SOURCES

CFDAS; Facteus; U.S.Census Bureau, Population Division, December 2021.

SOURCE

The Center for Food Demand Analysis & Sustainability (CFDAS) at Purdue University and the Department of Agricultural Economics at Purdue University. 

DASHBOARD AUTHORS

Annapurni Subramaniam, Jayson Lusk and Jian Yu