The Global Superstore dataset is data from a fictional global retail chain that sells office supplies. In the real world, you will most likely be connecting to databases; however, working with Excel files is similar – sheets in Excel are treated similarly to tables in a database. The data in these workbooks is similar to what you would see in a database.
The Global Superstore dataset consists of one Excel workbook and one Excel CSV file:
- Global Superstore Orders 2016 (.xlsx) Sheet 1: Orders Sheet 2: People
- Global Superstore Returns 2016 (.csv) Sheet 1: Global Superstore Returns 2016
The Orders sheet contains sales data where each record (Row ID) represents a single transaction:
The People sheet contains a ...