Madina Suraya Binti Zharin (A20EC0203)
Adrina Asyiqin Binti Md Adha (A20EC0174)
Lab 3
Question 2
Yes
Model_Comparison
C:\Users\USER\AppData\Local\Temp\Engine_19668_71c9c6ecb320fe4cad908a5c45389c1e_\Engine_19668_813b82e024657041ab48c23f2bbc7005~.yxdb
Single
Profile
C:\Users\USER\AppData\Local\Temp\Engine_19668_71c9c6ecb320fe4cad908a5c45389c1e_\Engine_19668_1d242d869f506f4b930b5039116661cd~.yxdb
Single
Profile
C:\Users\USER\AppData\Local\Temp\Engine_19668_71c9c6ecb320fe4cad908a5c45389c1e_\Engine_19668_eaa5f563c10214438c82e0061df50c3f~.yxdb
Single
Report
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Dataset\customers.xlsx|||`sheet1$`
False
1
customers.xlsx
Query=`sheet1$`
,
Text
70
20
1
Responder
Yes
50
Home
advanced
True
False
Logistic_Regression
Responder
Consumer,Corporate,Home_Office,Small_Business
False
False
0.5
False
False
5
lambda_1se
False
1
0.5
logit
False
5
3
False
False
1
1x
Logistic_Regression
C:\Users\USER\AppData\Local\Temp\Engine_19668_71c9c6ecb320fe4cad908a5c45389c1e_\Engine_19668_990883f4256dee4ea459fccfaf6c9b11~.yxdb
Single
Report
C:\Users\USER\AppData\Local\Temp\Engine_19668_71c9c6ecb320fe4cad908a5c45389c1e_\Engine_19668_262bd45eb498674e93afdf2deeaa20cd~.yxdb
Single
Report
Understand Data
Customer ID=True,Store Number=True,Responder=True,Consumer=True,Corporate=True,Home_Office=True,Small_Business=True
False
True
5000
False
10
Single
Report
Question 1
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Dataset\SUPERSTORE ORDERS_20162019.xlsx|||<List of Sheet Names>
False
1
SUPERSTORE ORDERS_20162019.xlsx
Query=<List of Sheet Names>
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Dataset\SUPERSTORE ORDERS_20162019.xlsx|||`2016$`
False
1
ReadList
Sheet Names
FileName
C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Dataset\ORDERS_*.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
ORDERS_*.csv
Order Date
English
dd/MM/yyyy hh:mm:ss
Order Date New
Convert Order Date From:
dd/MM/yyyy hh:mm:ss
Ship Date
English
dd/MM/yyyy hh:mm:ss
Ship Date New
Convert Ship Date From:
dd/MM/yyyy hh:mm:ss
ByName
Warning
All
ManualDelayed
Order Date - Ascending
Simple
<=
Order Date
True
fixed
2022-12-21 13:33:22
days
0
2020-11-30
2022-12-21 13:33:22
2022-12-21 13:33:22
ToDate([Order Date]) <= "2020-11-30"
Validation
Warning
All
ByName
True
5.50
5.50
False
13.00
14.95
1x
10
TSCompare_Sales
C:\Users\USER\AppData\Local\Temp\Engine_19812_c461645ad9a3d444aac9b904966dffc2_\Engine_19812_4ee3ab1ec10e534cb0a2d5559f4092d2~.yxdb
Single
Report
C:\Users\USER\AppData\Local\Temp\Engine_19812_c461645ad9a3d444aac9b904966dffc2_\Engine_19812_6f7a4756098b6a40a36f6e8ec601d88f~.yxdb
Single
Report
Forecast
forecast
95
80
6
True
5.50
5.50
False
13.00
14.95
1x
10
TSForecast_Sales
C:\Users\USER\AppData\Local\Temp\Engine_19812_c461645ad9a3d444aac9b904966dffc2_\Engine_19812_f6a8cb8d3fb83e4a85db6be13ef6ae53~.yxdb
Single
Report
C:\Users\USER\AppData\Local\Temp\Engine_19812_c461645ad9a3d444aac9b904966dffc2_\Engine_19812_09352bf697bf3845a3c5732cbda48826~.yxdb
Single
Report
Model Building
ETS
Sales
False
False
False
True
False
False
False
False
True
False
False
True
False
False
False
True
False
False
True
False
False
False
True
False
False
False
False
0.00
False
2012
1
6
True
False
False
True
5.50
5.50
False
13.00
14.95
1x
10
ETS_Sales
ARIMA
Sales
False
"Sales"
True
False
False
False
False
True
False
False
False
False
False
False
0
2
2
False
0
1
1
False
True
False
False
5
False
True
False
0.00
False
0
0
0
0
0
0
False
False
0.00
False
1980
1
6
True
False
False
True
5.00
5.50
False
13.00
14.95
1x
10
ARIMA_Sales
C:\Users\USER\AppData\Local\Temp\Engine_19812_c461645ad9a3d444aac9b904966dffc2_\Engine_19812_3b0c29cbf6ea08469bd8f2da5eabc01f~.yxdb
Single
Report
C:\Users\USER\AppData\Local\Temp\Engine_19812_c461645ad9a3d444aac9b904966dffc2_\Engine_19812_c41cc8e300aa4b4c944f5fa3f433d9e7~.yxdb
Single
Report
Check Trend & Seasonality
Sales
False
False
False
True
False
False
False
False
False
2012
1
True
False
False
False
False
False
True
5.50
5.50
False
13.00
14.95
1x
10
TSPlot_Sales
C:\Users\USER\AppData\Local\Temp\Engine_19812_c461645ad9a3d444aac9b904966dffc2_\Engine_19812_7067b1e69562b14a83f7150c5f1da9ce~.yxdb
Single
Report
Check Normal
Sales=True,Order Date=False
False
True
5000
False
10
FieldSummary_Sales
C:\Users\USER\AppData\Local\Temp\Engine_10504_147e39c20661ef439b239a7a09d12c77_\Engine_10504_3e9c50a07982184ab1ad2616a06b772a~.yxdb
Single
Report
C:\Users\USER\AppData\Local\Temp\Engine_10504_147e39c20661ef439b239a7a09d12c77_\Engine_10504_83c6aead3df3114a9cb72881e2899c5f~.yxdb
Single
Report
C:\Users\USER\AppData\Local\Temp\Engine_10504_147e39c20661ef439b239a7a09d12c77_\Engine_10504_4bd7c30cff61724f90e6fe96e952a201~.yxdb
Single
Report
Horizontal
Lab3_Madina_Adrina