Sisi Yao
Data Analysis Projects
In this project, I, as the data analyst reporting to Maven Telecom's Head of Customer Retention, am tasked with
-
Identifying high value customers and top churn reasons among them;
-
Making recommendations on how to best retain them
Components of the project and tools used:
-
SQL (data preparation, cleaning and analysis)
-
Tableau (Interactive dashboard to monitor churn)
-
Deck Presentation
In this project, I take on the role of a business analyst who reports to the VP of Marketing. With the data that was made available to me, I answer the key questions:
-
Which campaigns should the VP pause/focus on?
-
What should the VP focus their marketing effort on?
Components of the project and tools used:
-
SQL (data cleaning, data analysis)
-
Tableau (data visualization and dashboard)
-
Deck presentation
Founded in 2015, Olist is a Brazilian B2B ECommerce marketplace that is leading the way as the no.1 commerce enabler for SMBs in Brazil (Crunchbase). Olist connects small businesses from all over Brazil to merchants with a single contract, those merchants are able to sell their products through the Olist Store and ship them directly to the customers using Olist logistics partners.
​
In this analysis, I take on the role of a data analytics consultant hired by Olist. With anonymized data from Olist (Kaggle), I provide actionable insights that help Olist improve its processes.
This analysis is done in three parts based on Olist's business model (and available data):
​
-
Buyer Experience
As a two-sided marketplace, Olist's business model is based on bringing buyers and sellers together, the business thrives when the two sides transact. As Josh Bereinlinger, a venture capitalist from Sigma West once said: "It's easy to find people that want to make money, it's much harder to find people that want to spend money.", providing a seamless user experience to the demand side (buyers) is crucial to Olist. Two important aspects of a pleasant buyer experience are product satisfaction and delivery satisfaction. ​
-
Sales Transactions
Olist's top line is closely related to the gross transaction value, it is crucial that the team identifies and monitors its top earning categories, and prioritizes meeting the expectations of buyers in those areas.
-
Marketing Funnels (Sellers)
The marketing funnel's focus should be on bringing in more sellers in the top earning categories at the lowest acquisition cost (labour for example).
In this project, I use the available data to answer one question:
what’s the winning strategy for advertisers to get the best ROI on their spend?
​
Components of the project and tools used:
-
Tableau (for EDA and Data Visualization)