Clare Li (Zixuan Li)

Course Project | PostgreSQL, Python, Tableau, Neo4j, Cypher
Individually transformed Australian road crash data using Python (pandas), built a star-schema warehouse in PostgreSQL, and visualized analytical outcomes in Tableau. Additionally, designed a graph database with Neo4j, and wrote Cypher queries to uncover crash patterns by location and driver profile.

Group Project | Power BI, DAX, Data Visualization
Collaborated in a team to analyze multi-year UK financial product data. Built dashboard sections in Power BI using slicers and custom DAX to present borrower types and mortgage structures. Scored 28/30 (HD).

Group Project | Raspberry Pi, Python, AWS, Flask

Led a team of 5 to develop a motion-triggered smart doorbell using Raspberry Pi. Implemented Python scripts for sensor control, configured AWS services, and built a Flask dashboard for real-time monitoring. Oversaw full project lifecycle from planning to deployment.

Capstone Project | WordPress, Figma, SEO, CSS, Javascript

Contributed to the revamp of a startup’s client website using WordPress. Participated in client meetings, proposed layout redesigns for blog and case study pages, and implemented improvements aligned with SEO and branding strategy.