Key Responsibilities

• Full Data Processing & Management
  • Handle full-process retail data processing and validation.
  • Conduct weekly data collection and checking for sales, activation, inventory, PSI, exhibition, and competitor product suppression ratio.
  • Aggregate KA channel data and ensure unified data standards.
  • Perform abnormal data troubleshooting and root‑cause analysis.
  • Ensure data accuracy, completeness, and consistency.
• Advanced Excel Data Processing
  • Perform multi-dimensional analysis using Pivot Tables, advanced formulas, Power Query, and data models.
  • Generate automated weekly and monthly reports.
  • Produce store rankings, achievement rates, year‑on‑year comparisons, and anomaly warnings.
  • Build dynamic dashboards and automated reporting tools.
• BI Visualization & Dashboard Development
  • Build Power BI retail d...