Ivy's Portfolio Keywords
Evaluate market and understand customers by comparing business metrics
Understand the needed metrics to evaluate the performance in a quantitative way
Familiar with the principle of how to store data and use data
Obsessed with cloud platforms, Azure and AWS
Exploratory Data Analysis
Highlight interesting and important features in the data
Uncover hidden patterns from data and transform it into business insights
Communicate data in an understandable format
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.
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.
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.
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.
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。