top of page

Course Overview

This course is an intensive course for the banking and finance industry

in Australia and New Zealand.

The purpose of this package is to analysis the specific functions of consulting and data analysis role in an business practice in Australia and New Zealand through classroom learning and simulation. At the end of the course, students will combine the information and data of real companies to understand the skills required for a entry level consulting and data analyst role.

​

All the course are mentored by senior Consultant and senior Auditor in Australia big four firm or big commercial company. All the mentors have been in the industry more than five years, they focuses on cultivating students's critical skills, logical analysis skills, and summary reporting techniques. 

$950

4 Hours * 4 Sessions

Management Consulting and Data Analysis Package:

Data analysis+Financial Modelling+One Hour One-to-one Service

(Bonus: 50%off Workshop Voucher)

$2000

Save $300

Management Consulting and Data Analysis Premium Package:

Data analysis+Financial Modelling+Excel Immediate

(Bonus: One-to-one Service+50%off Workshop Voucher)

$2200

Save $600

Course Structure

Data Analysis (4 Sessions)

​

• Maniplulate and cleanse raw data sets in tableau and Power Bi

• Learn the basic structure of excel and financial models in tableau and Power Bi

• Using actual models and Data sets in practice in tableau and Power Bi

• Build financial model with the ability to flex different assumptions in tableau and Power Bi

• Build different scenario possibilities and outcome in tableau and Power bi 

• Develop programs that can manipulate static, structured data using the python programming language

• How to work with various data formats within python, including: JSON, HTML, and Excel Worksheets

• Use database with Python and create data visualizations by using Python

• Retrieve data from websites and APIs using Python and understand the protocols web browsers use to retrieve documents and web apps.

​

Excel (2 Sessions)

​

• Pivot Tables & Charts: Create, edit, report and format Pivot Tables/Charts

• Advanced Functions: Logical Functions, SUMIF, COUNTIF, VLOOKUP, HLOOKUP

• What-if Analysis: Goal Seeker, The Solver, Data Tables, MS Query and

Importing text: Extracting data using MS Query, importing data from Text files

​

Resume revise, interview preparation and career consulting ( Session)

•  1 v 1 Career Path Consulting ( 1.5 hours)

Course Cycle

4 weekends study, 16 hours in total

icon-4weeks.png
icon-acc-fun-2.png
icon-16hours.png

Further Information

The course is designed for

• A student or a graduate with a financial and banking industry or Data background
• Working professionals who wish to enter the banking/finance/IT industry
• A person who lacks Australian local financial work experience but wants to work in Australian’s financial or banking or IT industry

Business Analyst | Reporting Analyst | Data Scientist | Quantitative Analyst | Product Analyst | Data Engineer | Graduate Consultant |

Junior Consultant | Junior Business Analyst | Junior Data Analyst | Finance Analyst | Marketing Analyst

More Success Stories

QR1_sydneyQRcode.jpg

SYDNEY

QR2_melbourne.jpg

MELBOURNE

QR5_28.jpg

QLD&WA

TAS&NT Southern Aus

Find us on WeChat!
bottom of page