Extracted and aggregated financial, transaction, and pricing data for various operating entities from enterprise research databases using SQL and Excel, ensuring data readiness for analysis.
Cleaned and organized large datasets using Python, then calculated various hardware product indices (price, prosperity, and auxiliary) across diverse industries like kitchenware and electromechanical hardware.
Performed in-depth industry analysis based on the calculated Hardware Index system, identifying key market trends and providing actionable insights for strategic decision-making.
Authored 4 issues of the 'China Yongkang Hardware Market Transaction Weekly Price Index Review,' all officially published on the Ministry of Commerce's 'Business Forecast' website.