PHAM Quang-Minh

BUSINESS ANALYTICS (60%):

• Customer segmentation using RFM analysis: Identify potential customer groups to maximize the marketing campaign performance and budget distribution

Result: Identify & target first-class customers in actual marketing campaigns & receive demand from Groups to expand this activity

• Customer churn prediction model (from end to end): increase customer retention

Result: Warning at the highest level for focusing on improving essential metrics

• Optimal pricing model: find optimal price based on different segments of customers, markets, and opponents)

Result: The CEO from Group and Local agreed to keep the product pricing policy the same as last year

• A/B testing application: collect surveys and create A/B testing to identify the potential of marketing campaigns

Result: Terminate ongoing low-performance campaigns

• Supply Chain demand planning system: using data from local servers and BigQuery to forecast material demand
• Ad-hoc reports answering specific needs

BUSINESS INTELLIGENCE & REPORTING SYSTEM (30%): Result: Increase internal users by 82% compared to last year

• Collaboratively create a new reports system for internal users to replace the SSRS system
• Power BI reports for tracking KPIs and predicting demand
• Reports building from Department requests

TECHNICAL TRAINING & CONSULTING (10%): Power BI training for Area Restaurant Manager & other departments

• Technical consulting about analysis methodology and tool application for Data Analysts in other Departments
• Creating technical documents about tool utilization (Power BI)

• Enhanced business efficiency by identifying trends and patterns in complex datasets.
• Streamlined data processing for faster results by implementing advanced analytics tools.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.