Project
Ivy's Portfolio Keywords
Business Analytics
Domain Knowledge
Evaluate market and understand customers by comparing business metrics
Science
Domain Knowledge
Understand the needed metrics to evaluate the performance in a quantitative way
Database
Technical Knowledge
Familiar with the principle of how to store data and use data
Cloud Computing
Technical Knowledge
Obsessed with cloud platforms, Azure and AWS
Exploratory Data Analysis
Techniques
Highlight interesting and important features in the data
Data Mining
Techniques
Uncover hidden patterns from data and transform it into business insights
Data Visualisation
Techniques
Communicate data in an understandable format
Data Story
![Post image 4](/images/Education Analysis.png)
Education-Focused Analysis: How Assessment Types Shape the Final Result
I used Power BI to explore the reasons why the mix and weightings of assessment types shaped the final result
![Post image 4](/images/Tableau Project.png)
A self-service platform for GDP, Life Satisfaction and Education Level
I used Tableau to build a self-service platform including information about GDP, Life Satisfaction and Education Level
![Post image 4](/images/BT Customer Churn Influencer (1).png)
BT Customer Churn Influencer
I used Power BI to visualise the features of churn customers in BT and used Python to calculate the key churn influencers.
![Post image 3](/images/design.png)
ESG Analysis for Pfizer
I used Python to analyse the position of Pifizer in the pharm industry and model the relationship between ESG scores and total assets
![Post image 3](/images/Revenue Increase Strategy.png)
Revenue increase strategy analysis for Google merchandise store
Tool: Google Analytics; Google Data Studio
![Lightning bolt symbol on red background](/images/Sales Analysis.png)
Boosting Revenues through Strategic Sales Analysis (DataCamp Capstone Project)
Tool: Excel
Data Tools
![Post image 4](/images/Database for Healthcare Research.png)
Data Platform Design for Healthcare Research
I used MySQL to create 11 tables for normalisation of clinical data and genetic data. The work is designed for healthcare research.
![Post image 4](/images/Normalisation.png)
Normalisation for professors in organisations with SQL Server
I used SQL Server to normalise a informative table. The project focused on details, like primary key, surrogate key, relationship, ON DELETE NO ACTION and so on.
![Post image 4](/images/Data Clean SQL Server.png)
3 Steps to Clean Data in SQL Server
I change my on-premise SQL tool to SQL Server now. I prepared clean data for data visualisation, there are 3 main steps to do.
![Post image 4](/images/Folder Strucutre (1).png)
5 Tips to Store an online zip file locally(Python)
In my first blog, I talked about how to create a more structured directory technically, including f-strings, os module, requests and ZipFile library.
![Post image 4](/images/Import SQLite File into SQL Server with Python and ChatGPT.png)
Import SQLite File into SQL Server with Python and ChatGPT
I learn how to use ChatGPT help achieve the connection between SQLite file and SQL Server with Python。