Financial Modeling For Interactive Business Dashboard Using Xcelsius Advanced Techniques

DESKRIPSI

Tujuan :

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 Interactive Business Dashboards untuk keperluan reporting dan sensitivit y & scenario analysis.
4. Menggunakan fungsi-fungsi Xcelsius yang lebih advance.
5. Meng-export Interactive Business Dashboards ke Powerpoint, Word dan PDF, sehingga dashboards dapat dengan mudah didistribusikan kepada divisi-divisi terkait didalam 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
• 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
• Building Dynamic Business Dashboard :
• Building Dashboard for Dynamic Presentation
• Building Dynamic What-If Analysis Dashboard
• Using advance Xcelsius functions

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

Profile detail...