Introduction:

• What is EPM, BPC, BI-IP
• Architecture BPC-MS
• Release strategy
• Terminology

Administration :

• Creating Applications and Applying Dimensions
• Architecture of an Application-
• Explain the Tables, Optimization Options and Compression
• Loading Transaction Data using a FlatFile
• Creating a Transformation File
• Creating a conversion file
• Introduction to Logic/Calculations
• Loading and Validating Data
• Working with BPC for Excel
• Developing Reports
• Developing Input Schedules
• BPC Comments
• Book Publication
• Working with BPC Web

• Content Library
• Live Reporting

• Working with BPC for Word and BPC for PowerPoint

• Inserting Objects and Data Values

• Advanced reports using multiple EvDRE.
• Creating Custom Buttons and Assigning Macros
• Advanced Formatting options using Properties
• Demonstrate Building Income Statement, Balance Sheet and Trial Balance reports using EVDRE.
• Demonstrate building a report reading data from multiple applications using EVDRE
• In-depth study on BPC process flows

Planning

• Explain the Planning Process
• Define the planning Model
• Functional Specifications
• Seeding the Plan
• Rolling Forward Forecast
• Calculations using Script Logic
• Calculations Using Worksheet Logic
• Allocations using Script Logic

Consolidations:

• Budgeting System Implementation Overview
• Seeding the Budget
• Defining Modeling Requirements
• Defining and Creating Budget Input Templates
• Creating and Developing Budgeting Business Process Flows
• Creating variance calculation,
• Creating an EVDRE Report and input schedule
• Currency translation, Inter company eliminations
• Expansion, filtering, suppression and indentation in reporting
• Journals: Set Up, Journal Creation, and Journal Reports
• Introduction to Script Logic and Mdx logic
• Intercompany Eliminations Set up
• Intercompany Eliminations using Script Logic
• Currency Conversion – Direct and using script logic
• Competitor Analysis
• Cost Center planning dry run

Additional

• Hot Analysis
• ParknGo
• BPC Journals
• BPC Audit
• Comments
• Custom Menu
• Business Process Flows
• Lab Exercises
• Project Exercises

Security Set up

• Task Profile
• Member Access Profiles
• Users and Teams
• WorkStatus Settings

Using Standard Data manager Packages
Creating Custom Data Manager Packages

• Creating SSIS packages