MARKET ANALYSIS
MARKET ANALYSIS
PC PARTS PRICE ANALYSIS (SOUTH AFRICA)
A deep-dive analytical project leveraging SQL and Power BI to standardize raw marketplace data into actionable business intelligence dashboards.
Project Overview
This analytical project focuses on decodifying the PC hardware marketplace in South RSA. Using refined SQL methodologies to clean and normalize raw data across multiple retailers, I engineered a structured database that powers deep pricing insights. The objective was to transform volatile market listings into strategic intelligence, identifying price trends, depreciation cycles, and value benchmarks through advanced visualization in Power BI.
Skills & Tools
SQL
Power BI
GitHub
In-Depth Technical Execution
Database Structure & Key Insights
The database architecture centres on a Parts-centric schema designed to facilitate efficient cross-retailer pricing comparisons. By mapping unique product identifiers across multiple South African vendors, the system solves the challenge of non-standardized naming conventions, enabling granular value analysis.
- What are the average price fluctuations per component category over time?
- Which retailers offer the best value-to-performance ratio for mid-range GPUs?
- At what threshold does component age significantly impact resale value in the local market?
Deep-dive queries and raw dataset documentation are available in the public repository.