– Data Collection and Processing:* Executed data collection from websites, including 10th grade entrance exam scores, national high school exam scores, and school benchmarks, along with market data.* Employed ETL techniques for data cleaning, ensuring stability and accuracy, while rectifyingresidual errors.* Executed integrated data into the data warehouse.– Stakeholder Collaboration and Dashboard Development:* Collaborated with stakeholders (Marketing, operations, product) to distill intricate requirements into effective analysis strategies.*Identified and analyzed pertinent data sources.* Calculations metrics and designed insightful dashboards including an Marketing dashboardshowcasing essential metrics (LTV and Retention Rate), updated on a daily and weeklybasis.* Validated outcomes for precision through meticulous manual and cross checks.– Advanced User Behavior Analysis and Insights:* Conducted research on user behavior (Churn, RFM, Time Behavior) using advanced models, revealing valuable insights.* Employed advanced models to comprehend and interpret user behavior, proactively identifying anomalous patterns and addressing backlogs.* Ensured the credibility of results through meticulous validation and cross-check processes.