Abby's Portfolio

Data Analyst

April 17, 2023

About me...

I used to be a chartered company secretary but now looking for a change to the data indusrty.
I am a critical thinker, team player, and excellent communicator with a passion for telling stories with data.

May 09, 2023

Data Analytics Project with Tableau

The Olympic Games are one of the world's largest and most prestigious sporting events, with a history dating back to 1896. In this Dashbard, you will find some insights on how Olympic Games evolved in term of promoting the fairness and equality across gender and countries over the years from 1896 to 2016. Click here to go to my Tableau Public for more information!

April 17, 2023

My First
Website

It is common for those who work in tech industry to have their personal webpage. Today, after watching some online materials and learning some coding languages, my first website have been built! Any new projects will be uploaded to this page!

February 24, 2023

Data Analytics Project with Power BI

This is a Dashboard created with Power BI showing my findings and insights after maniulated the dateset provided by an online retail company. The purpose of this project was to help the company to increase their customer satisfaction. A presentation has been done in front of audience.

December 18, 2022

Data Analytics Project Python, SQL, Power BI

My first personal project which applied my self-taught data manipulation skills. The Netflix and IMDB dataset have been used and combined to give me insights about which movies and TV Shows worth to watch next! Just for fun:)

Janusry 24, 2023

Data Analytics Project with Python and SQL

This is a power point slide created with Python and SQL. Useful data have been retrived from a SQL database of a company. The retrived data was then imported to Visual Studio Code to do data cleaning, to build DataFrame using Pandas and to plot different charts using Matplotlib and Seaborn. One of the aims of this project was to help the company to identify the relationsip of two variable using a scatter chart. A presentation has been done in front of audience.

November 12, 2022

Data Analytics Project with SQL

It was an Introduction to SQL course held by Code First Girl. I have an in-depth understanding of SQL and be able to create a database, draw an ER Diagran from tables, write nested queries create a view, stored procedure and stored function.

October 11, 2022

Advanced Excel with Power Query

Excel is a very power tool and i have learnt lots of advanced Excel skills in Generation UK and LinkedIn Learning. Creating pivot tables/charts, applying advanced formula/functions, writing Power Query, working on data cleaning and conditional formating....