["UPDATE_PROJECT","ppt"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version - 1"]

["UPDATE_PROJECT","ppt"]

Modified thumbnail.png

["UPDATE_VIZ","Assessment 1 ASX Data - Student Version - 1","Chart 3"]

["CACHE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Aggregate (Summarize) Data"]

["CREATE_VIZ","Assessment 1 ASX Data - Student Version - 1","Chart 3"]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Aggregate (Summarize) Data","Group(industry ), Value('Share Price % Change ' (Mean))"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","'industry ' = casewhen(\n 'company name' %in% c(\"Rio Tinto\", \"Fortescue\", \"BHP\"…))"]

["UPDATE_VIZ","Assessment 1 ASX Data - Student Version - 1","Chart 2"]

["CACHE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Remove Duplicated Rows"]

["CREATE_VIZ","Assessment 1 ASX Data - Student Version - 1","Chart 2"]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Remove Duplicated Rows","company name"]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","'Share Price % Change ' = ( Close[Date == max(Date)] - Close[Date == min(Date)] …)"]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Group By","'company name'"]

["DELETE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Group By","'company name'"]

["DELETETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","calculation1 = (Close[Date == max(Date)] - Close[Date == min(Date)]) / Close[Da…"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","calculation1 = (Close[Date == max(Date)] - Close[Date == min(Date)]) / Close[Da…"]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Group By","'company name'"]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Rename Columns","close -> Close"]

["DELETETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","calculation1 = (close[Date == max(Date)] - close[Date == min(Date)]) / close[Da…"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","calculation1 = close"]

["UPDATE_VIZ","Assessment 1 ASX Data - Student Version - 1","Chart 1"]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Fill NA with Previous / Next Row","Columns: volume, Type: Previous Row Value"]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Fill NA with Previous / Next Row","Columns: 'adj. close', Type: Previous Row Value"]

["UPDATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Filter","Date 'Remove NA' and high 'Remove NA' "]

["CACHE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Filter"]

["UPDATE_VIZ","Assessment 1 ASX Data - Student Version - 1","Chart 1"]

["CREATE_VIZ","Assessment 1 ASX Data - Student Version - 1","Chart 1"]

["UPDATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Filter","Date 'Remove NA' and high 'Remove NA' and volume 'Keep Only NA' "]

Modified Lss4NRX7.json

Modified Lss4NRX7.json

["UPDATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Filter","Date 'Remove NA' and high 'Remove NA' "]

["CREATE_TRANSFORM","Assessment 1 ASX Data - Student Version - 1","Filter","Date 'Remove NA' "]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","volume = parsenumber(volume)"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","'adj. close' = parsenumber('adj. close')"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","close = parsenumber(close)"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","low = parsenumber(low)"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","high = parsenumber(high)"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","open = parsenumber(open)"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Create Calculation","Date = excelnumerictodate(Date)"]

["CREATETRANSFORM","Assessment 1 ASX Data - Student Version - 1","Rename Columns","id -> company name, X1 -> Date, X2 -> open, X3 -> high, X4 -> low, X_6 …"]

["CREATEDATAFRAME","Assessment 1 ASX Data - Student Version - 1","Excel - Local"]

Modified Lss4NRX7_Source1.json

Modified Lss4NRX7.xlsx

Modified Lss4NRX7.metadata.json

Modified Lss4NRX7.sample_data.json

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_Westpac"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_TPG"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_Telstra"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_Rio Tinto"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_NAB"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_Fortescue"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_CBA"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_BHP"]

Removed project data files

["DELETEDATAFRAME","Assessment 1 ASX Data - Student Version_Aussie Broadband"]

["CREATEDATAFRAME","Assessment 1 ASX Data - Student Version_Aussie Broadband","Excel - Local"]

Modified AZy6Vzq8_Source1.json

Modified AZy6Vzq8.xlsx

Modified AZy6Vzq8.metadata.json

Modified AZy6Vzq8.sample_data.json

["CREATEDATAFRAME","Assessment 1 ASX Data - Student Version_TPG","Excel - Local"]

Modified JVs9Ddp9_Source1.json

Modified JVs9Ddp9.xlsx

Modified JVs9Ddp9.metadata.json

Modified JVs9Ddp9.sample_data.json

["CREATEDATAFRAME","Assessment 1 ASX Data - Student Version_Telstra","Excel - Local"]

Modified QoO3GQh1_Source1.json

Modified QoO3GQh1.xlsx

Modified QoO3GQh1.metadata.json

Modified QoO3GQh1.sample_data.json

["CREATEDATAFRAME","Assessment 1 ASX Data - Student Version_Westpac","Excel - Local"]

Modified gbq5tyE5_Source1.json

Modified gbq5tyE5.xlsx

Modified gbq5tyE5.metadata.json

Modified gbq5tyE5.sample_data.json

["CREATEDATAFRAME","Assessment 1 ASX Data - Student Version_NAB","Excel - Local"]

Modified YRj7JGa7_Source1.json

Modified YRj7JGa7.xlsx

Modified YRj7JGa7.metadata.json

Modified YRj7JGa7.sample_data.json

["CREATEDATAFRAME","Assessment 1 ASX Data - Student Version_CBA","Excel - Local"]

Modified eXy4THT5_Source1.json

Modified eXy4THT5.xlsx

Modified eXy4THT5.metadata.json

Modified eXy4THT5.sample_data.json

["CREATEDATAFRAME","Assessment 1 ASX Data - Student Version_BHP","Excel - Local"]

Modified lXr3QBD4_Source1.json

Modified lXr3QBD4.xlsx

Modified lXr3QBD4.metadata.json