Shaping the future

The journey towards business partnership

Power BI Modeling

Excel Modeling

Data Modeling

EOFY SALES

1 Person $1499

Days
Hours
Minutes
Seconds

15 DAYS EXCEL MODELING ( 8 Hrs / Day )

15 DAYS POWER BI MODELING ( 8 Hrs / Day )

30 DAYS 240 HOURS INTENSIVE TRAINING

30 门主修课随便听 | 年底有效 | 线上线下 交叉学习

15 Days Excel Modeling + 15 Days Power BI Modeling = 240 Training Hours

AA Package

  • Month End Closing
  • Month End Procedures
  • Year End Closing
  • BS Reconciliation
  • Excel Data Modelling
  • Act vs Bud VAR Review

FA Package

  • Power Query Reporting
  • Act vs Bud VAR BI Model
  • Analysing Statements
  • Statements Dashboard
  • Consolidation Reporting
  • Time Intelligence Report

MA Package

  • Budgeting Sales & COGS
  • Budgeting OPEX & DEPN
  • Budgeting CAPEX
  • Forecasting - Cash Flow
  • Forecasting - P&L and B/S
  • Forecasting - Sales Model

CA Package

  • Commercial Case Study
  • BI Sales Data Modelling
  • BI Dashboard Reporting
  • BI Costing Modelling
  • BI KPI OLAP Modelling
  • Commercial BI Scenario

BI Package

  • BI DAX Aggregation
  • BI DAX Calculate()
  • BI DAX Table Function
  • BI Advanced Relationship
  • BI Context Evaluation
  • BI Dimension & Hierarchies

What We teach

Closing

Outlines the typical month end processing timetable, responsibilities and tasks which need to be undertaken to transform the financial information from the trial balance to key financial reports.

Reporting

Outlines the review steps taken to ensure the accuracy and reasonability of the financial statements by reviewing actual v budget variance analysis and multi-dimensional checking.

Analysing

Identifies the key techniques used to analyze the financial statements. Various analytical frameworks are used to understand the drivers of change in the business performance. s.

Budgeting

Includes business strategy, financial objectives, sales and expense budget templates, letter of guidance and instructions, budget collation worksheet, budget analysis and approval.

Forecasting

Will be developed to include a rollover forecast with appropriate medium financial and business targets. Scenario forecasts and relevant management playbooks will be identified .

Cash Flow

Cash flow Models will include debtors’ receipts, salaries & wages, OPEX, and CAPEX. Various forecast scenarios will be developed as well as identifying financing techniques and skills.

ERP System

Excel Model

Case Study

Power BI Model

TM1 Model

Dashboard Report Demo

100% Experience the real-life working environment

Experience the environment
in the SAP-ERP system

Apply industry benchmark
level best practices

Over 200 Corporate and
listed company case studies

Combine working knowledge
BI and Excel modelling skills

What you get

Uppgrade your accounting skills to next level

Free Consulting

Our experienced consultant’s will
help you identify the skill gaps for your next move.

CPD Certificate

A formal company letter will be issued to you
after class to help you claim your CPD hours.

Free Resume Edit

Our experienced consultants will help you
edit your resume before you apply for new job.

Free ERP Tutorial

Our tutor will help you experience ERP
system in the real-life working environment.
Total Students
Public Courses
Free Seminars
Attendants