Tableau - using ABS data

abs.txt

1. Search "ABS Housing finance"

2. Download data. TABLE 1. HOUSING FINANCE COMMITMENTS (Owner Occupation), By Purpose: Australia (Number, $000)

3. Clean up unused rows.

4. Pivoting

5. Switch it to month, Adjust Axis range, Add Color, Adjust line size

6. Filter on "Value" only and sort

7. Trend line, remove confidence range

8. Show prediction

9. Running Total to remove seasonality + assitant calculation, put it to quarterly

10. Combine macquarie data