跳到正文
Jimmy Huang's Blog
动态
学习
作品
影视
书籍
游戏
相册
更多
影视
书籍
游戏
相册
主题
墨水
苹果
岛屿
千禧
明暗跟随系统
B 站
小红书
最近
看过
想看
最近
在读
已读
想读
弃读
最近
在玩
通关
想玩
最近
学习
Pre and Post Data Warehousing · Jimmy Huang's Blog
课程目录
学习
←
Week 3 Data Warehousing and Data Cleaning
学习
›
C6001
›
2025 S2
›
FIT5137 Advanced database technology
›
Week 3 Data Warehousing and Data Cleaning
Pre and Post Data Warehousing
Pre and Post Data Warehousing
这一页没有正文。
在本课程目录里查找
课程目录
About
Week 1 Overview
›
Summary
Week-1a-Overview
Week-1b-Intro-Data-Engineering
Week-1c-Why We Need Data Warehousing
Week-1d-DE-Architectures
Week-1e-Intro-Data-Warehousing
Week-1f-SQL-revision-VSCode-DBeaver
如何下载DBeaver到Mac
Lab SQL Revision
Week 2 Data Transformation and Data Warehousing
›
Chapter02-Simple Star Schemas
Chapter03-Creating Facts and Dimensions—More Complex Processes
Docker-Based Installation
Star Schemas
Week 3 Data Warehousing and Data Cleaning
›
Feedback Session
›
Feedback Session 2a
Feedback Session 2b
Feedback Session 2c
Data cleaning case-1 (USELOG)
Data cleaning case-2 (ROBCOR)
Pre and Post Data Warehousing
Lab-03a Uselog
Lab-03b RROBCOR
Additional Material – Data Cleaning
Week 4 Bridge Tables and Hierarchies
›
Q & A
Chapter 4 Hierarchy
Chapter 5 Bridge Tables
Star schema VS Snowflake schemas
Lab04 Bridge Table
Assignment 1:Take Home Quiz - 10%
›
Specification
›
Case Study: Gracie Music Learning Centre
Week 5 Multi-Fact and Multi-Input
›
Q & A
Feedback Session
Chapter 7: Determinant dimensions
Chapter 11: Multi-Fact
Chapter 12: Slicing a Fact
FIT5137-Lab05-Multifact
Week 6 Data Architecture and Granularity
Week 7 Introduction to Spatial Databases
Week 8 Spatial Functions
Assignment 2: Data Warehouse Major Assignment - 40%
›
Specification
Marking Guide
Week 9 Spatial Queries
Week 10 Spatial Queries and QGIS
Week 11 Spatial Indexing and Crowdsource Spatial Data
Assignment 3 : PTV Assignment - 35%
›
Specification
Marking Guide
Week 12 Revision & Potential Projects
Assignment 4 : Spatial Quiz - 15%
›
Specification
上一篇
Data cleaning case-2 (ROBCOR)
下一篇
Lab-03a Uselog