Faculty of Engineering and Mathematical Sciences 
Not logged in (login)


This forum is provided to promote discussion amongst students enrolled in Data Warehousing (CITS3401).
RSS cloud
Jump to:

There are 15 articles from this person

15 of 259 articles shown, currently no other people reading this forum.

UWA week 22 - 1st semester, week 12

photo Re: features selection (all 4)
Wed 27th May, 11:23pm, ANONYMOUS  O.P.
Thanks zeyi. Also when doing the lift, should the right-hand side attributes which are not only contain the income also consider as top rules? like married=single => country=US/income=low cheers
photo features selection (all 4)
Wed 27th May, 3:24pm, ANONYMOUS
Hi i have few questions 1.After plot the data it shows that working long time would be more likely have higher income. But in my feature selection the rank of working hours is very behind like 8 in 10 features. Would it supports to be like that? 2.After...

UWA week 20 - 1st semester, week 10

photo project mark (both)
Mon 11th May, 4:09pm, ANONYMOUS
Hi Would the individual mark be marked down when doing in pair if the outcome of the project is actually similar, comparing with only one person completing it. cheers

UWA week 18 - 1st semester, week 8

photo python library in final project (both)
Fri 1st May, 5:55pm, ANONYMOUS
Hi Can we use machine learning library in python to do the final project such as sklearn , k-fold validation...? cheers

UWA week 17 - 1st semester, week 7

photo Re: Concept Hierarchies (all 8)
Wed 22nd Apr, 8:48pm, ANONYMOUS
ANONYMOUS wrote: I think you can have hierarchy even they’re not related. You could see the design in the lab and mid test answers also have such dimensions. It is meaningful such as you group up the data as the gender first then as the age.
photo Business query question (both)
Tue 21st Apr, 8:17pm, ANONYMOUS
Hi Can a business query question be inquiry question? Like “what is the relationship between work hours and salary?” so on. Cheers

UWA week 16 - 1st semester, mid-semester break

photo Re: Fact Tables (all 3)
Sun 19th Apr, 1:39pm, ANONYMOUS
Hi I also use python to create the fact table. I insert the self-created features back to the original dataset and use if statement to compare every conditions in a specific dimension table. Then return the corresponding index as the id. I also used python...
photo Dimension (all 3)
Sat 18th Apr, 11:35pm, ANONYMOUS
Hi Should a dimension must can be rolled up or drilled down? Such as a dimension includes country, gender and occupation. Thanks
photo Dimension table (both)
Fri 17th Apr, 2:30pm, ANONYMOUS
Hi Does a dimension table can contain the combinations which have no matching data in the whole dataset? Like can I have a dimension table include "male,Japan,old" but there is no data would match this requirement. Thanks
photo Re: project requirement (all 3)
Thu 16th Apr, 12:53am, ANONYMOUS  O.P.
Thanks Zeyi
photo project requirement (all 3)
Wed 15th Apr, 4:35pm, ANONYMOUS
Hi, I have some question about the project requirements 1. There is a 5 marks for SQL script for building the database in the marking scheme. Does this only require us to create the database but not doing the SQL scrip to populate tables? if so, do we...
photo Re: starnet design (all 4)
Wed 15th Apr, 3:53pm, ANONYMOUS  O.P.
so does this mean is ok to directly use the original data in analysing? like Education part do I gain more mark to summarise the data such as "primary school, high school, university" and so on? Or it is ok to directly use the raw data in generating dimension...
photo starnet design (all 4)
Wed 15th Apr, 2:22pm, ANONYMOUS
Hi For the description of the second project, it says 'Draw a StarNet with the aim to identify the dimensions and concept hierarchies for each dimension. This should be based on the lowest level information you have access to.' Would this mean that I can...

UWA week 12 - 1st semester, week 4

photo Re: lab4 question (all 4)
Fri 20th Mar, 6:35pm, ANONYMOUS  O.P.
thanks. I used the provided sql script to build the table then using the bulk insert would function normally.
photo lab4 question (all 4)
Thu 19th Mar, 10:19pm, ANONYMOUS
Hi I followed lab4 of bulk insert process, which is step 7, but failed by reported Unexpected NULL value in column1, even commanded out the KEEPIDENTITY. Did anyone encounter same situation as me? Thanks
This Page

Program written by: [email protected]
Feedback welcome
Last modified:  8:27am May 24 2020