Click the green code button.
Click the clipboard icon.
Start Rstudio>File>New Project>Version Control>Git
Control-V to paste the repository URL, choose a directory for the project on your local drive (LAN too slow)
Create Project
Create sub-directories raw_data and processed_data.
Get following files from 4CastViewer and place in raw_data.
Raw Emp single variables.csv (occBC4dei211JTT) Select All occupations, All industries, All Characteristics (only Employment), All areas (8 areas selected), and CSV: Single Variables.
Raw JO single variables.csv (occBCjoi4d211JTT). Select All occupations, All industries, All Characteristics (5 variables), All areas (8 areas selected) and CSV: Single Variables.
Raw DS single variables.csv (occBC4dsd211JTT). Select All occupations, All industries, All Characteristics, All areas (5 areas) and CSV: Single Variables.
ask Feng or Nicole for current versions of the following files, place in raw_data.
Source file 01_source_me_process_data.R (saves output to processed_data)
Optional:
Retrieve last year's tableau file from Y:\Labour Economics\BC Labour Market Outlook\20xx Edition (20xx-20xx)\Tableau\LMO_tableau_tool_20xx.twbx and place in project directory. (where xx is last year)
Open tableau, grab a coffee.
Click on data, and then for each of the listed data sources click update data source. (sometimes doesnt work first time, but then does???)
Once you have updated all the data sources click refresh all extracts (just to check)
Take a look through the tableau file... when you see a blank screen most likely due to with filter and/or dates not being correct
Once everything is working copy the whole directory over to the LAN.