Overview
A comprehensive data analytics portfolio project that demonstrates advanced statistical analysis, geographic segmentation, and business intelligence techniques applied to order processing data.
Project Scope: Analysis of 26,833 orders across 114 regions from May 2023 to January 2025, focusing on order processing fee distribution and business patterns.
Key Analysis Areas:
- Distribution Analysis: Identified right-skewed distribution (z=2.18) typical of B2B order economics
- Statistical Testing: Comprehensive descriptive statistics and hypothesis testing
- Geographic Segmentation: Regional analysis of order patterns and processing fees
- High-Value Orders: Identification and analysis of premium order segments
- Commercial Insights: Business intelligence for operational optimization
Statistical Findings:
- Mean Processing Fee: £249.93
- Median Processing Fee: £214.62 (more appropriate for skewed distribution)
- Standard Deviation: £130.86
- Coefficient of Variation: 52.36%
- Formula Watch Rate: 69.16%
Methodologies: The project demonstrates best practices in exploratory data analysis, including proper handling of skewed distributions, selection of appropriate central tendency measures, and visualization of complex patterns.
Technical Skills: Python for data analysis, statistical testing, geographic analysis, and creating publication-quality visualizations for business stakeholders.
Impact: Showcases ability to extract actionable business insights from complex datasets and communicate findings effectively to non-technical audiences.
Technologies Used
Key Features
Descriptive statistics analysis
Distribution pattern identification
Geographic segmentation
High-value order analysis
Business intelligence reporting
Publication-quality visualizations
Impact & Results
Demonstrates advanced analytics capabilities and ability to derive actionable business insights from complex datasets