• Home
  • Project
    Introduction
    • Introduction
    • Background and Motivation
    • What is a Good Timetable?
    • Project Aims and Scope
  • Graph Data
    Model
    • Graph vs Relational Data Models
    • Graph Data Model for Timetabling
    • Early Insights
    • Model Expansion
    • Graphing Time
  • Data
    Pipeline
    • ETL Overview
    • Approach
    • Configuration and Logging
    • Extract
    • Transform
    • Google Drive Load
    • Neo4j Load
    • Reflection
  • Timetable
    Metrics
    • Timetable Metrics
    • Metric Aggregations
    • Implementing Metrics
    • TQI Summary
  • Final
    Thoughts
  • Appendices
    & Extras
    • Appendix Table of Contents
    • References
    • Acknowledgements
  • Word
  1. Supervision
  2. Notes Example 3
  • Home
  • Project Introduction
    • Introduction
    • Background and Motivation
    • What is a Good Timetable?
    • Project Aims and Scope
  • Graph Data Model
    • Graph vs Relational Data Models
    • Graph Data Model for Timetabling
    • Early Insights
    • Model Expansion
    • Graphing Time
  • Data Pipeline
    • ETL Overview
    • Approach
    • Configuration and Logging
    • Extract
    • Transform
    • Google Drive Load
    • Neo4j Load
    • Reflection
  • Timetable Metrics
    • Timetable Metrics
    • Metric Aggregations
    • Implementing Metrics
    • TQI Summary
  • Final Thoughts
  • Appendices
    • Random Graph Generator
    • Technology Stack
    • Configuration
    • Anonymisation
    • ETL Summary and Code
      • ETL Summary
      • ETL Code
      • Config and Misc
      • Extract-SQL
      • Extract
      • Google Drive Load
      • Transform
      • Neo4j Load
    • Neo4j & Cypher Code
      • Cypher Queries
      • Creating Nodes and Relationships
      • Deleting Nodes and Relationships
      • General Queries
      • Count Queries
      • Hard (timetabling) Constraints
      • Student Clashes
      • Soft Constraints
      • Rooms and Spaces
      • Perspectives
      • Blue Skies Opportunities
  • Supervision
    • Supervision
    • Notes Example 1
    • Notes Example 2
    • Notes Example 3
  • References
  • Acknowledgements

On this page

  • Summary
  • Accomplishments
  • Next Steps
    • Weekly Goal: What is goal of week?
  • Issues/Blockers
  • Post-Meeting Notes
  • Additional Notes
  1. Supervision
  2. Notes Example 3

Fortnightly Update - 2024-07-08

Summary

  • This week has been primarily based on getting the ETL pipeline working.
  • Some thought and planning about the overall project

Accomplishments

  • Project Management
    • Planned next 6 weeks - high level
  • Data Collection:
    • N/A
  • Analysis / Wrangling:
    • N/A
  • Model Development:
    • The ETL is (hopefully) production ready.
  • Results:
    • Functioning ETL which:
      • Extracts -> Filters -> Cleans -> Transforms -> Anonymises -> Uploads to Google Drive -> Loads to Neo4j
      • Configurable, scalable, modular
      • Logging, Error-handling

Next Steps

Weekly Goal: What is goal of week?

  • Project Management
    • Plan next six weeks - with tasks
    • see project-structure
  • Data:
    • Clear out database and repopulate
    • Run ETL for some programme - e.g. UG maths, PG Data Sci, PG AI, PG cyber
    • Consider Unit Tests
  • Analysis / Wrangling:
    • Develop and explore Cypher quality and violation queries
    • see queries
  • Modeling:
    • Consider different model of time as nodes (but probably will not develop)
  • Writing
    • After ETL confirmation - fully documentation of code
      • Also write up into QMD doc
      • Visualiation - Data Flow Diagram?
    • Model section write up
      • SQL data model
      • Graph data model
      • Visualisations
      • see code-critique
    • Draft Intro
      • Proof of concept
      • Research question
      • Domain

Issues/Blockers

  • Technical:
    • Main limitations are free Neo4j Aura software and other restrictions
  • Methodological:
    • Need to think about what I want to deliver and how it looks

Post-Meeting Notes

  • Key Decisions: What were the main takeaways from meeting?
    • I need to focus on making progress and think about what the final produce will be.
  • Action Items: What tasks do you need to complete?
    • see above - write up sections, even if draft

Additional Notes

  • Literature Review: Relevant papers read.
  • Experiments: If applicable, describe any experiments conducted.
  • Code: Embedding example snippets of code.
Notes Example 2
References

Copyright 2024, Petter Lövehagen

 

Built with Quarto