课程一：Analyst basics

Part 1: Data cleansing: Database/Datawarehouse

• 大数据时代 big data如何管理，提取，保存，更新，并非想象的简单。如何从传统的 Database Access SQL过渡到 cloud based data warehouse。
• BA的原材料：data。在做任何分析之前，如何 cleansing处理 raw data成为 BA可以用来分析推敲的 useful data，需要经过一些特殊的处理。

案例 1： FMCG market leader: database management

案例 2：FMCG market leader: data cleansing/transforming

• 完成准备分析所需的 data和 backup。

Part 2: Data modelling and analysis

• 分析是从何开始的 -前序工作 prepare to analyse：where do we start.
• Data Analysis models: natural model, logical model, business requirement model, stakeholder model.

案例 1：FMCG: natural model 案例 2：FMCG: logical model

案 例 3: FMCG: business requirement model

案 例 4: FMCG: stakeholder model

Part 3: Reporting and design:

案例 1 FMCG market leader：如何设计和改进 Monthly Reporting Pack (P&L, Forecast, waterfall chart,

top vendors, non-financial by commodity summary, by vendor summary, special case study analysis, business improvement opportunities)

Part 4: Tools and systems:

• Power pivot
• Power query
• SmartView
• Power BI

课程二：Financial Planning and Budgeting Analysis

Part 1：Understand budget and Financial Modelling

• Budget and Business Strategy
• Financial planning and Financial Modelling如何建模
• Pre-budget analysis to support budgeting预算前期准备分析

案例 1： ASX 50 Commercial Property：Pre-budget analysis for Property Portfolio Budget FY18模型分析

案例 2：FMCG market leader： Pre-budget analysis for Supply Chain Budget FY19模型分析

Part 2: Budgeting Analytics

• Budgeting process milestones
• Analysis to support each milestone

  案例 1：ASX 50 Commercial Property：Budget流程解析，如何在每一个 budget milestone具备所需的信息，通过 driver tree做出正确的数据分析来支持预算的准确性。

案例 2：FMCG market leader：Budget流程分析，如何安排不同阶段预算进程所需的分析，以及他们之间的逻辑顺序。

Part 3: Fixing budget – Forecasting

• Rolling Forecasting Analysis and modelling

案例 1：FMCG market leader: Supply Chain DC Forecasting Model and driver analysis

课程三：Operational Analysis

• Understand business operations

案例 1：FMCG market leader：truly understand your business，Balance Scorecard approach

• Operational data
• Operational KPI matrix
• Solving puzzles - ad hoc operational analysis

案例 2：ASX 50 Commercial Property : Centre traffic analysis (基本的 operational analysis) 

案例 3：FMCG market leader: Supply Chain Freight utilisation analysis (行业基础分析）

案例 4：FMCG market leader: DC operational analysis (operational performance analysis)

案例 5：学生实际操作，老师课前提供 3个案例和 raw data，学生通过逻辑分析，做出相应的分析操作和结果，以及提供解决问题的方案。