×
Please select your Country

Budgeting and Planning



Duration: 2 days
Audience: Administrator, Implementers IT Professional
Prerequisites: Data Model, Output Reporting, Data Collection, Database file management, basic SQL Scripting Language (recommended)


Objectives: This training course covers the skills necessary to follow the full budgeting process: from data loading, to customization of specific calculation logics through the implementation of advanced calculations (MDX- like). The course will also provide the ability to implement Profitability model leveraging the CCH® Tagetik built-in Allocation Engine. In addition, all skills necessary to create advanced and powerful Excel forms are included.


Topics:

  1. Budgeting Process setup
  2. Advanced Reporting tools:
    1. a. Query Management
    2. b. Data Processing Management
    3. c. Check expressions
    4. d. Spreading and Break back
  3. Assets depreciation tool
  4. Closing & Allocation Process Overview:
    1. a. Rules Structure
    2. b. Allocation Rules and details
    3. c. How to set an Execution Plan and to start data processing
    4. d. C&A Specific Reporting tool
  5. Calculation logics:
    1. a. Standard calculation
    2. b. MDX-like calculation scripting language (TGKML)
    3. c. Forecast Models
    4. d. Rolling Forecast
    5. e. Snapshot Scenarios
    6. f. Monthly Splitting
  6. Tips & Techniques and Best Practices

Persons
CCH Tagetik Office
On-site

1
1.000€

2
2.000€

3
3.000€
3.475€

4
4.000€
4.600€

5
4.500€
5.725€

6
5.400€
6.850€

7
5.950€
7.975€

8
6.800€
9.100€

9
7.650€
10.225€

10
8.500€
11.350€

Want to know more?

Please fill-out the following form for more information about this live training: