This technical audit evaluates the environmental impact of Intel's 2024 repurposing program. Using datasets modeled after Intel's real-world data structure, this analysis identifies which device categories should be prioritized to maximize sustainability efforts and reduce global e-waste.

The analysis covered a total of 601,740 devices repurposed in 2024. Key sustainability metrics include:

• Energy Savings: The program removed the equivalent of almost 1,500 US homes from the power grid for a year.
• Carbon Reduction: Total CO2 emissions saved (6,768 tons) is equivalent to removing 1,500 cars from the road.
• The Age Paradox: While newer devices (≤ 3 years) are the most frequently repurposed, older devices (> 6 years) yield the highest average energy and CO2 savings per unit.

The audit was performed using SQL to join specifications with impact data and perform multi-layered aggregations.

Core SQL Competencies Demonstrated:

• Joins: Merged intel.device_data with intel.impact_data to create a comprehensive analysis set.
• Common Table Expressions (CTEs): Utilized the WITH keyword for organized, multi-step data processing.
• Conditional Logic: Engineered age-based segmentation (Newer, Mid-Age, Older) using CASE WHEN clauses.
• Advanced Aggregation: Calculated weighted averages and regional totals for energy (kWh) and carbon (kg/tons) metrics.

Based on the analysis, the following actions are recommended to optimize Intel's sustainability ROI:

1. Prioritize Mid-Aged Laptops: Focus on mid-aged devices in Asia and North America, as they represent 36% of all refurbished devices and offer a strong balance of volume and impact.
2. Optimize Inventory Mix: Increase laptop refurbishing to 85% of the total mix by 2032 to leverage their superior energy efficiency and portable utility.
3. Strategic Scaling: Ramp up the repurposing of older devices in all regions to 10% of total volume by 2032 to capture the highest possible environmental benefit per device.

Please note that the underlying datasets used for this analysis were hosted in a specialized SQL environment and were not available for export. This repository serves as a record of the SQL logic and strategic analysis performed during the project, as well as the final results and recommendations derived from that data.

Technical Report: For a detailed breakdown of the methodology, regional carbon intensity factors, and iterative strategy reflections, see the included Intel_Sustainability_Technical_Audit.pdf.