Data Science Learning Journey

I am going to record what I have learnt and milestones about data science.

Post image 4

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

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

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。

Post image 4

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

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

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

Deep Work Author: Cal Newport

If you want to become a knowledge worker, prioritising deep work is crucial.

Post image 4

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

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.

Lightning bolt symbol on red background

Boosting Revenues through Strategic Sales Analysis (DataCamp Capstone Project)

Tool: Excel

Post image 3

Lloyds Bank Customer Profiling

Tool: Power BI                                                            The novypro link:

Post image 3

Revenue increase strategy analysis for Google merchandise store

Tool: Google Analytics; Google Data Studio