📦 Sample Superstore: Master Dataset Documentation & Practice Ground

🌐 Provenance, Official Sources & Open Mirrors

This dataset is a fictitious retail enterprise dataset created specifically for training analysts in commercial reporting, ETL pipelines, and visual analytics. It is not an open-government or single-institution export; it is a globally recognized pedagogical standard.

Authoritative & Community Sources

📊 Dataset Profile & Ground-Truth Statistics

pie title Superstore Sales by Category ($2.30M Total)
    "Technology ($836.2K)" : 36.4
    "Furniture ($742.0K)" : 32.3
    "Office Supplies ($719.0K)" : 31.3

Audited Benchmark Figures (Empirically Verified):

• Total Inbound Rows: 9,994 transaction line items
• Data Grain: 1 row = 1 product line item within an order
• Unique Orders: 5,009 discrete customer orders
• Unique Customers: 793 individual consumer, corporate, and home office buyers
• Unique Products: 1,862 distinct retail SKUs
• Total Gross Sales: $2,297,200.86
• Total Net Profit: $286,397.02 (Overall Profit Margin: 12.47%)
• Total Units Sold: 37,873 items
• Average Discount Rate: 15.62%

🗄️ Comprehensive 19-Column Data Dictionary

🎯 Direct Alignment with Module 2: Data Management

The Superstore dataset provides the empirical foundation for mastering the core skills of 02 Notes/02 Data Management:

1. Data Types & Custom Number Formatting (01 Data Types and Formatting)

• The Date Serial Trap: Order Date (11-08-2016) stored as raw text vs converted to true Excel serial numbers (42682).
• Profit Formatting Mask: Accounting display formatting where negative profits appear in red parentheses:
  TEXT Copy

  $#,##0.00;[Red]($#,##0.00);"-"
  

• Text Preservation: Formatting Postal Code and Order ID strictly as Text (@) to prevent loss of leading zeros or unwanted scientific notation.

2. Precision Sorting & Multi-Level Sorts (02 Sorting and Filtering)

• Multi-Level Sort Drill: Sort by Region (A to Z) ➔ Category (A to Z) ➔ Profit (Smallest to Largest).
• Forensic Filtering: Isolate all records where Discount >= 20% AND Profit < $0 to reveal toxic discount thresholds that destroy margins in the Central region.

3. Data Validation & Governance (03 Data Validation and Integrity)

• Validation Picklists: Constructing strict dropdown lists for Ship Mode ({"Standard Class", "Second Class", "First Class", "Same Day"}) to prevent typographical entry errors.
• Range Constraints: Restricting Discount entry to decimal values between 0.00 and 0.80.

4. High-Speed Data Transformation Tools (04 Data Transformation Tools)

• Flash Fill (Ctrl + E): Splitting Order ID (CA-2016-152156) into Country (CA), Year (2016), and Order Number (152156).
• Text-to-Columns: Decomposing Product ID (FUR-BO-10001798) using - delimiter to separate Category Code (FUR), Sub-Category Code (BO), and SKU sequence.
• Deduplication Audit: Identifying the distinction between unique Order ID records (5,009) and multi-line item transaction rows (9,994).

5. Keyboard Navigation Across 10,000 Rows (05 Keyboard Shortcuts and Navigation)

• Jumping from Row 1 to Row 9,994 in one keystroke via Ctrl + Down Arrow.
• Selecting the entire 9,994 x 19 range instantaneously with Ctrl + Shift + 8 (Ctrl + *) or Ctrl + A.