Каталог курсов

Курсы IBM

IBM Cognos Planning Analyst: построение моделей (V10.1)

 
Код курса  Код: P8101    Заявка  Предварительная запись    Продолжительность  Кол-во часов: 40 , Кол-во дней: 5

IBM.gif

Подробное описание курса.

Description


IBM Cognos Planning Analyst: Build Models (V10.1) is a five-day, instructor led course that teaches modelers how to design and build models for business planning. Participants will learn the data modeling process and participate in hands-on demos and workshops that illustrate good model design and best practice techniques while learning how to use the product.

Objectives


Please refer to course description.

Audience


This course is intended for Modelers.

PreRequisites


You should have:

  • Knowledge of your organization's data and structure
  • Knowledge of Microsoft Excel

Topics


  1. Introduction to IBM Cognos Planning Analyst
    • Examine the components of the IBM Cognos Planning solution
    • Discuss libraries, D-Lists, D-Cubes, and D-Links
    • Create libraries
  2. Create D-Lists and D-Cubes
    • Manually create D-Lists
    • Import D-List items from external sources
    • Modify D-Lists
    • Build D-Cubes
  3. Load Data
    • Determine what can be used as source data
    • Create file maps to assist in loading data
    • Load data from an external source into a D-Cube
    • Load data from one D-Cube to another
  4. Enhance D-Lists and D-Cubes
    • Prevent calculations on a D-List item
    • Control user input using a formatted D-List
    • Use Built-in Functions (BiFs) to calculate data
    • Use time averages in a D-List
    • Use weighted averages in a D-List
    • Apply conditional formulas to a D-List
  5. Distribute Data
    • Use a D Cube to allocate data
    • Summarize D Cube data with Accumulation D Links
    • Populate a D Cube based on text in the target D Cube using Lookup D Links
  6. Create and Distribute an Income Statement
    • Determine the requirements for building and populating an income statement
    • Discuss various methods of depreciation
    • Calculate depreciation using a Built-in Function
    • Export income statement data
  7. Forecast Data
    • Examine the Forecast Built-in Function
    • Build a revised rolling forecast
    • Use various methods to forecast data
  8. Automate Processes
    • Use D List and D Cube update links to update structure and data
    • Create macros to automate the update process
    • Enhance macros functionality
    • Record a macro to perform repetitive tasks
  9. Object Maintenance and Administration
    • Examine IBM Cognos security
    • Add and maintain libraries
    • Apply security to a library or object
    • Add, remove, and modify objects
    • Create copies of objects and libraries
    • Discuss features that affect performance
  10. Use Complex Calculations
    • Move values through periods using the FeedParam Built-in Function
    • Round values using TRound Built-in Function
    • Examine Tier calculations
    • Calculate balances based on profiles
  11. Examine Advanced Concepts
    • Discuss calculation precedence
    • Restructure D Cubes
    • Transfer data within a D Cube
    • Examine cascading allocations
  12. Design for Reporting
    • Explore the tools available for reporting on Planning Analyst data
    • Design a model for reporting purposes
    • Publish objects for external reporting
    • Make published data available for reporting in IBM Cognos
    • Create a report based on Planning Analyst published data
    • Populate a D-Cube using IBM Cognos as a datasource
  13. Enhance Functionality Using the IBM Cognos Planning Analyst Add-in for Microsoft Excel
    • Examine the IBM Cognos Planning Analyst Add-in for Microsoft Excel
    • Build views
    • Update views
    • Create and use templates for data entry
    • Format and customize Microsoft Excel spreadsheets
    • Update reports
    • Examine batch printing
  14. Illustrate the Model Using IBM Cognos Planning Manager
    • Design reports
    • Create a flowchart
    • Link the flowchart to objects in IBM Cognos Planning Analyst
    • Create tables
  15. End-to-End Workshop (Optional)
  16. Use IBM Cognos Planning Analyst with IBM Cognos Planning Contributor (Optional)
  17. Use IBM Cognos Planning Analyst with IBM Cognos Finance (Optional)

Место проведения мероприятия: г. Киев пр., В. Лобановского, 4г IBM Cognos Planning Analyst: построение моделей (V10.1) +380444922929
Время проведения: Уточняйте
Ссылка курса обучения
Назад в раздел





Для предварительной записи на курсы или
уточнения информации позвоните по телефонам:
(044) 492-29-29, 594-98-98
e-mail: training@muk.com.ua

Или заполните заявку online.

Свежие новости

19.06.2017 Авторизованные курсы Microsoft на базе Учебного центра МУК


Учебный центр МУК - Silver Learning Partner Microsoft - приглашает всех желающих стать участником авторизованных курсов Microsoft согласно ближайшего расписания. 

01.06.2017 Открыт набор на курс «Виртуализация серверов с Windows Server Hyper-V и System Center»
Учебный центр МУК обладая статусом Silver Learning Partner Microsoft объявляет набор на курс «Виртуализация серверов с Windows Server Hyper-V и System Center», который состоится с 06 по 09 июня 2017 года.

21.05.2017 Снова лучшие: Dell EMC награждает МУК
Группа компаний МУК получила две награды на Dell EMC Partner Awards 2017

17.05.2017 HPE Education Brunch 2017
Учебный центр Группы компаний MUK при поддержке НРE Украина уже традиционно приглашает желающих стать участниками HPE Education Brunch 2017