# 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://csse-uwa.gitbook.io/data-warehousing-lab-sheets/cits3401-5504-lab-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.