AMT-BDR3 RFP Customer Reviews Analysis

Closed
Main contact
Ami Tea & Sub
Calgary, Alberta, Canada
Binh Nguyen
Business Development Lead
(9)
4
Portals
(1)
Project
120 hours per learner
Learner
Canada
Advanced level

Project scope

Categories
Data analysis Data modelling Data science Data visualization
Skills
data analysis data cleansing quality control competitive analysis customer engagement operational efficiency data manipulation data science proofreading project management
Details

The AMT-BDR3 Customer Review Analysis project, as part of the Ami Tea & Sub 2024-2025 Business Development Roadmap (BDR) Initiative, seeks to leverage advanced data analytics to enhance customer experience and business performance. This project focuses on developing a PowerBI-driven customer sentiment dashboard to accurately measure customer preferences and track feedback across various platforms. Advantages of a Customer Review dashboard include:


  1. Enhanced Customer Experience Insight, where PowerBI utilization would aggregate and analyze reviews from multiple sources, including social media and online platforms to develop an intuitive dashboard that can capture sentiments, preferences, and dissatisfaction points.
  2. Data-Driven Operational Improvements, which will highlight key areas that need improvement, such as menu items, service speed, or ambiance. This can create momentum for management to pursue alternative strategies in customer engagement or refine current training standards.
  3. Strategic Business Decision-making, which aims to provide actionable insights to drive strategic decision-making. This includes menu optimization, marketing strategies, and potential aeras for expansion or renovation.

 

What is its strategic implications?

 

The strategic implications of the AMT-BDR3 Customer Review Analysis project for Ami Tea & Sub are multifaceted, especially when considering the disparity in customer preferences and performance across different locations, such as the contrast between Inglewood/Chinatown and mom n' pop-owned stores like Heritage or St. John. This project's focus on developing a PowerBI-driven dashboard to analyze customer sentiment and feedback is not just about harnessing data; it's about understanding the underlying factors contributing to these inconsistencies.

 

Firstly, the analysis may reveal gaps in staff training or management practices at underperforming locations. The difference in staff numbers and the consequent variation in customer experience underscore the need for a standardized training protocol and quality control measures across all franchisees. For a franchisor like Ami Tea & Sub, ensuring consistency in customer experience is paramount. It's not just about maintaining the brand's reputation; it's also about delivering the promise of quality and service that customers expect from a franchised establishment, regardless of its location.

 

Furthermore, the insights gained from this project will enable Ami Tea & Sub to align its operational strategies with the dynamic and location-specific customer preferences. This is crucial in tailoring menu offerings, marketing efforts, and overall customer engagement strategies to meet the unique demands of each locale. By understanding the nuances of different market segments, Ami Tea & Sub can optimize its operations to cater effectively to diverse customer bases.

 

Additionally, the project aligns with best practices identified in the DTTP Competitive Analysis, which highlights that major F&B chains are increasingly investing in data analytics. This not only validates the approach but also sets a foundation for Ami Tea & Sub to explore and integrate advanced data analytics into its business model. By doing so, Ami Tea & Sub is not merely catching up with industry standards but is also positioning itself to proactively leverage data for strategic decision-making, future-proofing the business in a highly competitive market.

 

Goals that this project supports:

Primary Goals

  1. Standardization of Training and Quality Control: Implement a comprehensive training program across all Ami Tea & Sub locations, focusing on service quality and operational efficiency, to address inconsistencies and elevate customer experience, especially in underperforming areas.
  2. Location-specific Operational Optimization: Tailor operations and menus at each customer sentiment to boost satisfaction and performance, particularly in locations currently lagging behind in customer preferences.
  3.  Immediate Data Integration and Analysis Capability Enhancement: Rapidly deploy a user-friendly PowerBI dashboard for real-time customer feedback analysis, enabling quick operational decisions.


Secondary Goals

  1. Brand Consistency and Reputation: Enhance Ami Tea & Sub’s brand reputation for quality and consistency through long-term customer feedback monitoring ad continuous service improvement.
  2. Strategic Business Expansion and Innovation: Utilize customer data insights for market expansion, new products innovation, and service enhancement.
  3. Industry Leadership in Data-Driven Decision-Making: Position Ami Tea & Sub as an emerging industry leader in data analytics within the Vietnamese F&B sector, continually investing in advanced tools and fostering a culture of evidence-based decision-making.

 

What areas will be covered?

The AMT-BDR3 Customer Analysis Project covers the following four areas:

  1. Data Acquisition and Cleanup: involving the systematic collection of customer feedback data from various sources such as social media, online review platforms, and in-store feedback forms. Potential tasks include: establishing data collection protocols, setting up automated data scraping tools if necessary, and performing data cleaning and preprocessing to ensure accuracy of data before the analysis.
  2. Development of PowerBI Dashboard: this is the core of the project, which is intended to provide intuitive and insightful visualization of customer feedback data based on the appropriate user level. Potential tasks include: designing the dashboard layout, configuring data import and visualization tools, and ensuring that the dashboard is user-friendly and can display real-time data effectively.
  3. Data Manipulation and R-Programming Integration: deals with the integration of advanced data analysis techniques, particularly R for sentiment analysis, to glean deeper insights from customer feedback data. Potential tasks may include writing R scripts for sentiment analysis, manipulating and transforming data to suit the analysis needs, and integrating R scripts with PowerBI for seamless flow of processed data.
  4. End-user Training and Feedback (Deck Development): Final stage is crucial for ensuring that the insights derived from the dashboard are actionable and accessible to decision-makers within Ami Tea & Sub. This process may entail developing simplified training materials for end-users. 


Deliverables

The Riipen ICT Data Science team is tasked with creating three key deliverables for the AMT-BDR3 Customer Reviews Analysis project: 1) Develop a user-friendly and interactive PowerBI dashboard that integrates various data sources for comprehensive analysis. 2) Produce a concise, five-page recommendation report for management, detailing key insights and actionable strategies derived from the data analysis. 3) Create an engaging and informative end-user training deck, outlining the functionalities of the PowerBI dashboard, data interpretation techniques, and usage best practices. This process may include sub-deliverables or work-in-progress updates to inform the project manager on the timeline. 


Mentorship

The project manager will provide the necessary support and resources throughout the project such as raw data, project rubric/evaluation guides, specific requirements or access to reviews/social media platforms as needed. However, it's important to note that while the project manager is committed to learning alongside the team, they are not an expert in technical data analysis. Therefore, the team is expected to come equipped with the requisite data analysis skills as outlined in the Riipen ICT Data Science program requirements. 


Supported causes

The global challenges this project addresses, aligning with the United Nations Sustainable Development Goals (SDGs). Learn more about all 17 SDGs here.

Decent work and economic growth

About the company

Company
Calgary, Alberta, Canada
11 - 50 employees
Food & beverage

☕ Ami Tea & Sub Inglewood is your one-stop shop for authentic Vietnamese street food and Taiwanese boba milk tea. We dedicate our hearts to blending bold flavors and intimate friendships together, one cup of tea at a time. Our story began in 2018 when we first started as a small family-owned Taiwanese milk-tea and Vietnamese bánh mì vendor at the heart of Calgary’s vibrant Chinatown. For the first time in our lives, we realize just how powerful familiar tastes were; of how a slight tinge of coriander leaf, concealed amidst the piquant mix of marinated satay beef could mean a world of differences to a cultural food enthusiast.

We began our digital transformation almost a year ago and have made impressive strides (You can check us out at @amiteacanada). We're looking for passionate and talented students who can help us create fun videos that promote our stores in exchange for free bubble tea and delicious tasting Vietnamese subs!