Tyson Frozen Foods

Tyson Frozen Foods manufactures and markets specialty frozen and refrigerated food products. Tyson markets its products domestically to food retailers, restaurant operators, and noncommercial food service establishments such as schools, hotels, and health care facilities. Most of Tyson customers are small businesses, and are divided along the Sales District dimension and Pricing Segment dimension. 

tyson logo


Access To This Dataset

Access to this dataset is for educational use and Systems Access must be requested and approved prior to use. Once access has been approved, the Data Dictionary and Entity Relationship Diagram is available by logging into the requested system and selecting the Instructions tab.

Note: By legal agreement, It is forbidden to download the data from the University of Arkansas systems. This will be strictly enforced.

Request Systems Access

Behind the Data

The sales organization advises the customer on what products will provide the strongest sell through as well as explains the pricing structure based on the sales district, and pricing segment.
The customer requests the appropriate products, which are then shipped through freights and frozen if necessary.

Tyson Frozen Foods cube consists of 6 dimension tables that are linked to a fact table. The data also contains COPA database, for cost and profitability analysis data. The data contains customer transactions for more than 13 thousand products shipped to 92 different sales districts in the United States.

The information available is based on the Tyson Frozen Foods COPA database available on SAP BW. Users will have the opportunity to explore the data and operations of the company and see how the data can be leveraged to improve profitability in the organization.

A Teaching Case-Study 
Basics of SQL for Audit Data Retrieval and Analysis

A fragment of this dataset containing data from 2007 was extracted by a  team of researchers from the Rutgers Business School. The team has  designed a teaching case study for a peer-review journal that requires students to download and use this dataset fragment in the form of a Microsoft Access Database. The article is currently accepted for publication by the Journal of Emerging Technologies in Accounting of the American Accounting Association. The article link is forthcoming.

The dataset for the teaching case study can be downloaded here

Table Name Time Frame Rows Attributes Size
CUSTOMER 2007 77,620 9 6.21 MB
INVOICE_FACT 2007 2,144,075 16 253 MB
LOCATION 2007 129 6 6.31 KB
OPEN_INVOICE_FACT 2007 6,618,121 8 536 MB
PRODUCT 2007 36,595 9 2.65 MB
TIME_DAY 2007 4,755 31 1.31 MB
6 TABLES     79 1.34 GB

 

The Full Tyson Dataset

This is a gifted dataset that is based on real operational data. Like many real databases, integrity problems may be noted. This can provide a unique opportunity not only to expose students to real data but also to illustrate the effects of data integrity problems.

The Tyson dataset is contained within the Walton College of Business's Enterprise Systems.

The dataset can be accessed with SQL queries within the University of Arkansas's Remote Desktop environment. The best way to access the dataset would be within the University's Teradata SQL Assistant software or Microsoft SQL Management Studio (Systems).

Once an account is obtained, the Tyson database can be queried as fit by the user.

 

Table Name Time Frame Rows Attributes Size (GB)
BRAND_CODE n/a 413 2 0.494
BUSINESS_DIVISION n/a 107 2 0.419
BUSIENSS_GROUP n/a 14 2 0.375
BUSINESS_SEGMENT n/a 8 2 0.495
COPA_TIME_BUCKETS n/a 53 3 0.393
CUSTOMER n/a 20,020 21 6.630
FROZEN_FOODS_FACT 10/17/1998 to 10/8/2005 11,071,631 61 3,396.840
INDUSTRY_DESC n/a 21 2 0.379
MINOR_LINE n/a 0 2 0.368
PART n/a 70 2 0.402
PRICING_SEGMENT n/a 18 2 0.492
Primary_broker n/a 410 2 0.491
Process n/a 74 2 0.404
Product n/a 12,867 8 1.576
Protein_group n/a 5 2 0.371
Sales_organization n/a 3 2 0.370
Sales_person n/a 430 2 0.496
Secondary_broker n/a 410 2 0.489
Selling_group n/a 40 3 0.389
Sic_table n/a 79 2 0.406
20 TABLES     124 3,411.918