====== Week 003 ======





===== Wednesday 30 June 2021 =====

==== ??? ====



===== Tuesday 29 June 2021 =====

==== Ananda ====

Excel workshop
  * Clean up data
    * Double-click at bottom-right of cell to auto-populate column
  * Pivot Table
    * Excel auto-generates Year and Quarter fields according to when a date field is added
  * RRI/RATE: CAGR
  * Charting


===== Monday 28 June 2021 =====

==== Herbert Lian ====

=== Modelling & Analysis ===


Problem - Model - Solution
Model:
  * Data and Assumptions
  * Calculation logic
  * Output

Flow of model design always flows backwards

Problem is the result of SCQ
Model essentially validates or invalidates the hypotheses generated
Solution ...


Four Steps:
  * Define
  * Design
  * Build
  * Validate


Recommendaton must be:
  * actionable
  * specific
  * insightful