iTa'LeEm
SEM2 INFO 4311 Section 01 DATA WAREHOUSING
0%
Previous
Course data
عام
Announcements
Instructor's Sem 2 2023/2024 Timetable
INFO 4311 Course Plan Sem 2 2023/2024 4 Mar 2024
KICT SEMESTER 2, 2023/2024
FINAL ASSESSMENT - 40%
GROUP PROJECT - 30%
Group Self-Selection for Project
Group Project
QUIZ - 20%
Quiz 1 - 10%
LESSON 1: DATABASE CONCEPTS
LESSON 2: INSTALLATIONS
Software Installers (Windows OS)
Slides for Microsoft SQL Server Developer and SSMS Installation Steps
Recording of Microsoft Visual Studio Community 2019 Preview Installation
Recording of Microsoft Power BI Installation
Help with installing SQL Server on a macOS
Learning Microsoft SQL Server and related tools
Learning Microsoft Power BI
LESSON 3: DATA SOURCE
ACTIVITY 2: Setting up the Data Source - Employee Timesheet Database for Class Data Warehouse Case Study
LESSON 4: DATA WAREHOUSE DESIGN
In-Class Case for ACTIVITY 3: Employee Timesheet
Dimensional Modeling Workbook
Activity 3: Dimensional Modeling - Data Warehouse Bus Matrix
Employeee Payroll Bus Matrix
Completed Employee Timesheet Dimensional Modeling Workbook
Activity 4: Physical Design - Creating the Employee Payroll Data Warehouse Schema
LESSON 5: DATA INTEGRATION
Employee Timesheet Dimensional Modeling Workbook with ETL Rule Column
SQL program to insert dates to Date Dimension table
LESSON 6: BUSINESS INTELLIGENCE APPLICATION
LECTURE SLIDES
Week 1 (4 - 10 Mar 2024): Introduction
Week 1 (4 - 10 Mar 2024): Introduction to Data Warehousing
Week 2 (11 - 17 Mar 2024): Business Intelligence (BI) Technical Architecture
Week 3 (18 - 24 Mar 2024): Data Warehouse Design and Methodology
Week 5 (1 - 7 Apr 2024): Dimensional Modeling Concepts
Week 6 (15 - 21 Apr 2024): Dimensional Modeling
Week 8 (29 Apr - 5 May 2024): DW Development - Physical Design
Week 9 (6 - 12 May 2024): Extraction, Transformation and Loading (ETL) - Components
Week 10 (13 - 19 May 2024): ETL Design and Development
ETL Architecture’s 34 Subsystems - Kimball Group Site
Week 11 (20 - 26 May 2024): ETL using SSIS
Top 10 common transformations in SSIS
VIDEO RECORDINGS
Week 6 (15 - 21 Apr 2024): Dimensional Modeling - Part 2
Random YouTube on "Slowly Changing Dimensions"
Next
iTa'LeEm
واجهة جانبية
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
2019/2020 Academic Session
العربية (ar)
Bahasa Melayu (ms)
English (en)
العربية (ar)
تسجيل الدخول
Course Navigation
INFO 4311_01 SEM2
Site Navigation
الصفحة الرئيسية
تجاوز إلى المحتوى الرئيسي
معلومات المقرر الدراسي
الصفحة الرئيسية
المقررات الدراسية
Session 2023/2024 Semester 2
INFORMATION & COMMUNICATION TECHNOLOGY
INFO 4311_01 SEM2
الملخص
SEM2 INFO 4311 Section 01 DATA WAREHOUSING
Instructor:
LILI MARZIANA BT. ABDULLAH 4559
Skill Level
:
Beginner