CITS3401/5504 Lab Sheets

Welcome to the CITS3401/5504 lab sheets pages!

This set of lab sheets covers the data warehouse design and graph database exercises using Neo4j.

Lab Structure

Week #	Date Starting	Lab Topic	Assessment	Comments
Week 2	02/03/2026	Software Setup	N/A	In Week 2, no Monday lab sessions due to Labour Day.
Week 3	9/03/2026	Extract, transform, and load (ETL)	N/A
Week 4	16/03/2026	Designing a New Data Warehouse	N/A	The UWA Student Guild has nominated Wednesday, 18th March as PROSH day for 2026. Charity activities only in the morning. No lab session on 18th March morning.
Week 5	23/03/2026	Mini End-to-End Data Warehouse Project	Week 5 Lab demo
Week 6	30/03/2026	Association Rules Mining	Week 5 Lab demo cont'd	In Week 6, no Friday lab sessions due to Good Friday.
Study Break	06/04/2026
Week 7	13/04/2026	Project 1 Consultation	N/A
Week 8	20/04/2026	Neo4j	N/A
Week 9	27/04/2026	Import data from a relational database into Neo4j	N/A	In Week 9, no Monday lab sessions due to ANZAC Day.
Week 10	04/05/2026	Cypher Queries	N/A
Week 11	11/05/2026	Advanced Cypher and APOC	N/A
Week 12	18/05/2026	Graph Data Science	N/A

Lab Assessments

Assessment Tasks	Weight	Assessment period/date/s	Submission Procedure
Week 5 Lab Demo	5%	2/4 11:59 PM	During Weeks 5 and 6 labs

Credit to:

• Miss Ming Gao and Mr Chris Jongue for updating the lab instructions for the Databricks part.

• Mr Man Qin and Miss Xia Cheng for updating the lab instructions for the new software environment and descriptions.

• Mr Pascal Sun and Mr Jichungyang Li for re-developing the lab instructions for the new software environment.

• Dr Michael Stewart for the initial development of exercises for the graph database