Blog
Data Science Learning Journey
I am going to record what I have learnt and milestones about data science.
![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/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。
![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/Deep Work Cover.png)
Deep Work Author: Cal Newport
If you want to become a knowledge worker, prioritising deep work is crucial.
![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/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.
![Lightning bolt symbol on red background](/images/Sales Analysis.png)
Boosting Revenues through Strategic Sales Analysis (DataCamp Capstone Project)
Tool: Excel
![Post image 3](/images/Neutral & Elegant Product Portfolio Presentation.png)
Lloyds Bank Customer Profiling
Tool: Power BI The novypro link: https://www.novypro.com/project/customer-segmentation-in-banking
![Post image 3](/images/Revenue Increase Strategy.png)
Revenue increase strategy analysis for Google merchandise store
Tool: Google Analytics; Google Data Studio