Data Science Learning Journey
I am going to record what I have learnt and milestones about data science.
An information retrieval platform for GDP, Life Satisfaction and Education Level
Facilisis dui. Nulla molestie risus in mi dapibus, eget porta lorem semper. Donec sed facilisis nibh.
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。
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.
Deep Work Author: Cal Newport
If you want to become a knowledge worker, prioritising deep work is crucial.
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.
BT Customer Churn Influencer
Tool: Python; Power BI
Boosting Revenues through Strategic Sales Analysis (DataCamp Capstone Project)
Lloyds Bank Customer Profiling
Tool: Power BI The novypro link: https://www.novypro.com/project/customer-segmentation-in-banking
Revenue increase strategy analysis for Google merchandise store
Tool: Google Analytics; Google Data Studio
ESG Analysis for Pfizer