Financial Modeling for Building Business Dashboard Using Xcelsius (Fundamental)

DESKRIPSI

Memperoleh pemahaman dan ketrampilan untuk:

1. Mempersiapkan financial model yang dibangun menggunakan Excel yang kemudian akan digunakan oleh Xcelsius sebagai dasar untuk mendisain Interactive Business Dashboard.
2. Menggunakan komponen-komponen pada Xcelsius.
3. Mendisain Business Dashboards sederhana untuk keperluan reporting dan sensitivit y & scenario analysis.
4. Mengexport Interactive Business Dashboards ke Powerpoint, Word dan PDF, sehingga dashboards dapat dengan mudah didistribusikan kepada divisi-divisi terkait di dalam perusahaan.

Syllabus :

• Introduction to Dynamic Business Dashboards
• What is a SAP Dashboard Design (Xcelsius)? How does it work?
• Sample Crystal Xcelsius ? Different by application?
• Relationship between Excel & Xcelsius
• Supported Excel Functions
• Principles of a good design ? best practice? Crystal Xcelsius elements
• The canvas
• The component list & categories
• The component properties (General, Behavior, Appearance)
• Modeling Dynamic Business Dashboard
• Importing underlying spreadsheet
• Working with canvas, components and properties
• Creating dynamic what-if analysis dashboard (Creating dynamic dashboard for profitability analysis)
• Assessing the company profitability
• Setting Scenarios
• Export interactive business dashboard to Powerpoint, Word dan PDF, for easy distribution to other people

Siapakah yang harus hadir :

• CFOs
• Directors / Managers of Strategic Planners
• Financial Controllers
• Financial Analysts
• Financial Officers
• Financial/ Accounting Staffs
• Corporate Finance Personnel
• Treasury Personnel
• Risk Managers
• General Managers

Waktu :

• 2 hari kerja, 09.00 am ? 05.00 pm, diselingi 2 kali coffee break dan 1 kali istirahat makan siang

Course Leader :

Irwin Ibrahim

More...