ABOUT THE DASHBOARD

Explore trends in Casual Dining Sales based on a sample of debit and credit card transactions. The location of the debit/credit cardholder is based on the cardholder’s address from 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 a date and merchant choice. The Top 15 merchants display the merchant and total sales in the order of ranking of sales. The Top Sales by State and Zip display the merchant, state, total sales and the Sales per capita. The map gives in depth detail on the Sales per capita by state and drilldown to the zip code level. The zip code level drilldown is available via the map visual (right-click or hover) and Top Sales by State and Zip table visual. The zip code level drilldown 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 the tables as needed for more in-depth review. On selecting a state in the visual, the user can drilldown 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 drilldown 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.

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

DATA SOURCES

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

SOURCE

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

DASHBOARD AUTHORS

Annapurni Subramaniam, Jayson Lusk, Tor Tolhurst and Jian Yu