X
Excel Zero to Hero Interactive Learning Platform
0%
Hands-On Practice Data

Enterprise Dataset Library & Labs

Production-scale, verified datasets used throughout our curriculum, practice exercises, and capstone projects. Each dataset includes documented schemas, verified row counts, business scenarios, and direct access links.

Retail Benchmark 9,994 Rows • 19 Cols

Sample Superstore Sales

A multi-regional US commercial retail transaction dataset spanning 2014 to 2017. Total revenue $2,297,200 with $286,397 profit across 4 geographic regions and 3 customer segments (Consumer, Corporate, Home Office).

Data Grain: Single line-item purchase within an order
Skills Practiced: XLOOKUP, SUMIFS, ListObject Tables, Slicers, Pareto Distribution
Related Modules: Module 2, Module 3, Module 4, Module 5, Module 6
Hospitality Operations 36,275 Rows • 19 Cols

Hotel Reservations Classification

A rich hospitality dataset documenting guest booking patterns, meal plans, room types, lead time (0 to 443 days), average price per room (€103.42), and cancellation status (32.76% overall cancellation rate).

Data Grain: Single guest reservation booking
Skills Practiced: Data validation, missing value imputation, pivot cross-tabulation, revenue risk
Sources: Kaggle Benchmark & HuggingFace Mirror
Telecom BI Capstone 5,000 Records • 10 Cols

PwC Call Center Performance

A corporate simulation evaluating 5,000 customer service telephony records for Q1 2021. Tracks First Call Resolution (FCR ~72.9%), agent utilization, speed of answer (67.5s avg), and satisfaction scores (3.4 / 5.0 CSAT).

Data Grain: Single customer service phone interaction
Skills Practiced: Power Pivot, Star Schema, DAX Measures, Executive KPI cards
Source: PwC Virtual BI Case Experience
Curriculum Workbooks 10+ Workbooks • Excel (.xlsx)

Chapter Practice Workbooks

Pre-built exercise workbooks and completed instructor demonstrations saved in 11_Demos_and_Workbooks/, including Conditional Formatting & Absolute Relative.xlsx, Formulas_&_Functions_Part_1.xlsx, and 2-Module_2 Test Data.xlsx.

Location: Google Drive Course Materials Folder
Usage: Download to local disk to follow along with video lectures

🛡️ Data Quality Standards Across Datasets

In real-world data jobs, 80% of an analyst's time is spent preparing and verifying data. All datasets in our library are grounded in the DAMA 6 Dimensions of Data Quality:

1. Completeness: Zero unplanned null keys in critical dimensions.
2. Uniqueness: Deduplication across primary order/booking IDs.
3. Timeliness: ISO-compliant date formatting (YYYY-MM-DD).
4. Validity: List validation enforcement on categorical fields.
5. Accuracy: Reconciled totals matching accounting ledgers.
6. Consistency: Cross-table relationship referential integrity.