Lab 1 Exercise 2 - 4
Madina Suraya Binti Zharin A20EC0203
Exercise 2
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\LabExercise_Dataset\LabExercise_Dataset\GiftRecords.xlsx|||<List of Sheet Names>
False
1
GiftRecords.xlsx
Query=<List of Sheet Names>
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\LabExercise_Dataset\LabExercise_Dataset\GiftRecords.xlsx|||<List of Sheet Names>
False
1
ReadList
Sheet Names
FileName
Simple
=
City
True
fixed
2022-11-14 12:23:51
0
San Francisco
2022-11-14 12:23:51
2022-11-14 12:23:51
[City] = "San Francisco"
College - Ascending
Gift Amount - Descending
Exercise 4
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\LabExercise_Dataset\LabExercise_Dataset\EduFunGames.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
EduFunGames.csv
Category - Ascending
Sum_Sales = [January_Sales]+[February_Sales]+[March_Sales]+[April_Sales]+[May_Sa...
Exercise 3
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\LabExercise_Dataset\LabExercise_Dataset\PSDA LIST ALL STUDENTS_AIMSWEB.xlsx|||`ALL STUDS PSDA$`
False
1
PSDA LIST ALL STUDENTS_AIMSWEB.xlsx
Query=`ALL STUDS PSDA$`
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\LabExercise_Dataset\LabExercise_Dataset\PSDA BY SECTION.xlsx|||Sec_
False
False
False
RemoveFile
Suffix
SEC
PSDA BY SECTION.xlsx
Query=Sec_
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\LabExercise_Dataset\LabExercise_Dataset\SECI2143-00-MIDTERM TEST-grades.xlsx|||`SECI2143-00 MIDTERM TEST$`
False
1
SECI2143-00-MIDTERM TEST-grades.xlsx
Query=`SECI2143-00 MIDTERM TEST$`
Horizontal
Lab1Ex2-4_MadinaSuraya_A20EC0203