Headline

This retail dataset is pristine and ready for analysis: 5,000 complete transactions across 11 variables with zero missing values and perfect data quality (100/100), but Sales shows extreme right skew (13.3) with 98.4% of orders under $2,000.

Purpose

This exploratory data analysis profiles a client retail dataset to establish data quality, identify variable distributions, and surface initial patterns. The analysis confirms the dataset is clean and complete, making it suitable for downstream modeling. Understanding the shape and relationships of these variables is essential before building predictive or segmentation models.

Key Findings

Data Completeness: 5,000 rows, 11 columns, zero missing values, 100% data quality score — no cleaning required
Sales Distribution: Heavily right-skewed (skewness=13.3); median $53.14 but mean $239.66; 4,920 of 5,000 orders (98.4%) fall in the $0–$2,000 range, with rare high-value outliers reaching $22,638
Profit-Sales Relationship: Moderate positive correlation (r=0.36) — higher sales generally yield higher profit, but the relationship is loose
Discount-Profit Relationship: Weak negative correlation (r=−0.21) — discounts slightly erode profitability
Shipping Dominance: Standard Class accounts for 59.7% of all orders; Premium options (First Class, Same Day) represent only 21% combined
No Multicollinearity: Zero high-correlation pairs detected among numeric variables — all predictors are independent

Interpretation

The dataset is exceptionally clean and ready for analysis. The extreme skew in Sales reflects a typical retail pattern: many small transactions with occasional large orders. This skew will affect linear models and should be addressed through transformation (log scale) or robust methods. The weak correlations between financial metrics suggest that profit drivers are complex and likely involve interactions or categorical factors (region, category, segment). The shipping mode distribution shows customer preference for economy options, which may indicate price sensitivity.

Context

This is a profiling-only analysis; no predictive modeling or hypothesis testing has been performed. The correlation matrix includes only the four numeric variables (Sales, Quantity, Discount, Profit). Categorical variables (7 total: Ship Mode, City, Category, Sub-Category, Segment, Region, State) are analyzed separately via frequency tables. The extreme outliers in Sales are real data points, not errors, and should be retained for downstream analysis.