Projects
​My data projects are described more thoroughly at my Github
Data Camp, 2021
This project analyzes international debt data collected by The World Bank using SQL. The dataset contains information about the amount of debt (in USD) owed by developing countries across several categories. The questions varies, for example:
​
-
What is the total amount of debt that is owed by the countries listed in the dataset?
-
Which country owns the maximum amount of debt and what does that amount look like?
-
What is the average amount of debt owed by countries across different debt indicators?
Data Camp, 2021
-
The project explores data from BusinessFinancing.co.uk on the world's oldest businesses using SQL querying techniques.
​
-
I practiced practice how to select columns from a table, filtering for rows where they meet a criterion, using aggregation functions, determining the order of rows in the result, performing calculations on groups of rows, filtering grouped data and joining two-three tables by Inner Join.
​Self project, 2021
I created an interactive resume using Microsoft PowerBI. The steps are described below:
​
1. Create a dataset in tabular format by MS Excel (5 tables: Education & Experience, Course & Certificates, Languages, Skills, Activities and Projects)
2. Define an ID for each row to create the relationships between tables in PowerBI
​
3. Create a dashboard
​
4. Publish
​
*Notes: Since I graduated and no longer hold a licenses for PowerBI, information in the published version cannot be updated.
Danny Ma's 8 weeks challenge, 2021
-
The case study aims to use SQL to make use of data for a restaurant.
​
-
​The dataset contains three tables: sales, menu and members
​
-
I extracted the data to gain insights about the customers, especially about their visiting patterns, how much money they’ve spent and also which menu items are their favourite.
SQL Zoo, 2022
The project's data is based on Microsoft's AdventureWorks database, including 10 tables:
​
-
Customer
-
CustomerAddress
-
Address
-
SalesOrderHeader
-
SalesOrderDetail
-
Product
-
ProductModel
-
ProductCategory
-
ProductModelProductDescription
-
ProductDescription
SQL Zoo, 2022
The challenge's data is based on the "Neeps" database includes details of all teaching events in the School of Computing at Napier University in Semester 1 of the 2000/2001 academic year
​
The database has 9 tables, including:
​
-
Staff
-
Student
-
Room
-
Event
-
Attends
-
Teaches
-
Occurs
-
Modle
-
Week
