> For the complete documentation index, see [llms.txt](https://csse-uwa.gitbook.io/data-warehousing-lab-sheets/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://csse-uwa.gitbook.io/data-warehousing-lab-sheets/cits3401-5504-lab-sheets.md).

# 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

<table data-full-width="true"><thead><tr><th width="109">Week #</th><th width="183">Date Starting</th><th width="337">Lab Topic</th><th width="149">Assessment</th><th>Comments</th></tr></thead><tbody><tr><td>Week 2</td><td>02/03/2026</td><td><a href="/pages/iC8ZeQ6bAhe915fCJQWg">Software Setup</a></td><td>N/A</td><td>In Week 2, no Monday lab sessions due to Labour Day.</td></tr><tr><td>Week 3</td><td>9/03/2026</td><td><a href="/pages/veXpxvMrZVmdkE2nXAmn">Extract, transform, and load (ETL)</a></td><td>N/A</td><td></td></tr><tr><td>Week 4</td><td>16/03/2026</td><td><a href="/pages/qjNyqNcqAxzGsvjvOeWC">Designing a New Data Warehouse</a></td><td>N/A</td><td><p>The UWA Student Guild has nominated Wednesday, 18th March as PROSH day for 2026. Charity activities only in the morning.</p><p>No lab session on 18th March morning.</p></td></tr><tr><td>Week 5</td><td>23/03/2026</td><td><a href="/pages/ybdsMKcHRnV8zkHq7J3A">Mini End-to-End Data Warehouse Project</a></td><td>Week 5 Lab demo</td><td></td></tr><tr><td>Week 6</td><td>30/03/2026</td><td><a href="/pages/AhVgdaYcm3KpqVLGCeer">Association Rules Mining</a></td><td>Week 5 Lab demo cont'd</td><td>In Week 6, no Friday lab sessions due to Good Friday.</td></tr><tr><td><strong>Study Break</strong></td><td><strong>06/04/2026</strong></td><td></td><td></td><td></td></tr><tr><td>Week 7</td><td>13/04/2026</td><td>Project 1 Consultation</td><td>N/A</td><td></td></tr><tr><td>Week 8</td><td>20/04/2026</td><td><a href="/pages/8qvkGGm8DqYmdRiMZxXr">Neo4j</a></td><td>N/A</td><td></td></tr><tr><td>Week 9</td><td>27/04/2026</td><td><a href="/pages/OtMGcnojy0MJ1HkCwlqm">Import data from a relational database into Neo4j</a></td><td>N/A</td><td>In Week 9, no Monday lab sessions due to ANZAC Day.</td></tr><tr><td>Week 10</td><td>04/05/2026</td><td><a href="/pages/GlIQ0TGXJxF7L2obrxP6">Cypher Queries</a></td><td>N/A</td><td></td></tr><tr><td>Week 11</td><td>11/05/2026</td><td><a href="/pages/G29AClWtvPbGkTruIv0N">Advanced Cypher and APOC</a></td><td>N/A</td><td></td></tr><tr><td>Week 12</td><td>18/05/2026</td><td><a href="/pages/4NOuQu8CUxfAAsyOHxRk">Graph Data Science</a></td><td>N/A</td><td></td></tr></tbody></table>

## **Lab Assessments**

<table data-full-width="true"><thead><tr><th align="center">Assessment Tasks</th><th align="center">Weight	</th><th align="center">Assessment period/date/s</th><th align="center">Submission Procedure</th></tr></thead><tbody><tr><td align="center">Week 5 Lab Demo</td><td align="center">5%</td><td align="center">2/4 11:59 PM</td><td align="center">During Weeks 5 and 6 labs</td></tr></tbody></table>

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.&#x20;
* [Dr Michael Stewart](https://research-repository.uwa.edu.au/en/persons/michael-stewart) for the initial development of  exercises for the graph database